How to filter a lookup column by ID?
I have a custom list People. It has a lookup column Department which links to another custom list Departments. In People list the Department column shows the name of linked Department. Then I added a query string filter to People list view page, so it can receive query string value "?department=X" and use "X" to filter the People records - only people in Department X are shown. When I use the department name as "X", everything works fine. Now I want to pass the ID of the department as "X" and use it to filter People list (i.e. if I pass "?department=10" to the People list view page, the filter needs to first look into the Department list, find out which Department list item has ID 10, get the Department name value, and use it to filter the People list on the Department column). Is this possible?Miracle - MCDP: ASP.NET Developer 3.5
July 10th, 2010 6:45am

Hi, The filter webpart just can filter the columns which display in the view page. So you can’t make a filter using ID, which didn’t appear in view page. Hope this helps Thanks! Stanfford
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2010 9:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics