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.





Any help would be appreciated.




(1) Answer