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,
The IN query is supported (I verified it does work).
The buttons we provide in the query builder are for common things, and I guess we didn't think of adding IN at the time. Given there is room for another button, adding IN (in a future release) sounds like a very good idea.
Thanks,
Rob.
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.