Skip to main content
Question

FSM : Notification Message : Report Parameters : Multiple Values


Forum|alt.badge.img+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
Superhero
Forum|alt.badge.img+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


Minindu Somaratne
Hero (Employee)
Forum|alt.badge.img+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


Forum|alt.badge.img+4
  • Author
  • Do Gooder
  • 3 replies
  • July 15, 2021

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
Hero (Employee)
Forum|alt.badge.img+9

Hi @chandank ,

You can try the following sequence and check;

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

 

Thanks,

Minindu


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings