This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Aug 21, 2014, 7:13 AM
2 Posts

After search show documents between 2 dates

  • Category: Server Side JavaScript
  • Platform: All
  • Release: 9.0.1
  • Role: Developer
  • Tags: search,between,dates,xpages,lotus,javascript
  • Replies: 2

Hello guys,

I want to perform a search after a term and 2 dates.

For example we have this:

Name Date

Alex    01.01.2014  

Alex    01.03.2014

Alex    01.05.2014

and so on...

When I search for Alex between dates: 01.01.2014 - 01.04.2014 I should get only my first 2 results in the view.

Thank you,

Florin

Aug 21, 2014, 3:57 PM
26 Posts
Not sure where exactly you are doing your search
but for a regular Full text search you would have something like:

[FieldContaingDate] <= 01.04.2014 AND [FieldContaingDate] >= 01.01.2014

If not in regular full text search the logic is the same.

If that isn't what your question is, you'll need to explain in better detail what you are trying to achieve and where.

Aug 21, 2014, 7:52 PM
453 Posts
Here is a code snippet that I have in a query

I do a pretty complex search from SSJS on a database and return a document collection of matches. This is one line of the query that might help - not exactly like you want but a start:

tmpArray[cTerms++] = "(([WFSCompletedDate] > " + dString + ") AND (FIELD WFSApp CONTAINS \"" + user + "\"))";

dString is set earlier in the code and in this cse is today - 30 days. the Field WFSApp is a multi value field of users names so you need to use Contains rather than equals.

This could be totally extranious but I spent hours figuring this one out. The the full field is WFSApprovers which contains the full distinguished names. The FTIndexSearch will not work against this field ie (FIELD WFSApprovers CONTAINS will cause the search to fail. So I created a computed field in Notes as a Computed Field that converts the distinguished names to Abbreviate format. Now the query works as expected. Definitely does not like the / and = in the distinguished name.

Hope this helps.

Bill
       
 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal