Subscribe

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

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.

 

Capture.PNG

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

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