Hi Mike,
I have built exactly what you are describing. I created a non-persistent Entity (NPE) containing the two variable values and many-to-many associations with the persistent entities I would like to select over Input Reference Set Selectors. The NPE is the Data Source – Context – Enity Path of Data View Container (DVC) that has a GRID2 in it with a Microflow as the Data Source _DS_MF).
The DS_MF creates from the input of the DVC an OQL statement that is selecting the data from the database in one action.
The Microflow to create the OQL statement I can share, and I’m working to optimize it making it “smooth” and “fail-safe”. The current DS_MF limits the number of selections from a List to a given value (for my App I choose 10). The new DS_MF I’m working on has no limits, but it needs some more hours of work to figure out how to select the list of values over the NPE GUID ID using an OQL statement.
Mail me if you need more details at marco.spoel@t-systems.com
Go Make It