Solved

Client Script Code Question

  • 27 December 2022
  • 2 replies
  • 69 views
S
Rank
Userlevel 2
Badge +7

Hi all,

 

In the FSM Client Scripts. The baseline coding logic includes the use of {0} and {1}. May I understand what they mean and how they are to be used?

Eg. the code below:


var fullFilter = stringFormat("task.task_status in (select task_status from task_status where status = 'OP',' and task_status <> '{0}') and task.team_id in (select team_id from team_member where person_id = '{1}') and task.person_id is null", getAppParam("REJECTED_TASK_STATUS"), getUserInfo("PersonID"));
return fullFilter;

 

{0} and {1} are also used in many other context, like in XML Business Rules.

 

Just want to understand how to use these 2 values.
 

icon

Best answer by Hasara Dinu 3 January 2023, 06:22

View original

2 replies

H
Rank
Userlevel 5
Badge +13

Hi @StejonatL,

{0} and {1} are used as the substitution parameters for these queries. If you want to get another argument to substitute for the same query, you can use another 3rd parameter as {2}.

 

{0} - This will take the first argument

{1} - This will take the second argument

 

Lets assume that the values for the below arguments are as follows.

 

getAppParam("REJECTED_TASK_STATUS") - CL

getUserInfo("PersonID") - USER1

 

So the final query will look likes below.

task.task_status in (select task_status from task_status where status = 'OP',' and task_status <> 'CL') and task.team_id in (select team_id from team_member where person_id = 'USER1') and task.person_id is null

 

Hope this information will help you .

 

Thanks,

Hasara

S
Rank
Userlevel 2
Badge +7

Thank you.

Reply


Terms & ConditionsCookie settings