Thunderstone Support Forums

Are there any syntax restrictions on the queries placed into the database ? E.G. parenthesized comma-separated lists; thesaurus substitution "~"; approximate pattern match "%"; etc. etc.

The profiler does allow the full range of metamorph queries to be stored in the database. However with the more complicated queries that you are asking about the LIKEIN operator will return queries that might match the document, and would require a validation step to make sure they do.

John --
I'm sorry, but I simply don't understand your response.
I can't understand "However with the more complicated queries that you are asking about the LIKEIN operator will return queries that might match the document, and would require a validation step to make sure they do."

Could you please elaborate/clarify a bit? Did you really mean "might match" or do you mean "might **not**" ??? what sort of "validation step" are you talking about?

He meant might match.

The profiler is a brain-twister, and usually implementation involves some consulting time from us. If you feel too buried, please contact sales at 216-631-8544 to schedule some time.

Thanks

To clarify a little: LIKEIN will return all the queries that have the potential to (i.e. might) match. A subsequent LIKE can determine if the query actually does match.