Hello,
I am curious as to why "IN" is not included as an operator under query builder? Isn't "IN" used to filter a field by multiple expressions?
For example: Physical_PipeMaterial IN ('BR', 'CEM', 'DI', 'Ductile Iron', 'UNK')
I hope you can clarify my misunderstanding.
Regards,
Youssef
Hi Youssef,
You can use the IN operator - the syntax in your post looks correct, but note that it is case sensitive (for the values).
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.
Note that I have added information about this to the following Wiki article: Using the LIKE and IN Operators with queries
Thanks a lot Rob and Jesse.