You are viewing limited content. For full access, please sign in.

Question

Question

Advanced Search Syntax for "IN" operand

asked on December 1

Is there any way to do an advanced search in the LF Desktop/Web Client something to the effect of:

{[Template]:[Field] IN (value1, value2, value3, ... valueX)}

... instead of compounding it using the OR operand | constantly?

There is a need to do this in the Client as opposed to using a SQL query, but there could be hundreds or thousands of entries needing to be searched for, and it seems to time out or error if using the OR operand 40+ times in one advanced search.

0 0

Replies

replied on December 1

The repository search isn't intended for searching on 40+ values for the same field. We don't have an "IN" syntax, but if we did it would still likely not be able to perform well with this many values.

Could you elaborate on what they're trying to accomplish? There may be alternate ways to approach this to meet their need.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.