Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Zagwit
Contributor
Contributor

Search in field (trigger) using OSUser

I have a fields that has values NT Admin names separated by " ; "

Field Name: NTUser Names

A couple example of values for NT User Names field : 

                 Company\Steve; Company\John; Company\Amy

                 Company\Tom; Company\Lisa; Company\Ray 

In my trigger I want to "Select in Field"  NT User Names     

       then the search string is a wildmatch of some kind on function OSUser()

* My main issue is finding what the syntax in the search string  is so it will filter anywhere within NT User Names that have OSUser in it?

Zagwit

 

Labels (3)
2 Replies
saminea_ANZ
Creator
Creator

Use this as string?

='Subfield(QvUser(), '\', -1)=SubField(OsUser(), '\', -1)'

Zagwit
Contributor
Contributor
Author

Thanks.

No I don't use QVUser and have no section access. I just want to evaluate OSUser against the value of the field I mentioned (NTUser Names)