Distinct list (or combo box) in App Studio from BAQ

The DataView is just a container.
You fill it with what you have.
In this instance, I’m only bringing back the one column, so the rest would be null/undefined ignored.
The combo is just displaying the single column that I told it to from that view.

**Clarifying notes: I’m calling Distinct on the Rest call (erp-baq widget) and I’m only selecting the one column, so it would not matter how many columns your BAQ has because I’m only asking for it to bring back the single column and the unique data within.
That, then, gets plopped in the DataView which does not care what you give it.

If it helps your head, make a DataView with only the one column definition. It doesn’t really matter.

Same thing.

This also works, but you won’t have intellisense within App Studio.

All 3 will give you this:

1 Like