Hi,
I'm trying to build an if condition into a reference qualifier string. What I want is it to look at variable a, b & c, and filter accordingly, sometimes c will not have a value, so I want it to revert to just using a & b and ignore c.
The issue I am getting is that it's always returning the TRUE condition, so it will either return the correct number of records or "0" if c is null. If remove the value on the from from c then I do get the desired outcome, so I need update the string to look at the reference table value rather than the form value, but haven't been able to get the code quite right.
Below is the current script I'm using - would appreciate any guidance as to where I'm going wrong.
Javascript:(current.assignment_group)?'u_assignment_group='+current.assignment_group+'^u_business_service='+current.u_business_service+'^u_task_category='+current.u_task_category:'u_business_service='+current.u_business_service+'^u_task_category='+current.u_task_category
Thanks in advance,
Dan
