We got values in a UD Table that uses multiple keys for uniqueness and for this specific purpose I need a combo to show distinct items from only one of those keys. This was super easy to do in Classic, but seems like archaic in Kinetic…
What I don’t want to do is create a BAQ just to query the data and shape it. That’s a little overkill. Especially don’t want to create a dataview just for this combo. Again, overkill… And no, not looking into Functions either since we have hundreds and creating more just to send this type of data would create havoc on the function side maintaining hundreds more just for this would send me to early retirement.
Really looking for a client side data shaping solution once the data has been retrieved with a combo. Hopefully the picture uploaded and you can see the data and the duplicates.
I actually found a sort property before seeing this which worked. Thanks
For those using two dataview fields to filter, here is an example of that which worked. You have to add the columns to hidden columns. I had to add the second to append hidden columns because it was adding a space in the column of the second in the primary hidden column property field even though there wasn’t one.
