Skip to main content

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

Hello @chandank ,

 

Are you referring to report parameters in the notification messages?

If you have defined the parameters in the report definition file (report admin) the report parameters can be called in the notification message with below syntax.

 

Generally the syntax would be,

param_name = {{table_name.column_id}}

Hope this would help


Hi @chandank ,

I believe the issue is with the format you tried using.

Report parameters are specified using parameter and value pairs. You can use substitution variables as parameter values according to the below formatting.
parameter_name={{table_name.column_name}}

For your example, I assume the parameter should be task_status. Therefore, the report parameters in the notification message , you’ll need to add the param as below;

task_status={{task.task_status}}

 

If you want to add multiple parameters, you can simply do that by separating each param by a comma, without adding any spaces.

parameter_name={{table_name.column_name}},parameter_name={{table_name.column_name}}

 

Hope this helps.

 

Thanks,

Minindu


Hi,

Thanks for responses

But, the scenario is that although the report can processes any statuses , during the Notification we want to trigger only for Harcoded specific values of ‘ASSIGNED’, ‘READ’. 

Using the single value of ‘ASSIGNED’ in the report parameters worked.

                    task_Status=ASSIGNED

But, the requirement is that we need to send notification for both ASSIGNED & READ


Hi @chandank ,

You can try the following sequence and check;

task_status={{task.ASSIGNED}},task_status={{task.READ}}

 

Thanks,

Minindu