Setting project variables from SQL output

Options
Bader
Bader Registered Posts: 46 ✭✭✭✭✭

Hi all,

I'm trying to select max value from sql query and set the output into project variables

I have done the following from scenario:

1- Execute SQL as a step.

2- I'm tying to use result from previous step to set the project variables

example:

The following is my variable

{ "Max_order": "4"}.

1- Following is my query.

select max(orderNumber) from ordertable

the result is :5

2- set the project variables

i expect the following :

{ "Max_order": "5"}.

Best Answer

Setup Info
    Tags
      Help me…