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