Hello all,
I am using the Query form element to connect to reference list data in order to populate a table within my form. My issue is that I want to filter on a column in the reference list that has multiple values that are comma separated. Does anyone know the correct syntax to use here for something like CONTAINS in SQL? I could always use JavaScript to populate the table as well but would like to find a way with the query.
I am attaching a screenshot of the reference list and what I currently have in the form. For my example, I want a query that will return only the Forwarding Agents that contain the listed Sales Org and have the Active column set as 'Y'. So if a user inputs 1087 as the sales org in the form, it should return 306360 and 306367 on the list in the table.
Any thoughts or assistance anyone can provide would be appreciated!
Thanks,
Knavis
------------------------------
Knavis McGowan
Master Data Specialist
ABBOTT RAPID DX INTERNATIONAL LIMITED
FL
------------------------------