How to use LIKE with Personalized Information Link
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
Any help would be appreciated.