Error: Parameter in custom sql missing in parameter set

Question & Answer
1

Hi, I’m having the same problem:
CUSTOMSQL_QUERY_WITH_MISSING_PARAMETERS
When creating a data set:
First I create a parameter pIdClient.
Then I add data from a custom query:
select id_client, name_client, state_id_cliente from tb_client where <<$pIdClient>>
When I add more data to join it with the previous data and thus have my new set of data parameterized, I get the indicated error.

The new data I want to add is:
select state_id_client, name_state where tb_state_client

please help

2

Did you make sure that the parameter has a default value?

3

Hello max
Yes, I create the parameter of the integer type and unique value. Also I put a static default value 45

4

You need to set that equal to a column

select id_client, name_client, state_id_cliente from tb_client where tb_state_client = <<$pIdClient>>
1 Like