How to use LIKE with Personalized Information Link

Hello-

I have a data set with a list of users. I want to filter the published data set to just the individual user within the information link. 

However, I'm not sure how to use a LIKE statement in either the column or the information link filter to account for the differences in my column names vs the active directory names that are returned by %CURRENT_USER%.

So for example, the value in my data is JOHN.SMITH, but the %CURRENT_USER% value is DOMAIN\JOHN.SMITH

I've tried the following synstaxes in my column/info link filters to no avail.

-%1  LIKE (%CURRENT_USER%)

-'DOMAIN\'?COLUMN_NAME = 'JOHN.SMITH'

DOMAIN\?TS_LAST_UPDATED_BY = JOHN.SMITH

etc...

Any help would be appreciated.

 

 

 

(1) Answer

Login