How to Default a DFF Segment value based on value in another segment
We are trying to default value of segment "Reporting Category (Attribute 6)" based on segment "Service Name (Attribute 1)" for DFF PJF_TASK_STRUCTURE_DFF using SQL defaulting method. It is not working.
Select Tag --It is the value we want to default
where Lookup_Type ='TEI_SERVICENAME_REPORTSEGMENT' -- Lookup for DFF "Service Name"
and Language ='US' and MEANING = 'Training Onsite' -- For now we are trying hardcoded value to do POC. Later we will like
-- to use :PARAMETER.Service Name
Version (include the version you are using, if applicable):