WAy to pass parameter to queries

CloverDX Platform
1

Hi,

this seem silly, but I can’t find a way to use parameters in the queries used in my graph (in DBInputTable especially).

My need is simple : I want to run a graph each month to extract the records of the period, and to pass the month as a parameter to the graph.

I thought I would go with graph parameters, but they don’t seem to be usable in queries…

What is the way ?

Franck

2

Hi, I checked posibility to involve parameter into query and it works. Bellow is a part of code where dbInputTable with query definition and internal parameter definition are:

Tomas

3

Hi Tomas,

Thanks for your reply.
I was using a wrong syntax, assuming I should use the same one as what is used in clover’s transformation language, that is I was using ‘${par.id}’ for parameter name id, instead of ‘${id}’.

Thanks again,

Franck

4

Any comment someone ?