Hi,
Is it possible to search using multiple values in the query designer tool available in cloud 21R2? Im trying to achieve something below,
select * from customer_order where state in (‘Released’, ‘Delivered’)
In query designer, it seems this option is not there.
Thanks
Roshanga
Best answer by Navinth Bakmeedeniya
Hi
‘IN’ operation in filters was not supported in IFS Cloud 21R2 but it is now available in 22R1 via Advanced Filter Panel.
Key in the values at the above highlighted (green) value textbox & hit enter.
+31Hi
I checked this in a 21R2 reference environment and this option is not available. You can have only 1 filter per field. I tried specifying sates separated by a comma or a semi colon, but that didn’t work either. It appears to be a limitation in the current Query Designer and hopefully will be implemented soon.
I would suggest you to open a case and report this so that we can send it as an enhancement request to R&D.
Current capabilities of Query Designer in 21R2 are documented here:
Hope this helps!
+14Hi
‘IN’ operation in filters was not supported in IFS Cloud 21R2 but it is now available in 22R1 via Advanced Filter Panel.
Key in the values at the above highlighted (green) value textbox & hit enter.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
