profiler

galderman · Post by **galderman** » Thu Jun 28, 2001 12:27 pm

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.

Post by **John** » Thu Jun 28, 2001 12:49 pm

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.

galderman · Post by **galderman** » Thu Jun 28, 2001 1:23 pm

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?

bart · Post by **bart** » Thu Jun 28, 2001 2:26 pm

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

Post by **John** » Thu Jun 28, 2001 4:25 pm

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.