Automate

Is there a way to filter a lookup control in the same way that you would filter a dropdown? I have an RDL setup with these 3 fields and I want to filter the lookup to only show the GL_Numbers where it equals the sales org and dist channel. It works with the drop down, but there are a lot of choices so we want the user to be able to lookup the value as well instead of scrolling through many choices. I tried this raw query, but it didn't work. 

Company_Code = '[/my:myFields/my:Sales_Organization]' AND Dist_Channel = '[/my:myFields/my:Distribution_Channel]'

Hi James

Yes. You can:

(1) set one field to filter in the lookup control - example below - materialtype is part of the lookup control data - SearchProductType is on the form

(2) use a raw query to use more than one field to filter : https://help.precisely.com/r/t/1016755472/2023-12-31/Automate-Evolve/pub/Latest/en-US/Automate-Evolve-User-Guide/Participant-Resolvers?tocId=Qfg2MrlkkATDJGrhmoIysA scroll down to find Query control and RawQuery

The examples above depend on what you are using in the backend - the top one is SQL.

Hope that helps,

Sigrid