Build Unique List from Existing Entity

0
I have an existing entity called "Inventory" with several attributes.  One of the attributes is called "Group" and it's a string.  I would like to provide the user with a dropdown menu showing unique "Group" values that appear in the "Inventory" entity.   I have a solution where I build and populate a separate entity with unique "Group" values and then use a Combo Box to show the values.  Is this the best approach?  Or is it possible to build a list of unique "Group" values and then show those values in a dropdown menu without building a new entity?
asked
3 answers
2

Hi Michael,

you can use oql and do distinct() on specific value.

answered
1

You could use a microlfow to build the list of unique group items.

etrieve the list of items, create e new list for the inventory records, loop though the retrieved list, check if this is already in the list of inventory items. If not add else continue and return the list at the end of the micoflow.

I would however go with the option to normalize the groups in a separate entity.

 

answered
0

Hi micheal,

 

  You can use a enumeration and show the enum values as drop down values.

answered