This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
RE: LScript: Delete documents using a Terminations List ~Umberto Nongeroson 28.Oct.03 03:09 AM a Web browser Applications Development 6.0.2 CF2Windows XP
Bizran didn't provide quite all the detail you need, but the bottom line is, searching for documents to delete with a full text search, without the query specifying which fields you're searching for the values in, is extremely dangerous. You can very easily find documents that contain one of the values you're searching for, in a field where you didn't expect it.
As for why your search is not finding the documents you do want to delete, you might try a full-text search in this forum to see why. The last word of the subject line of this message does not appear in the body. The body contains the word "cornflakes", but the subject does not. The body also contains the word "yeti", but it's not right next to "cornflakes". Choose two of the three words I've mentioned and construct a query that contains the two words with just a space between. Use the search field on the website to submit that query. Did you find this document? That's the same full-text search you're trying to use.
Even if you specify the field names, e.g. [firstname] = "Rex" and [lastname] = "Rightway", you run the risk of deleting records with similar values, such as Rex von Rightway.