How to separate multi-select attributes in the database?

@kanupindi 

Have you tried using “Contains” condition on this attribute in your Inquiry?

Hi @RohitRattan88 , we are using this attribute as a parameter. Is there a way to implement contains condition on the parameter?

You would create the parameter, then use that parameter in the condition

For example:

Here’s the result:

Attached GI for your review.

@RohitRattan88  - I do have the parameters set up in the conditions tab as well (similar to your screenshot). However, when individual values are selected in the GI - it does not display any records. 

@kanupindi 

Please share your GI for review

Hi @RohitRattan88 , please see attached. thank you

@kanupindi 

I modified your GI to add a multi-select attribute as a parameter. Seems to work fine for me. Please review and test.

Hi @RohitRattan88 , thank you for the feedback. The multi- select works for us as well. But our concern here is each account has different attributes selected. So when we use the multi-select - it always looks for that combination.

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?

@RohitRattan88 I’m trying to accomplish this same thing on a dashboard but it doesn’t seem to work with dashboard parameters. I was able to replicate what you did on that GI and it works fine in that application, but doing the same thing on a dashboard does not work.

Any idea why this would be the case and how to accomplish this on a dashboard?