Hello

We have installed the Discussion Thread component and I am having a
problem with it and the Subscription notification.

I have a subscription set to notify me when a Discussion has been
started or updated.

When I receive the subscription email and I click ont the link to
the document I get the following error.

Content Server Request Failed
Unable to retrieve file. The relative URL does not start with the
prefix /VStellent/.

The redirect URL it uses is http://vstellent/vstellent/..../doc.hscp
If I change in manually to http://vstelletn/VStellent/.../doc.hscp
It works fine. I don't have to do this with any other subscriptions,
only with the Discussion Thread items.


Any clue why? or what I need to do to fix this.

Hello
I have got a document with Expiry Date set to : 4/30/03 1:55 PM

My question is :
How do I get this document using Search in Stellent...(I can see it only
via Repository Manager)

and ofcourse my age old question :
How to get Expired documents in Search Result using JSPs...

Best Regards
Dhruba

I'm not sure Dhruba - i will also need to provide a searchable expired documents
feature. If I cannot learn how to achieve this with Verity/Stellent then I will
end up going direct to the database table Revisions and getting them myself!

ADC

  -----Original Message-----
From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
Sent: 05 January 2004 10:53
To: intradoc
Subject: [intradoc_users] Expired documents in Search.



Hello
I have got a document with Expiry Date set to : 4/30/03 1:55 PM

My question is :
How do I get this document using Search in Stellent...(I can see it only
via Repository Manager)

and ofcourse my age old question :
How to get Expired documents in Search Result using JSPs...

Best Regards
Dhruba



Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]

Just a suggestion but if you have a need to search for expired
documents on a regular basis then you should redesign your
architecture to use a different metadata field to remove a document
from general availability on a web site but still leave it available
for searching. This is a lot simpler and avoids unintended issues.

--- In intradoc_users@yahoogroups.com, "Allistair Crossley"
<allistair.crossley@q...> wrote:
> I'm not sure Dhruba - i will also need to provide a searchable
expired documents feature. If I cannot learn how to achieve this
with Verity/Stellent then I will end up going direct to the database
table Revisions and getting them myself!
>
> ADC
>
>  -----Original Message-----
> From: Dhruba Banerjee [mailto:dhruba.banerjee@t...]
> Sent: 05 January 2004 10:53
> To: intradoc
> Subject: [intradoc_users] Expired documents in Search.
>
>
>
> Hello
> I have got a document with Expiry Date set to : 4/30/03 1:55 PM
>
> My question is :
> How do I get this document using Search in Stellent...(I can see
it only
> via Repository Manager)
>
> and ofcourse my age old question :
> How to get Expired documents in Search Result using JSPs...
>
> Best Regards
> Dhruba
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>
>   _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/intradoc_users/
>
>
> * To unsubscribe from this group, send an email to:
> intradoc_users-unsubscribe@yahoogroups.com <mailto:intradoc_users-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
> -------------------------------------------------------
> QAS Ltd.
> Developers of QuickAddress Software
> <a href="http://www.qas.com">www.qas.com</a>
> Registered in England: No 2582055
> Registered in Australia: No 082 851 474
> -------------------------------------------------------
> </FONT>
>
>
>
> [Non-text portions of this message have been removed]

Hi ADC
even then (i.e getting dIDs of Expired docs from revision table)..how do
we get more details about  them ??

I mean I tried a Search like "dID= <ID of a Expired doc> "...but didn't
get any result...

David's workaround also seems nice..just that I am getting too emotional
with the fact that "WHY IS STELLENT NOT PROVIDING  SUCH A FEATURE" !!!

Regards
Dhruba

Allistair Crossley wrote:

>  I'm not sure Dhruba - i will also need to provide a searchable
> expired documents feature. If I cannot learn how to achieve this with
> Verity/Stellent then I will end up going direct to the database table
> Revisions and getting them myself!
>
> ADC
>
> -----Original Message-----
> From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
> Sent: 05 January 2004 10:53
> To: intradoc
> Subject: [intradoc_users] Expired documents in Search.
>
>
>
> Hello
> I have got a document with Expiry Date set to : 4/30/03 1:55 PM
>
> My question is :
> How do I get this document using Search in Stellent...(I can see it
> only
> via Repository Manager)
>
> and ofcourse my age old question :
> How to get Expired documents in Search Result using JSPs...
>
> Best Regards
> Dhruba
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>
>   _____
>
> Yahoo! Groups Links
>
>
> *      To visit your group on the web, go to:
> http://groups.yahoo.com/group/intradoc_users/
>
>
> *      To unsubscribe from this group, send an email to:
> intradoc_users-unsubscribe@yahoogroups.com
> <mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
>
> *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
> -------------------------------------------------------
> QAS Ltd.
> Developers of QuickAddress Software
> <a href="http://www.qas.com">www.qas.com</a>
> Registered in England: No 2582055
> Registered in Australia: No 082 851 474
> -------------------------------------------------------
> </FONT>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>                    Yahoo! Groups Sponsor
                         ADVERTISEMENT
                          [click here]

>
>     ---------------------------------------------------------------
> Yahoo! Groups Links
>
>    * To visit your group on the web, go to:
>      http://groups.yahoo.com/group/intradoc_users/
>
>    * To unsubscribe from this group, send an email to:
>      intradoc_users-unsubscribe@yahoogroups.com
>
>    * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>      Service.
>


[Non-text portions of this message have been removed]

If you went to the database you could get a lot of info with the query..

SELECT *
FROM Revisions r, DocMeta m, Documents d
WHERE (r.dStatus = 'EXPIRED') and r.dID = m.dID and r.dID = d.dID and r.dID =
1234

This gets back pretty much everything I think you would need. Check out the 3
tables above to see the columns you would get.

I do agree that this is not great to have to do though, but nevertheless an
alternative.

You won't get anything in search results just by using the dID of an expired doc
as the expired docs I don't think are indexed anymore.

ADC

  -----Original Message-----
From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
Sent: 05 January 2004 11:43
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Expired documents in Search.



Hi ADC
even then (i.e getting dIDs of Expired docs from revision table)..how do
we get more details about  them ??

I mean I tried a Search like "dID= <ID of a Expired doc> "...but didn't
get any result...

David's workaround also seems nice..just that I am getting too emotional
with the fact that "WHY IS STELLENT NOT PROVIDING  SUCH A FEATURE" !!!

Regards
Dhruba

Allistair Crossley wrote:

>  I'm not sure Dhruba - i will also need to provide a searchable
> expired documents feature. If I cannot learn how to achieve this with
> Verity/Stellent then I will end up going direct to the database table
> Revisions and getting them myself!
>
> ADC
>
> -----Original Message-----
> From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
> Sent: 05 January 2004 10:53
> To: intradoc
> Subject: [intradoc_users] Expired documents in Search.
>
>
>
> Hello
> I have got a document with Expiry Date set to : 4/30/03 1:55 PM
>
> My question is :
> How do I get this document using Search in Stellent...(I can see it
> only
> via Repository Manager)
>
> and ofcourse my age old question :
> How to get Expired documents in Search Result using JSPs...
>
> Best Regards
> Dhruba
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>
>   _____
>
> Yahoo! Groups Links
>
>
> *      To visit your group on the web, go to:
> http://groups.yahoo.com/group/intradoc_users/
>
>
> *      To unsubscribe from this group, send an email to:
> intradoc_users-unsubscribe@yahoogroups.com
> <mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
>
> *      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service < http://docs.yahoo.com/info/terms/> .
>
>
>
>
> <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
> -------------------------------------------------------
> QAS Ltd.
> Developers of QuickAddress Software
> <a href=" http://www.qas.com">www.qas.com</a>
> Registered in England: No 2582055
> Registered in Australia: No 082 851 474
> -------------------------------------------------------
> </FONT>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>                    Yahoo! Groups Sponsor
                         ADVERTISEMENT
                          [click here]

>
>     ---------------------------------------------------------------
> Yahoo! Groups Links
>
>    * To visit your group on the web, go to:
>      http://groups.yahoo.com/group/intradoc_users/
>
>    * To unsubscribe from this group, send an email to:
>      intradoc_users-unsubscribe@yahoogroups.com
>
>    * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>      Service.
>


[Non-text portions of this message have been removed]



Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
 
<http://rd.yahoo.com/SIG=12ct3s4ha/M=267637.4116719.5338353.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073389421/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116719> click here
  
<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmail/S=\
:HM/A=1853618/rand=678552676>


   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

Allistair is correct, you couldn't get it because it's not there!

To Stellent this is probably not a viable "feature" as to leave it
would result in a performance degradation over time. And more
importantly most customers do not want a search to return old
information, lawsuits are built on that. Plus it's easy to design an
intentional workaround depending on your requirements.

So you have to resort to using the database, and then hoping that
the sysadmin has not set up an archiving policy that removes all
expired documents from the collection, which is a common realworld
requirement at many companies.

So again the best solution may be to not expire but retire.
Alternately if you have a multitiered architecture then you can
expire at the Consumption level but leave available at the
Contribution level. Many other options can be designed including
pushing expired documents out to a LMC collection that is
labeled "expired" so you can still full text search it but not
mingle it with current content.

Version 7 will give you more options in doing a database only search
in Stellent which should be explored.

--- In intradoc_users@yahoogroups.com, "Allistair Crossley"
<allistair.crossley@q...> wrote:
> If you went to the database you could get a lot of info with the
query..
>
> SELECT *
> FROM Revisions r, DocMeta m, Documents d
> WHERE (r.dStatus = 'EXPIRED') and r.dID = m.dID and r.dID = d.dID
and r.dID = 1234
>
> This gets back pretty much everything I think you would need.
Check out the 3 tables above to see the columns you would get.
>
> I do agree that this is not great to have to do though, but
nevertheless an alternative.
>
> You won't get anything in search results just by using the dID of
an expired doc as the expired docs I don't think are indexed
anymore.
>
> ADC
>
>  -----Original Message-----
> From: Dhruba Banerjee [mailto:dhruba.banerjee@t...]
> Sent: 05 January 2004 11:43
> To: intradoc_users@yahoogroups.com
> Subject: Re: [intradoc_users] Expired documents in Search.
>
>
>
> Hi ADC
> even then (i.e getting dIDs of Expired docs from revision
table)..how do
> we get more details about  them ??
>
> I mean I tried a Search like "dID= <ID of a Expired doc> "...but
didn't
> get any result...
>
> David's workaround also seems nice..just that I am getting too
emotional
> with the fact that "WHY IS STELLENT NOT PROVIDING  SUCH A
FEATURE" !!!
>
> Regards
> Dhruba
>
> Allistair Crossley wrote:
>
> >  I'm not sure Dhruba - i will also need to provide a searchable
> > expired documents feature. If I cannot learn how to achieve this
with
> > Verity/Stellent then I will end up going direct to the database
table
> > Revisions and getting them myself!
> >
> > ADC
> >
> > -----Original Message-----
> > From: Dhruba Banerjee [mailto:dhruba.banerjee@t...]
> > Sent: 05 January 2004 10:53
> > To: intradoc
> > Subject: [intradoc_users] Expired documents in Search.
> >
> >
> >
> > Hello
> > I have got a document with Expiry Date set to : 4/30/03 1:55 PM
> >
> > My question is :
> > How do I get this document using Search in Stellent...(I can see
it
> > only
> > via Repository Manager)
> >
> > and ofcourse my age old question :
> > How to get Expired documents in Search Result using JSPs...
> >
> > Best Regards
> > Dhruba
> >
> >
> >
> > Post message: intradoc_users@yahoogroups.com
> > Subscribe:  intradoc_users-subscribe@yahoogroups.com
> > Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> > List owner:  intradoc_users-owner@yahoogroups.com
> >
> >
> >
> >
> >   _____
> >
> > Yahoo! Groups Links
> >
> >
> > *      To visit your group on the web, go to:
> > http://groups.yahoo.com/group/intradoc_users/
> >
> >
> > *      To unsubscribe from this group, send an email to:
> > intradoc_users-unsubscribe@yahoogroups.com
> > <mailto:intradoc_users-unsubscribe@yahoogroups.com?
subject=Unsubscribe>
> >
> >
> >
> > *      Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> > Service < http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> >
> > <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
> > -------------------------------------------------------
> > QAS Ltd.
> > Developers of QuickAddress Software
> > <a href=" http://www.qas.com">www.qas.com</a>
> > Registered in England: No 2582055
> > Registered in Australia: No 082 851 474
> > -------------------------------------------------------
> > </FONT>
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Post message: intradoc_users@yahoogroups.com
> > Subscribe:  intradoc_users-subscribe@yahoogroups.com
> > Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> > List owner:  intradoc_users-owner@yahoogroups.com
> >
> >
> >
> >                    Yahoo! Groups Sponsor
>                         ADVERTISEMENT
>                          [click here]
>
> >
> >     -------------------------------------------------------------
--
> > Yahoo! Groups Links
> >
> >    * To visit your group on the web, go to:
> >      http://groups.yahoo.com/group/intradoc_users/
> >
> >    * To unsubscribe from this group, send an email to:
> >      intradoc_users-unsubscribe@yahoogroups.com
> >
> >    * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> >      Service.
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Post message: intradoc_users@yahoogroups.com
> Subscribe:  intradoc_users-subscribe@yahoogroups.com
> Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
> List owner:  intradoc_users-owner@yahoogroups.com
>
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
<http://rd.yahoo.com/SIG=12ct3s4ha/M=267637.4116719.5338353.1261774/D
=egroupweb/S=1705375618:HM/EXP=1073389421/A=1853618/R=0/*http://www.n
etflix.com/Default?mqso=60178338&partid=4116719> click here
>   <http://us.adserver.yahoo.com/l?
M=267637.4116719.5338353.1261774/D=egroupmail/S=:HM/A=1853618/rand=67
8552676>
>
>
>   _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/intradoc_users/
>
>
> * To unsubscribe from this group, send an email to:
> intradoc_users-unsubscribe@yahoogroups.com <mailto:intradoc_users-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]

Guys, in 7.x, there is an option under the Content manager link to search on
Expired content.
I don't know what that provides for jsp stuff, but it is there for people that
can access Content Manager.
Tim Gruidl
Fishbowl Solutions


	 -----Original Message-----
	 From: David Johnson [mailto:tantamnt@...]
	 Sent: Mon 1/5/2004 6:09 AM
	 To: intradoc_users@yahoogroups.com
	 Cc:
	 Subject: [intradoc_users] Re: Expired documents in Search.



	 Allistair is correct, you couldn't get it because it's not there!

	 To Stellent this is probably not a viable "feature" as to leave it
	 would result in a performance degradation over time. And more
	 importantly most customers do not want a search to return old
	 information, lawsuits are built on that. Plus it's easy to design an
	 intentional workaround depending on your requirements.

	 So you have to resort to using the database, and then hoping that
	 the sysadmin has not set up an archiving policy that removes all
	 expired documents from the collection, which is a common realworld
	 requirement at many companies.

	 So again the best solution may be to not expire but retire.
	 Alternately if you have a multitiered architecture then you can
	 expire at the Consumption level but leave available at the
	 Contribution level. Many other options can be designed including
	 pushing expired documents out to a LMC collection that is
	 labeled "expired" so you can still full text search it but not
	 mingle it with current content.

	 Version 7 will give you more options in doing a database only search
	 in Stellent which should be explored.

	 --- In intradoc_users@yahoogroups.com, "Allistair Crossley"
	 <allistair.crossley@q...> wrote:
	 > If you went to the database you could get a lot of info with the
	 query..
	 >
	 > SELECT *
	 > FROM Revisions r, DocMeta m, Documents d
	 > WHERE (r.dStatus = 'EXPIRED') and r.dID = m.dID and r.dID = d.dID
	 and r.dID = 1234
	 >
	 > This gets back pretty much everything I think you would need.
	 Check out the 3 tables above to see the columns you would get.
	 >
	 > I do agree that this is not great to have to do though, but
	 nevertheless an alternative.
	 >
	 > You won't get anything in search results just by using the dID of
	 an expired doc as the expired docs I don't think are indexed
	 anymore.
	 >
	 > ADC
	 >
	 >  -----Original Message-----
	 > From: Dhruba Banerjee [mailto:dhruba.banerjee@t...]
	 > Sent: 05 January 2004 11:43
	 > To: intradoc_users@yahoogroups.com
	 > Subject: Re: [intradoc_users] Expired documents in Search.
	 >
	 >
	 >
	 > Hi ADC
	 > even then (i.e getting dIDs of Expired docs from revision
	 table)..how do
	 > we get more details about  them ??
	 >
	 > I mean I tried a Search like "dID= <ID of a Expired doc> "...but
	 didn't
	 > get any result...
	 >
	 > David's workaround also seems nice..just that I am getting too
	 emotional
	 > with the fact that "WHY IS STELLENT NOT PROVIDING  SUCH A
	 FEATURE" !!!
	 >
	 > Regards
	 > Dhruba
	 >
	 > Allistair Crossley wrote:
	 >
	 > >  I'm not sure Dhruba - i will also need to provide a searchable
	 > > expired documents feature. If I cannot learn how to achieve this
	 with
	 > > Verity/Stellent then I will end up going direct to the database
	 table
	 > > Revisions and getting them myself!
	 > >
	 > > ADC
	 > >
	 > > -----Original Message-----
	 > > From: Dhruba Banerjee [mailto:dhruba.banerjee@t...]
	 > > Sent: 05 January 2004 10:53
	 > > To: intradoc
	 > > Subject: [intradoc_users] Expired documents in Search.
	 > >
	 > >
	 > >
	 > > Hello
	 > > I have got a document with Expiry Date set to : 4/30/03 1:55 PM
	 > >
	 > > My question is :
	 > > How do I get this document using Search in Stellent...(I can see
	 it
	 > > only
	 > > via Repository Manager)
	 > >
	 > > and ofcourse my age old question :
	 > > How to get Expired documents in Search Result using JSPs...
	 > >
	 > > Best Regards
	 > > Dhruba
	 > >
	 > >
	 > >
	 > > Post message: intradoc_users@yahoogroups.com
	 > > Subscribe:  intradoc_users-subscribe@yahoogroups.com
	 > > Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
	 > > List owner:  intradoc_users-owner@yahoogroups.com
	 > >
	 > >
	 > >
	 > >
	 > >   _____
	 > >
	 > > Yahoo! Groups Links
	 > >
	 > >
	 > > *      To visit your group on the web, go to:
	 > > http://groups.yahoo.com/group/intradoc_users/
	 > >
	 > >
	 > > *      To unsubscribe from this group, send an email to:
	 > > intradoc_users-unsubscribe@yahoogroups.com
	 > > <mailto:intradoc_users-unsubscribe@yahoogroups.com?
	 subject=Unsubscribe>
	 > >
	 > >
	 > >
	 > > *      Your use of Yahoo! Groups is subject to the Yahoo! Terms
	 of
	 > > Service < http://docs.yahoo.com/info/terms/> .
	 > >
	 > >
	 > >
	 > >
	 > > <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
	 > > -------------------------------------------------------
	 > > QAS Ltd.
	 > > Developers of QuickAddress Software
	 > > <a href=" http://www.qas.com">www.qas.com</a>
	 > > Registered in England: No 2582055
	 > > Registered in Australia: No 082 851 474
	 > > -------------------------------------------------------
	 > > </FONT>
	 > >
	 > >
	 > >
	 > > [Non-text portions of this message have been removed]
	 > >
	 > >
	 > >
	 > > Post message: intradoc_users@yahoogroups.com
	 > > Subscribe:  intradoc_users-subscribe@yahoogroups.com
	 > > Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
	 > > List owner:  intradoc_users-owner@yahoogroups.com
	 > >
	 > >
	 > >
	 > >                    Yahoo! Groups Sponsor
	 >                         ADVERTISEMENT
	 >                          [click here]
	 >
	 > >
	 > >     -------------------------------------------------------------
	 --
	 > > Yahoo! Groups Links
	 > >
	 > >    * To visit your group on the web, go to:
	 > >      http://groups.yahoo.com/group/intradoc_users/
	 > >
	 > >    * To unsubscribe from this group, send an email to:
	 > >      intradoc_users-unsubscribe@yahoogroups.com
	 > >
	 > >    * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
	 > >      Service.
	 > >
	 >
	 >
	 > [Non-text portions of this message have been removed]
	 >
	 >
	 >
	 > Post message: intradoc_users@yahoogroups.com
	 > Subscribe:  intradoc_users-subscribe@yahoogroups.com
	 > Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
	 > List owner:  intradoc_users-owner@yahoogroups.com
	 >
	 >
	 >
	 >
	 > Yahoo! Groups Sponsor
	 >
	 > ADVERTISEMENT
	 >
	 <http://rd.yahoo.com/SIG=12ct3s4ha/M=267637.4116719.5338353.1261774/D
	 =egroupweb/S=1705375618:HM/EXP=1073389421/A=1853618/R=0/*http://www.n
	 etflix.com/Default?mqso=60178338&partid=4116719> click here
	 >   <http://us.adserver.yahoo.com/l?
	 M=267637.4116719.5338353.1261774/D=egroupmail/S=:HM/A=1853618/rand=67
	 8552676>
	 >
	 >
	 >   _____
	 >
	 > Yahoo! Groups Links
	 >
	 >
	 > *     To visit your group on the web, go to:
	 > http://groups.yahoo.com/group/intradoc_users/
	 >
	 >
	 > *     To unsubscribe from this group, send an email to:
	 > intradoc_users-unsubscribe@yahoogroups.com <mailto:intradoc_users-
	 unsubscribe@yahoogroups.com?subject=Unsubscribe>
	 >
	 >
	 > *     Your use of Yahoo! Groups is subject to the Yahoo! Terms of
	 Service <http://docs.yahoo.com/info/terms/> .
	 >
	 >
	 >
	 >
	 > [Non-text portions of this message have been removed]


	 Post message: intradoc_users@yahoogroups.com
	 Subscribe:  intradoc_users-subscribe@yahoogroups.com
	 Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
	 List owner:  intradoc_users-owner@yahoogroups.com


	 Yahoo! Groups Links

	 To visit your group on the web, go to:
	  http://groups.yahoo.com/group/intradoc_users/

	 To unsubscribe from this group, send an email to:
	  intradoc_users-unsubscribe@yahoogroups.com

	 Your use of Yahoo! Groups is subject to:
	  http://docs.yahoo.com/info/terms/






[Non-text portions of this message have been removed]

We've been giving some thought to incorporating RSS news feeds into our
Stellent-powered site (Content Server 6.2 / Stellent Site Builder 6.2 /
Windows 2000 running IIS ).

Two approaches would be to either:

1) Run a separate news aggregator on the box, output to HTML and then
include that output dynamically in an HCST page.

Advantage: use existing applications that locate, sort, display etc. the
feeds, and easily add feeds.

Disadvantage: One more app to maintain...?

--or--

2) Develop a Site Builder template to parse the XML.

Advantage: You could presumably use Publisher layouts, promotion
schemes, etc. to reuse content in a publication

Disadvantages: need to republish frequently. Need to publish custom
template required for each feed? (Wait... Could you use patterns to pick
up only the tags you want, and ignore everything that's not  one of the
patterns? Hmmmmmm....)

Any experience here?

Brian Lynch, Managing Director of Communications
Barbershop Harmony Society
blynch@...    www.spebsqsa.org
AOL/AIM: prspebsqsa

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Try the 'GET_EXPIRED' service.

If your version of Stellent is too old, try installing the
'NotificationOfExpiration' component from your 'extras' directory.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150

Allistair Crossley wrote:
| If you went to the database you could get a lot of info with the query..
|
| SELECT *
| FROM Revisions r, DocMeta m, Documents d
| WHERE (r.dStatus = 'EXPIRED') and r.dID = m.dID and r.dID = d.dID and
r.dID = 1234
|
| This gets back pretty much everything I think you would need. Check
out the 3 tables above to see the columns you would get.
|
| I do agree that this is not great to have to do though, but
nevertheless an alternative.
|
| You won't get anything in search results just by using the dID of an
expired doc as the expired docs I don't think are indexed anymore.
|
| ADC
|
|  -----Original Message-----
| From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
| Sent: 05 January 2004 11:43
| To: intradoc_users@yahoogroups.com
| Subject: Re: [intradoc_users] Expired documents in Search.
|
|
|
| Hi ADC
| even then (i.e getting dIDs of Expired docs from revision table)..how do
| we get more details about  them ??
|
| I mean I tried a Search like "dID= <ID of a Expired doc> "...but didn't
| get any result...
|
| David's workaround also seems nice..just that I am getting too emotional
| with the fact that "WHY IS STELLENT NOT PROVIDING  SUCH A FEATURE" !!!
|
| Regards
| Dhruba
|
| Allistair Crossley wrote:
|
|
|> I'm not sure Dhruba - i will also need to provide a searchable
|>expired documents feature. If I cannot learn how to achieve this with
|>Verity/Stellent then I will end up going direct to the database table
|>Revisions and getting them myself!
|>
|>ADC
|>
|>-----Original Message-----
|>From: Dhruba Banerjee [mailto:dhruba.banerjee@...]
|>Sent: 05 January 2004 10:53
|>To: intradoc
|>Subject: [intradoc_users] Expired documents in Search.
|>
|>
|>
|>Hello
|>I have got a document with Expiry Date set to : 4/30/03 1:55 PM
|>
|>My question is :
|>How do I get this document using Search in Stellent...(I can see it
|>only
|>via Repository Manager)
|>
|>and ofcourse my age old question :
|>How to get Expired documents in Search Result using JSPs...
|>
|>Best Regards
|>Dhruba
|>
|>
|>
|>Post message: intradoc_users@yahoogroups.com
|>Subscribe:  intradoc_users-subscribe@yahoogroups.com
|>Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
|>List owner:  intradoc_users-owner@yahoogroups.com
|>
|>
|>
|>
|>  _____
|>
|>Yahoo! Groups Links
|>
|>
|>*      To visit your group on the web, go to:
|>http://groups.yahoo.com/group/intradoc_users/
|>
|>
|>*      To unsubscribe from this group, send an email to:
|>intradoc_users-unsubscribe@yahoogroups.com
|><mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>
|>
|>
|>
|>*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
|>Service < http://docs.yahoo.com/info/terms/> .
|>
|>
|>
|>
|><FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
|>-------------------------------------------------------
|>QAS Ltd.
|>Developers of QuickAddress Software
|><a href=" http://www.qas.com">www.qas.com</a>
|>Registered in England: No 2582055
|>Registered in Australia: No 082 851 474
|>-------------------------------------------------------
|></FONT>
|>
|>
|>
|>[Non-text portions of this message have been removed]
|>
|>
|>
|>Post message: intradoc_users@yahoogroups.com
|>Subscribe:  intradoc_users-subscribe@yahoogroups.com
|>Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
|>List owner:  intradoc_users-owner@yahoogroups.com
|>
|>
|>
|>                   Yahoo! Groups Sponsor
|
|                         ADVERTISEMENT
|                          [click here]
|
|
|>    ---------------------------------------------------------------
|>Yahoo! Groups Links
|>
|>   * To visit your group on the web, go to:
|>     http://groups.yahoo.com/group/intradoc_users/
|>
|>   * To unsubscribe from this group, send an email to:
|>     intradoc_users-unsubscribe@yahoogroups.com
|>
|>   * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
|>     Service.
|>
|
|
|
| [Non-text portions of this message have been removed]
|
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
|
|
| Yahoo! Groups Sponsor
|
| ADVERTISEMENT
|
<http://rd.yahoo.com/SIG=12ct3s4ha/M=267637.4116719.5338353.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073389421/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116719>
click here
|
<http://us.adserver.yahoo.com/l?M=267637.4116719.5338353.1261774/D=egroupmail/S=\
:HM/A=1853618/rand=678552676>

|
|
|   _____
|
| Yahoo! Groups Links
|
|
| * To visit your group on the web, go to:
| http://groups.yahoo.com/group/intradoc_users/
|
|
| * To unsubscribe from this group, send an email to:
| intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>
|
|
| * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
|
|
|
|
| [Non-text portions of this message have been removed]
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YRkmexGJFoGoVARAomsAKCy9koLVlgBx7hHgCWFOhZRTPL34QCeMmhN
W4IIKy+rqFtdG6I7zeOoNiE=
=6vMY
-----END PGP SIGNATURE-----

I have the following query:

xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'

This query has been working fine until we switched from 2003 to 2004
year.

A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM

Does anyone have any ideas why this doesn't work anymore?

Thanks,
-Gregory Reddin
Susan G. Komen Breast Cancer Foundation

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----

Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
 
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> click here
  
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=\
:HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]

Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
 
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> click here
  
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=\
:HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

is xPressDate a date column or a string column?

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

Hi everybody,

Every now and then I need to use HTML/JSP as a source document instead
of the usual Word docs.  Problem is, during the translation stage,
<html> and <body> tags aren't stripped from the code so I end up with
all the code from my custom layout as I would expect along with
redundant <html> and <body> tags, and usually any <script> items I have
in the <head> of the source HTML get stripped and never put into the
<head> of the layout.  I usually have to resort to placing <script>s in
the body, even though I know they shouldn't really go there.  And, the
biggest pain in the butt, is that the onLoad events for the <body> tag
end up being placed as content in the translated page, not in the <body>
tag where they belong.

Does anyone have any best practices for dealing with HTML source docs
they'd like to share?  I've done just about everything I can do to keep
my code clean, but it usually gets mangled during the translation and I
end up with some pretty rough code.  Not a lot to go on in any of the
developer docs.

Thanks and best regards,
Chris

Christopher Owens
IT Web Analyst
Alliant Energy
4902 N. Biltmore Lane
P.O. Box 77007
Madison, WI 53707-1007
(608) 458-3032
email:  christopherowens@...

but have you tried

xPressDate > '<$dateCurrent$>'

have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

xPressDate > '01/04/04 12:00'

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:38
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
&partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
 
<http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqs\
o=60178356&partid=4116730> click here
  
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=\
:HM/A=1853619/rand=897216230>


   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

I changed one of the documents to have a date of 01/05/04. Then changed my query
to be <$dateCurrent(-3)$> so that it doesn't go back into the 2003 year.

It works that way. This has got to be a bug with the function

Thanks for your help.
-Greg

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:48 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


but have you tried

xPressDate > '<$dateCurrent$>'

have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

xPressDate > '01/04/04 12:00'

ADC

  -----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:38
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
&partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
 
<http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqs\
o=60178356&partid=4116730> click here
  
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=\
:HM/A=1853619/rand=897216230>


   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

Not sure if it is the function. You will only know if you try substituting a
2003 date as a string into the single quotes rather than using the dateCurrent
function. I think you already said that dateCurrent(-90) does return the right
value and I have tried it here and it works. Try

xPressDate > '10/7/03 10:46'

If this does not work then it is not the function probably but rather something
to do with the comparison?

ADC

From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 17:00
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



I changed one of the documents to have a date of 01/05/04. Then changed my query
to be (as current list) so that it doesn't go back into the 2003 year.

It works that way. This has got to be a bug with the function

Thanks for your help.
-Greg

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:48 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


but have you tried

xPressDate > '<$dateCurrent$>'

have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

xPressDate > '01/04/04 12:00'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:38
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqso\
=60178356
<http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqs\
o=60178356&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853619/rand=897216230>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]

Hello all,

As long as I'm on a development kick today, I thought I'd complement my
previous question with another about redirects in JSPs.  I usually
develop JSPs on my Tomcat development box and things go pretty well.
However, the functions I seem to have the most trouble with is when I
need to do redirects.

For example, after I send an email with a JSP, I need to redirect to
another page.  Using response.sendRedirect always returns a nullPointer
error of some sort on SCS, but doesn't on my development machine.  So I
thought I'd try <jsp:forward>.  Well, it would appear that I can only
forward to another JSP, which works fine.  But if I try to forward to an
HCSP, then I get a Tomcat error that says the page can't be found (which
kinda makes sense since it's not on the Java server).  So how do you get
around these issues?  I've used client-side redirects with JavaScript
which works, but that's not ideal... just a hokey workaround.

Any thoughts?

Best regards,
Chris

Christopher Owens
IT Web Analyst
Alliant Energy
4902 N. Biltmore Lane
P.O. Box 77007
Madison, WI 53707-1007
(608) 458-3032
email:  christopherowens@...

Ok. Just tried it that way, by putting in '10/7/03 10:46' as the actual date.
Unfortunately it still doesn't work.

Thanks again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 11:07 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not sure if it is the function. You will only know if you try substituting a
2003 date as a string into the single quotes rather than using the dateCurrent
function. I think you already said that dateCurrent(-90) does return the right
value and I have tried it here and it works. Try

xPressDate > '10/7/03 10:46'

If this does not work then it is not the function probably but rather something
to do with the comparison?

ADC

From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 17:00
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



I changed one of the documents to have a date of 01/05/04. Then changed my query
to be (as current list) so that it doesn't go back into the 2003 year.

It works that way. This has got to be a bug with the function

Thanks for your help.
-Greg

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:48 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


but have you tried

xPressDate > '<$dateCurrent$>'

have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

xPressDate > '01/04/04 12:00'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:38
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|
|
| Post message: intradoc_users@yahoogroups.com
| Subscribe:  intradoc_users-subscribe@yahoogroups.com
| Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
| List owner:  intradoc_users-owner@yahoogroups.com
|
|
| Yahoo! Groups Links
|
| To visit your group on the web, go to:
|  http://groups.yahoo.com/group/intradoc_users/
|
| To unsubscribe from this group, send an email to:
|  intradoc_users-unsubscribe@yahoogroups.com
|
| Your use of Yahoo! Groups is subject to:
|  http://docs.yahoo.com/info/terms/
|
|
|


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+YwBmexGJFoGoVARAh6gAKC4bsvUnINb96gpZx7pJeBQR7xicgCeJ+tx
nH45kvbncdXGD/nNtvxD3TY=
=Z26E
-----END PGP SIGNATURE-----


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338 <
http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqso\
=60178338
<http://rd.yahoo.com/SIG=12c80n49r/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073405640/A=1853618/R=0/*http://www.netflix.com/Default?mqs\
o=60178338&partid=4116730> &partid=4116730> &partid=4116730> &partid=4116730>
&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853618/rand=726244737>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE>
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href=" http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>



[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




Yahoo! Groups Sponsor

ADVERTISEMENT
<
http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/S\
=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqso\
=60178356
<http://rd.yahoo.com/SIG=12ccba0c8/M=267637.4116730.5333196.1261774/D=egroupweb/\
S=1705375618:HM/EXP=1073407107/A=1853619/R=0/*http://www.netflix.com/Default?mqs\
o=60178356&partid=4116730> &partid=4116730> click here
   <
http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:\
HM/A=1853619/rand=897216230>


   _____

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


*      To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <
http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com



Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/




Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com




   _____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/intradoc_users/


* To unsubscribe from this group, send an email to:
intradoc_users-unsubscribe@yahoogroups.com
<mailto:intradoc_users-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]


Post message: intradoc_users@yahoogroups.com
Subscribe:  intradoc_users-subscribe@yahoogroups.com
Unsubscribe:  intradoc_users-unsubscribe@yahoogroups.com
List owner:  intradoc_users-owner@yahoogroups.com


Yahoo! Groups Links

To visit your group on the web, go to:
  http://groups.yahoo.com/group/intradoc_users/

To unsubscribe from this group, send an email to:
  intradoc_users-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
  http://docs.yahoo.com/info/terms/

I addressed this issue recently on here for someone else as I ran into something
similar.  It has to do with the Verity search engine's use of date strings in
the query.  Passing in a 2-digit month is causing Verity to assume the year is
the first two digits of your date, while a 1-digit month is obviously a month.  
That's why the query worked up until 90 days back was in October - a 2-digit
month.

You need to force the year to be 4 digits by calling one of the date formatting
routines as you build the query string.  Here's how I would change your code
using the formatDateOnlyFull function I'm using in my query:

xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
xCollectionID <= `643` <AND> xPressDate > '<$
formatDateOnlyFull(dateCurrent(-90))$>'


   ----- Original Message -----
   From: Reddin, Gregory
   To: intradoc_users@yahoogroups.com
   Sent: Monday, January 05, 2004 9:17 AM
   Subject: RE: [intradoc_users] Search Query Help


   Ok. Just tried it that way, by putting in '10/7/03 10:46' as the actual date.
Unfortunately it still doesn't work.

   Thanks again.

   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 11:07 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   Not sure if it is the function. You will only know if you try substituting a
2003 date as a string into the single quotes rather than using the dateCurrent
function. I think you already said that dateCurrent(-90) does return the right
value and I have tried it here and it works. Try

   xPressDate > '10/7/03 10:46'

   If this does not work then it is not the function probably but rather
something to do with the comparison?

   ADC

   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 17:00
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help



   I changed one of the documents to have a date of 01/05/04. Then changed my
query to be (as current list) so that it doesn't go back into the 2003 year.

   It works that way. This has got to be a bug with the function

   Thanks for your help.
   -Greg

   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 10:48 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   but have you tried

   xPressDate > '<$dateCurrent$>'

   have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

   xPressDate > '01/04/04 12:00'

   ADC

   -----Original Message-----
   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 16:38
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help



   Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 10:35 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

   xPressDate > '<$dateCurrent$>'

   ADC

   -----Original Message-----
   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 16:29
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   xPressDate is a custom field set as type "Date".

   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 10:27 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   is xPressDate a date column or a string column?

   ADC

   -----Original Message-----
   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 16:24
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   10/30/03 12:00 AM
   11/10/03 12:00 AM

   PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 10:22 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   what is the xPressDate value on 2 of the items that "should" be coming back...

   ADC

   -----Original Message-----
   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 16:20
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

   -----Original Message-----
   From: Allistair Crossley [mailto:allistair.crossley@...]
   Sent: Monday, January 05, 2004 10:18 AM
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

   Have you tried the following condition on its own?

   xPressDate > '<$dateCurrent(-90)$>'

   ADC

   -----Original Message-----
   From: Reddin, Gregory [mailto:greddin@...]
   Sent: 05 January 2004 16:14
   To: intradoc_users@yahoogroups.com
   Subject: RE: [intradoc_users] Search Query Help


   Yes, please examine the query closer. The query is supposed to show any
articles with a date greater than 10/7/03 10:46 AM. (90 days ago) There are
several in December and November that should be returning that aren't.

   Thanks.

   -----Original Message-----
   From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
   Sent: Monday, January 05, 2004 10:09 AM
   To: intradoc_users@yahoogroups.com
   Subject: Re: [intradoc_users] Search Query Help


   -----BEGIN PGP SIGNED MESSAGE-----
   Hash: SHA1


   that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
   the default date format.

   If you want to use a different date format, that's a seperate issue.

   - --

   Brian 'Bex' Huff <bex@...>
   PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150

   greddin wrote:
   | I have the following query:
   |
   | xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
   | xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
   |
   | This query has been working fine until we switched from 2003 to 2004
   | year.
   |
   | A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
   |
   | Does anyone have any ideas why this doesn't work anymore?
   |
   | Thanks,
   | -Gregory Reddin
   | Susan G. Komen Breast Cancer Foundation
   |


[Non-text portions of this message have been removed]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


OK... the problem lies in the fundamental fact that Stellent supports
more date formats than Verity does...

if you use single quotes (') around a date, it will be passed DIRECTLY
to Verity

However, if you use back-tics around a date (`), Stellent will parse it
first, and then send a value to Verity that we know it will understand.

Generally, its always advisable to use back-tics... out JavaScript code
does exactly this to build up query strings on the Search page.

hope this helps...

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150

Allistair Crossley wrote:

| Not sure if it is the function. You will only know if you try
substituting a 2003 date as a string into the single quotes rather than
using the dateCurrent function. I think you already said that
dateCurrent(-90) does return the right value and I have tried it here
and it works. Try
|
| xPressDate > '10/7/03 10:46'
|
| If this does not work then it is not the function probably but rather
something to do with the comparison?
|
| ADC
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/+aeDmexGJFoGoVARAvOSAKCWN3Ma3hI3qsJ2RvObGX+YeKftggCfc42Q
caKU4wyi8rZGKiNd7HtA29U=
=DVf1
-----END PGP SIGNATURE-----

That fixed it David. I'll definitely have to file this one.

Thanks for the fix.

-Greg

-----Original Message-----
From: David Fielding [mailto:dsfielding@...]
Sent: Monday, January 05, 2004 11:59 AM
To: intradoc_users@yahoogroups.com
Cc: Reddin, Gregory
Subject: Re: [intradoc_users] Search Query Help


I addressed this issue recently on here for someone else as I ran into something
similar.  It has to do with the Verity search engine's use of date strings in
the query.  Passing in a 2-digit month is causing Verity to assume the year is
the first two digits of your date, while a 1-digit month is obviously a month.  
That's why the query worked up until 90 days back was in October - a 2-digit
month.

You need to force the year to be 4 digits by calling one of the date formatting
routines as you build the query string.  Here's how I would change your code
using the formatDateOnlyFull function I'm using in my query:

xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
xCollectionID <= `643` <AND> xPressDate > '<$
formatDateOnlyFull(dateCurrent(-90))$>'



----- Original Message -----
From: Reddin,  <mailto:greddin@...> Gregory
To: intradoc_users@yahoogroupscom <mailto:intradoc_users@yahoogroups.com>
Sent: Monday, January 05, 2004 9:17 AM
Subject: RE: [intradoc_users] Search Query Help

Ok. Just tried it that way, by putting in '10/7/03 10:46' as the actual date.
Unfortunately it still doesn't work.

Thanks again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 11:07 AM
To: intradoc_users@yahoogroupscom <mailto:intradoc_users@yahoogroups.com>
Subject: RE: [intradoc_users] Search Query Help


Not sure if it is the function. You will only know if you try substituting a
2003 date as a string into the single quotes rather than using the dateCurrent
function. I think you already said that dateCurrent(-90) does return the right
value and I have tried it here and it works. Try

xPressDate > '10/7/03 10:46'

If this does not work then it is not the function probably but rather something
to do with the comparison?

ADC

From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 17:00
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



I changed one of the documents to have a date of 01/05/04. Then changed my query
to be (as current list) so that it doesn't go back into the 2003 year.

It works that way. This has got to be a bug with the function

Thanks for your help.
-Greg

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:48 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


but have you tried

xPressDate > '<$dateCurrent$>'

have you tried substituting a date string into the single quotes rather than
using dateCurrent to confirm it is a dateCurrent problem?

xPressDate > '01/04/04 12:00'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:38
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help



Well, strangely enough, I was just doing a test. I changed one of our articles
to have a xPressDate of 01/04/04 12:00AM. Just so that I know we'd have at least
one article for this new year. Even doing this, did not change the outcome.
Still this article doesn't return.



-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:35 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


does xPressDate > '<$dateCurrent(-90)$>' capture nothing at all? Have you got
content put in for 2004? Does it fail in that case with

xPressDate > '<$dateCurrent$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:29
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


xPressDate is a custom field set as type "Date".

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:27 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


is xPressDate a date column or a string column?

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:24
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


10/30/03 12:00 AM
11/10/03 12:00 AM

PS. I think it's a bug with the dateCurrent function because if I manually
change the server's date/time back to something like December 7, 2003 the query
begins working again.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:22 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


what is the xPressDate value on 2 of the items that "should" be coming back...

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:20
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, I have tried just as you suggested. The only way it will work now, it to
remove the xPressDate > '<$dateCurrent(-90)$>'. Then it works.

-----Original Message-----
From: Allistair Crossley [mailto:allistair.crossley@...]
Sent: Monday, January 05, 2004 10:18 AM
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Not an answer but ... have you tried all possibilities with the various
conditions that make up the whole. That is, replace the condition with smaller
chunks to see which part exactly is failing. You include some stuff with
xCollectionID for example - have you tested that this is not the problem.

Have you tried the following condition on its own?

xPressDate > '<$dateCurrent(-90)$>'

ADC

-----Original Message-----
From: Reddin, Gregory [mailto:greddin@...]
Sent: 05 January 2004 16:14
To: intradoc_users@yahoogroups.com
Subject: RE: [intradoc_users] Search Query Help


Yes, please examine the query closer. The query is supposed to show any articles
with a date greater than 10/7/03 10:46 AM. (90 days ago) There are several in
December and November that should be returning that aren't.

Thanks.

-----Original Message-----
From: Brian 'Bex' Huff [mailto:Brian.Huff@...]
Sent: Monday, January 05, 2004 10:09 AM
To: intradoc_users@yahoogroups.com
Subject: Re: [intradoc_users] Search Query Help


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


that IS 90 days ago... 10/7/03 means October 7 (not July 10th) 2003 in
the default date format.

If you want to use a different date format, that's a seperate issue.

- --

Brian 'Bex' Huff <bex@...>
PGP Key: http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get <
http://pgp.mit.edu:11371/pks/lookup?op=get
<http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150>
&search=0x5A06A150> &search=0x5A06A150> &search=0x5A06A150

greddin wrote:
| I have the following query:
|
| xHidden <Substring> `false` <AND> xCollectionID >= `643` <AND>
| xCollectionID <= `643` <AND> xPressDate > '<$dateCurrent(-90)$>'
|
| This query has been working fine until we switched from 2003 to 2004
| year.
|
| A sample <$dateCurrent(-90)$> gives: 10/7/03 10:46 AM
|
| Does anyone have any ideas why this doesn't work anymore?
|
| Thanks,
| -Gregory Reddin
| Susan G. Komen Breast Cancer Foundation
|




[Non-text portions of this message have been removed]