Generic Inquiry - Adding selectable customer attributes

Hi @jyounes! If you only want to display a single value, E-Commerce, then you’ll need to have this in the relations where you’re joining in CSAttributeDetail. Otherwise all attribute values will be brought in and no amount of functions or clever tricks will stop them.

Add a line like [CSAttributeDetail.ValueID] |  Equals  |  =’E-Commerce’

Not to display A single value but the value that is selected.

I see, well with multi-combo box values that could be a little tricky but maybe you could try something like =IIF([CSAttriubteDetail.ValueID]<>’’, [CSAttributeDetail.ValueID], ‘’). The could be a better way I’m not thinking of right now due to the utter lack of sleep I am experiencing, but otherwise I think you may need to chain IIFs or ORs together like; =IIF([CSAttriubteDetail.ValueID]=’E-Commerce’, [CSAttributeDetail.ValueID], IIF([CSAttriubteDetail.ValueID]=’C Store Wholesaler’, [CSAttriubteDetail.ValueID], IIF([CSAttriubteDetail.ValueID]=’Grocery’, [CSAttriubteDetail.ValueID], ...etc

Tried both, The first one doesn't work, and the second one still duplicates the lines but for each attribute on the list but only displays one (I only did one IF for e-commerce to test it)

This looked like it worked, I excluded the last fata field because I want more than just Ecommerce and it shows the correct attribute per customer without duplicating now.

​@jyounes  - Can you please send the screenshot of relations tab for each join , grouping and results grid? I am trying to build a similar GI and the attribute will have multi-selection. Hope the multi-selection works too for you.

You are missing the CSAnswers table where the actual values are stored for the customer. To get those values use this join...

That might be all you need, but if you need the description from the detail table you could try below, but you would need a join for every value ID. Hopefully you can just work with the first join.

 

​@Preeti Rayen I used this, but didn't include the =[CSAttributedetail.valueID] Lines.  His example pulls specific selections, if its not included it should display what is selected for the multi attribute.  

However, we only select one from the multi list, I do not know if it works for multiple selections or how it displays.