AnsweredAssumed Answered

Lookup to get the tasks of one Particular Project that i am currently into

Question asked by PrasanthPendam on Nov 18, 2016
Latest reply on Nov 21, 2016 by Jeevan.B

I am trying to create a Look up to list only the tasks of one particular Project that I am currently looking at.

For example if I go to Home->Investment Management->Projects and select any Project 'PRJXXXX', this lookup should display only the tasks related to this project. Right now my lookup is listing the tasks of all the Projects in Clarity. Below is my Lookup query. Any help here is much appreciated.

 

SELECT @SELECT:task.prid:prid@,
         @SELECT:task.PRUID:UNIQUE_CODE@,
         @SELECT:task.prexternalid:prexternalid@,
   @SELECT:task.prname:prname@,
         @SELECT:task.prprojectid:prprojectid@,
         @SELECT:task.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
  FROM   prtask task
  WHERE  @FILTER@
  AND    task.pristask = 0

 

Thanks in Advance.

Prasanth

Outcomes