Question

FSM : Notification Message : Report Parameters : Multiple Values

  • 9 July 2021
  • 4 replies
  • 226 views
C
Rank
Userlevel 1
Badge +4

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

This topic has been closed for comments

4 replies

Saranga Amaraweera
Rank
Userlevel 7
Badge +22

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

SAAALK
Minindu Somaratne
Rank
Userlevel 4
Badge +9

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

C
Rank
Userlevel 1
Badge +4

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

Minindu Somaratne
Rank
Userlevel 4
Badge +9

Hi @chandank ,

You can try the following sequence and check;

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

 

Thanks,

Minindu

Terms & ConditionsCookie settings