1

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself.

Question: Is it possible to filter available Tasks based on the Project column value to show only the Task having same project? Is it possible to get it done without coding?

  • I don't think it is possible without a little JavaScript coding.. Are you okay with that? – Arsalan Adam Khatri Dec 14 '14 at 21:30
  • Yes, JavaScript is fine. I meant a server code. – jcjr Dec 14 '14 at 21:31
  • If I understood your question correctly, multivalue lookup column is not filtered, it is just displayed? – Slaven Semper Dec 14 '14 at 22:05
  • No; the multivalue lookup column is filtered based on value of another column. – jcjr Dec 15 '14 at 7:29
2

You will need to populate a drop-down fetching projects from the Projects list and than on selection redirect to the same page with ProjectId (ID) in the Query String..

Use List View Web Part to get the ProjectId from the Query String (as Query String Parameter) and filter the tasks list.

Following blog post should help (It is using External List so ignore the External Content Type and Filters etc.) but configuring the List View Web Part and JavaScript to redirect with Query String will help

External List with BCS & Search Filters

0

I might be totally missing the point of your question, but it looks like a plain filtered, no-code view filtered by lookup column would solve your problem.

When browsing the Task list, create a new view. In view settings scroll down to filter area. Select your lookup column from the dropdown list and entered desired filtering value.

  • Have you considered that the filtering value is not a constant but it changes as a user fills the form? – jcjr Dec 15 '14 at 7:28
  • Ok. What about view with group by lookup column? – Slaven Semper Dec 15 '14 at 7:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.