- Wed Sep 14, 2016 3:04 am
#786597
We are using the following REST API to populate the drop down box which runs perfectly and gives output.
api/1.0/{workspace}/project/{prj_uid}/process-variable/{var_name}/execute-query-suggest
But when we run the same in the text box variable it gives the following the error.
Bad Request: It is not possible to execute the query. Please contact your system administrator.
The following query is used in the option SQL
select ifnull(max(reqid),0)+1 as ReqID from tablename;
If anyone knows about the issues please suggest us how to run the sql inside the variable
api/1.0/{workspace}/project/{prj_uid}/process-variable/{var_name}/execute-query-suggest
But when we run the same in the text box variable it gives the following the error.
Bad Request: It is not possible to execute the query. Please contact your system administrator.
The following query is used in the option SQL
select ifnull(max(reqid),0)+1 as ReqID from tablename;
If anyone knows about the issues please suggest us how to run the sql inside the variable