Hi Dojo Community

I'm working on a Low Code App, it consists of some user selected data that will be passed into an automation script.

I need some dropdowns and some trees for the user to select a couple of options, however, the data that needs to be in those components is neither primary or display keys, this is where I'm having difficulties.

This is an example:
I need a dropdown (single-select) that contains the type of entity, this is retrieved from a column from a table within the DMA but is not any key, also I have to filter on distinct on that column since there are some repeated names.
When the user selects the type, I have to search among some elements for all the entities of that selected type, again columns are not any key, then merge all of them, selecting distinct, and display that as a tree (multi-select).
Also, I need a dropdown that acts as a boolean switch with the fixed Enabled/Disabled values.

And this is the case for a couple more of inputs I need for the automation script.

When selecting the adhoc source as data for the component (dropdown/tree) it shows the name of the query instead of the data of the query.
From what I've seen on Dojo and investigating, the closest component that can show the data is the query filter, but since I need the user selected data to go into other script it won't work, as the query filter doesn't work as feed for scripts.

Is this functionality available? If so, is there anything I'm missing when assigning the adhoc source as data or filter?

Thanks in advance