Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tFilterRow Advanced Mode : How to filter a list

Hi  My job selects in input a list of users in Active Directory and filters the users based on the AD group they belong to. (see image)
The AD group attribute is a list.
I tried the advanced mode of the tFilterRow with this condition : input_row.memberOf.contains( "GU_GIE_A_ISE0_WIFI_SIE" )
but it does not work  (0 user in output of the filter)  

This is for example what I get from the AD for one user:
John|WOO|ESH0009|john.woo@test.fr|94100-00001/00873/00877/00900//00962|Lattes|
Do you know how to use 'contains' with a list ?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I fixed it  It works if I entrer in the filter the whole value of the attribut memberOf, ie: CN=GU_GIE_H_UNI_00962_MEMBRE,OU=Groupes,OU=MyOU,DC=Test

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I fixed it  It works if I entrer in the filter the whole value of the attribut memberOf, ie: CN=GU_GIE_H_UNI_00962_MEMBRE,OU=Groupes,OU=MyOU,DC=Test