WFA - How do you filter fields with search string within rows of a Table?

ninja — Wed, 04 Jun 2025 19:16:12 GMT

I have a workflow which sets NTFS permissions. I have a datasource which contains all the AD users and groups.

I need to know what I can put in the sql query to filter the third column in the table for each row. My guess is the index of the field but I don't know if this is possible nor the syntax

SELECT samaccountname AS 'GroupName',addomain AS 'Domain'
FROM company_domain.domain_groups
WHERE domain_groups.samaccountname LIKE '%${SOMETHING}%'

The third column shows the AD groups in a drop down but I need it to be filtered by the first column. I know how to do this from a regular field but not within a table.

Re: WFA - How do you filter fields with search string within rows of a Table?

cbauernf — Fri, 02 Sep 2016 15:04:18 GMT

This is a frequently asked question in this forum, and unfortunately, the frequent answer is: you can't.

The SQL query inside a table does not accept variables, it has to be self contained.

See this thread this thread for a more detailed discu

Best,

Christian

topic WFA - How do you filter fields with search string within rows of a Table? in Active IQ Unified Manager Discussions

WFA - How do you filter fields with search string within rows of a Table?

Re: WFA - How do you filter fields with search string within rows of a Table?