topic Re: Search in field (trigger) using OSUser in QlikView

Search in field (trigger) using OSUser

Zagwit — Sat, 16 Nov 2024 21:01:33 GMT

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

saminea_ANZ — Thu, 18 Apr 2019 03:59:10 GMT

Use this as string?

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

Zagwit — Thu, 18 Apr 2019 15:30:02 GMT

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)