Hi,
I have a page on which i wan to select the project from one lookup and task from another dynamic dependent multivalued lookup.
Only tasks which are not milestones, not phase, and belongs to the project selected in first lookup.
for the task selction teh lookup should not show those tasks which are already selected.
SELECT @SELECT:task.prid:TaskID@,
@SELECT:task.prname:Task_name@,
@SELECT:task.PREXTERNALID:ExternalID@,
@SELECT:to_char(task.prstart, 'MM/DD/YY'):StartDate@,
@SELECT:to_char(task.prfinish, 'MM/DD/YY'):EndDate@,
@SELECT:DECODE (task.prstatus, '0', 'Not Started', '1', 'Started', '2', 'Completed'):Status@,
@SELECT:PRJ_GET_TASK_FULL_NAME_FCT(task.prid, task.prprojectid):task_path@
FROM
prtask task
WHERE task.prismilestone = 0
and task.pristask=1 and
@FILTER@
and (@where:param:user_def:integer:Project_Id@ = task.prprojectid OR @where:param:user_def:integer:Project_Id@ IS NULL)
@BROWSE-ONLY:
And (task.prid not in(select mul.value from ODF_MULTI_VALUED_LOOKUPS mul,odf_ca_z_subsidytest ***
where mul.attribute = 'z_task' and mul.pk_id=***.id
and @where:param:user_def:string:Association_id@ = ***.code))
:BROWSE-ONLY@
I am able to perform all of these except the tasks does not appear on the create, edit page after save, they disapear...I am able to see them on teh list view though.