AnsweredAssumed Answered

Project ID in Dynamic Lookup

Question asked by shalinee.chauhan on Jul 12, 2011
Latest reply on Jul 14, 2011 by shalinee.chauhan
I have a requirement to create a attribute on Project object with browse lookup, which will display 3 values when somebody is creating project from new or new from template button whil it should display 4 values when a idea is converting into a project.

I am not using this field on create, I am using this field on edit page with the below mentioned query on dynamic lookup...

select

@select:p.code:Project_Code@,
@select:p.type:Project_Type@

FROM (

select 2 code,'Enhancement' Type from dual
union
select 3 code,'Production Support' Type from dual
union
select 1 code,'Adminstration' Type from dual
union
select 4 code,'Project' Type from inv_investments
where idea_id is not null
and odf_object_code='project'
AND (id = @WHERE:PARAM:USER_DEF:INTEGER:PROJECTID@
or @WHERE:PARAM:USER_DEF:INTEGER:PROJECTID@ IS NULL))p
WHERE @FILTER@

It seems it is not taking the project id when I am hiiting the browse button on my project, it is always displaying the 4 values .

Can somebody help me here to capture the same requirement in Clarity.

Outcomes