Hi there, I have a lookup table containing user records info. I wish to retrieve entries from the lookup table by searching a column where user id is stored.
I have a dynamic list of users, could be 1 or 10. I wish to retrieve entries that match based on id. Is there a way to make a single query on the lookup table to get all matching records, or do I have to loop through each item on my list of users to run a search for each item?
It is possible to use a single search action to query for matching lookup table entries based on an input containing an array of values.
Send us a ticket, we will try our best to assist you with your problem