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.
Best answer by cdiaz
View original
+5
@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
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.
+5
It should be under customization >Profiles.
This might be Access Right issue.
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).
+1
@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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.