Hi
my question is can we store the values in local variables- yes we can, but can we select those values which are stored in local variable and get data from db?
so these values want to store in local variable
this is selectable row can get the data by selecting the row with that row data which is stored in local variable?
Discussion posts and replies are publicly visible
Sure, simply fn!append() the local variable to the data retrieved from the DB in your dropdown choices. If you have any examples that are not working for you, feel free to share some code.
Adding what chris said but dont forget to use union on the data you will be getting to get saved from the Error - Duplicate Values found in dropdown
Once you select the data and saved it into a local variable you can use the queryentity along with the queryfilter with IN Operator.