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



Dec 18, 2013, 4:50 AM
453 Posts

Full Text Index search Issue

  • Category: Other
  • Platform: All
  • Release: 9.0
  • Role: Developer
  • Tags: FTIndex Search
  • Replies: 3

This is really not a direct XPages problem, but I'm trying to get a search query working in an XPage, but can't get it to work in standard Notes query.

I have a field that is created in a LS agent. When I look at the field in the document properties the filed is a date/time field and the date is correct. If I go to the Search in  View and select Field and find the the field "CompletedDate" it does not give me the date comparators - is on - is before - is after - but gives me the text comparators. When I select another date/time on the same document set in a similar manor by a backend LS Agent (neither field is defined on a form) it gives me the date comparators. This is really strange and very frustrating. Has anyone seen this before, and have a solution to it?

Dec 18, 2013, 3:01 PM
47 Posts
Operators

I just use greater than, less than or equal to... [_revisionDate >= 01/20/2013] AND [_revisionDate <= 12/01/2013] for example.

Dec 18, 2013, 4:23 PM
33 Posts
It is a problem with the UNK table data type for your field

Have a look at the UNK table entry with Notespeek for your field.  I suspect that the first time data was stored, the system recognised it as text and thus treats all fields of that name (no matter what the definition is on any form) as text.  This is really frustrating to track down as I found out myself a while back.

To resolve, do the following:

1.  Create a field on a form and set it as a date.  Set the name to be "CompletedDate" or whatever the name of your field is. 

2.  Create a new replica of the db and then check that replica to see if you have the same issue.  If you don't, overwrite the original db with the new replica and you are good to go.

 

You can also try deleting the FT index and compacting the db after doing step 1 above if you can't replace the replica.

Dec 18, 2013, 4:49 PM
453 Posts
Thanks Rob will give that a try.

I use the [_revisionDate] in another part of the query and use the less than greater than < > symbols and that one works.

I did as you said, because it was just a test DB it didn't have any documents in it, created field on form as date/time, removed index replicated (new replica recognized the field as a date/time), removed original replica locally and replicated back from the server to the original name, reapplied the FTIndex. the local copy sees the field as a date/time, remove original replica of the DB from the server, rename the new replica back to the original name (oh forgot, remove FTIndex from new replica before renaming it) reapply FTIndex.

Thanks it now works as expected, but a major pain in the butt and a lot of wasted (unbillable) hours.


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