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?

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

2 Answers 2

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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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