We have few attributes with multi-select control type.
However, when multiple values are selected, the values are concatenated in the database.
Below is a database snapshot:
We have a GI that is using this attribute as a parameter. We would like to filter based on individual attribute and not look for a specific combination. It doesn’t work right now as it keeps looking for a specific combination of attributes
Is there a way to store this differently in the database or a way to separate them?
+4
Have you tried using “Contains” condition on this attribute in your Inquiry?
Hi
+4
You would create the parameter, then use that parameter in the condition
For example:
Here’s the result:
Attached GI for your review.
+4
Please share your GI for review
Hi
+4
I modified your GI to add a multi-select attribute as a parameter. Seems to work fine for me. Please review and test.
Hi
example: Account ABC - has attributes : Pencils, pen, notebook
Account XYZ - has attributes: Pencils, Bottle
When we just select pencils - it does not display ABC or XYZ unless you have all the attributes selected.
We want acumatica to recognize each attribute as a unique selector and not look for the same combination - but unsure how to do that
+4
Is your condition a “Contains” or equal.
I reviewed GI I posted above again and it seems to be behaving the way you wish:
Hi
example: Account ABC - has attributes : Pencils, pen, notebook
Account XYZ - has attributes: Pencils, Bottle
When we just select pencils - it does not display ABC or XYZ unless you have all the attributes selected.
We want acumatica to recognize each attribute as a unique selector and not look for the same combination - but unsure how to do that
We have the similar GI we are working on for our client. Is there a way to add a column to the GI to count how many attribute values are selected for the account?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
