Need help tp modify ref qualifier to fetch values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 11:45 AM
Hi All,
My Requirement is that i have a lookup select box variable with the reference qualifier as "javascript:'u_catalog_item=a255e73b87fb9d90d82afcc6cebb3561^u_key=gcp_costcenter_name^u_active=true^u_parent='+current.variables.line_of_business"
I would now like to modify it such that if u_parent='+current.variable.gc_dep' then it should populate the value where parent is gc_dep, if parent is line_of_business then it should populate variables where parent is line of business. could you please help..
I tried the below code,but doesnt work
javascript: 'u_catalog_item=a255e73b87fb9d90d82afcc6cebb3561^u_key=gcp_costcenter_name^u_active=true^u_parentIN'+(current.variables.gcp_dep?current.variables.gcp_dep+',':'')+current.variables.line_of_business
basically we have created few variable lookups with parent as line_of_business and few with parent as gcp_dep. I would like this field to get values for gcp_dep. line_of_business will always have value but gcp_dep may or may not have.
please help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 11:59 AM
Try this:
javascript:if(current.variables.gcp_dep!=''){'u_catalog_item=a255e73b87fb9d90d82afcc6cebb3561^u_key=gcp_costcenter_name^u_active=true^u_parent='+current.variables.gcp_dep}else{'u_catalog_item=a255e73b87fb9d90d82afcc6cebb3561^u_key=gcp_costcenter_name^u_active=true^u_parent='+current.variables.line_of_business};
Regards,Sushant Malsure
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-02-2023 01:15 PM
@Atheher Fathima Did you get the chance to check and test above ?
Regards,Sushant Malsure