Hi Everyone,
I’d like to pass a list of values instead of calling out the items 1 by 1.
There are many options in the conditions drop down. But the documentation does not specify how they should be used, or provide limitations.
Answer
How to use "Is in" Condition for Generic Inquiry
Best answer by cdiaz
Thanks for your help.
Takeaway:
The “Is In” operator doesn’t behave like SQL “IN”. It accepts only one value as an input: the name of a custom filter. Some custom filters are dynamically generated by the system, such as “@MyGroups”, others are built buy a user with sufficient access to the Filters screen (CS209010).
+8@MyGroups and @MyWorktree
In case of Generic Inquiry you can Design Generic Inquiries in a way it only shows the user logged related documents.
like SOOrder.OwnerID Is In @MyGroups this only show the documents which has owner in same Workgroups as the user logged in.
Below you can read more about these filters and how they would work
SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
I read the documentation you linked. Thank you for linking.
It mentions I can create custom filters using screen CS209010. I cannot see this screen. Is it only for 2022 release? My company is on 2021 R1.
I checked in our test instance where I should have admin rights.
+8It should be under customization >Profiles.
This might be Access Right issue.
SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
Thanks for your help.
Takeaway:
The “Is In” operator doesn’t behave like SQL “IN”. It accepts only one value as an input: the name of a custom filter. Some custom filters are dynamically generated by the system, such as “@MyGroups”, others are built buy a user with sufficient access to the Filters screen (CS209010).
@cdia
Do we know if it is then possible to use a custom created filter in the same way as the system generated filter?
I’m trying to use the “is not in” syntax within a GI Condition. I’ve created a custom filter using screen CS209010 titled “PriceClassFLTR”. So should I be able to use this in my GI Conditions?
as referenced above my example would say:
PriceClassID > Is Not In > @PriceClassFLTR ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.