AnsweredAssumed Answered

ProjectID parameter

Question asked by Calemirou on Jun 14, 2016
Latest reply on Jul 7, 2016 by Dave_3.0

It seems that is a dummy question, I'm new at Clarity PPM Plateforme,

I have a Lookup Query to make and i need to change the project id dynamically in this query like this:

 

select @SELECT:aa.aaa:date_mep@ from(
SELECT   ccn.name,date_mep_pro_reel dater,

case  when odfp.date_mep_pro_reel is null and ccn.NAME='Abondonné' then  'Abondonné'
when odfp.date_mep_pro_reel is  null and ccn.NAME='Terminé' then  'Terminé'
when odfp.date_mep_pro_reel is not null and ccn.NAME='En cours' then  'En cours'
when odfp.date_mep_pro_reel is not null and ccn.NAME='Non débuté' then  'Non débuté'
when odfp.date_mep_pro_reel is not null and ccn.NAME='Suspendu' then  'Suspendu'

end as aaa
   FROM CMN_LOOKUPS CL, CMN_LOOKUP_TYPES CLT, CMN_CAPTIONS_NLS CCN,odf_ca_project odfp,INV_INVESTMENTS inv
 WHERE CL.LOOKUP_TYPE = CLT.LOOKUP_TYPE
 and inv.id = odfp.id
and odfp.ID=@WHERE:PARAM:USER_DEF:INTEGER:PROJECTID@
   AND CL.ID = CCN.PK_ID
   AND CCN.LANGUAGE_CODE = 'fr'
   AND upper(CLT.LOOKUP_TYPE) = 'PAC_RPT_PROJSTATUS'
   AND CCN.TABLE_NAME = 'CMN_LOOKUPS'
)aa WHERE aaa is not null and @filter@

 

 

and "odfp.ID=@WHERE:PARAM:USER_DEF:INTEGER:PROJECTID@"  Doesn't look like it works, any help?

 

Regards,

Amine

Outcomes