Hi,
We have a Report which can be filtered according to the Task Statuses. After configuring a Notification Message to trigger the Report everyday via email. We are looking to use Parameters as below
Requirement : task_Status in (‘ASSIGNED’,’READ’)
We tried Config the below option but it didnt work
task_Status=ASSIGNED,READ
task_status=’ASSIGNED’,’READ’
task_status=”ASSIGNED”,”READ”
To overcome the challenge, we adjusted the Report query & could achieve our requirement
Before : WHERE (t.task_status ##TaskStatus $$TaskStatus or :TaskStatus is NULL)WHERE (t.task_status ##TaskStatus $$TaskStatus or :TaskStatus is NULL)
After : WHERE (t.task_status ##TaskStatus $$TaskStatus or :TaskStatus is NULL or ($$TaskStatus = 'ASSIGNED,READ' AND t.task_status in ('ASSIGNED','READ')))
Can you please advise if there is a better solution than above