Simple XSLT filter for look up column with multiple values

Look up columns drives the relationship hierarchy between lists in SharePoint site. And the most common of all tasks always seems filtering/sorting on certain conditions.
For look up column with multiple values enabled, here is XSLT filter to do the trick, it filters out the rows based on the query string parameter.
[contains(concat(@Category,';'),concat($QueryParam,';'))]
Here we are appending the value with a character (for example ';') because the result of both functions [contains('1','1') and contains('1','11')] returns true but using [contains('1;','1;')] solves the problem.




1 comment: