WAy to pass parameter to queries

oldforum

• July 16, 2007 00:00

• Answered

Follow

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

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  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:
  
  <Property id="GraphParameter0" name="date" value="20070308"/>
  </Global>
  <Phase number="0">
  <Node dbConnection="DBConnection0" enabled="enabled" guiHeight="0" guiName="DB Input Table" guiWidth="0" guiX="101" guiY="228" id="DB_INPUT_TABLE0" sqlQuery="select * from license where date_format(valid_from,'%Y%m%d') = '${date}'" type="DB_INPUT_TABLE"/>
  
  
  Tomas
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  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
• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  Any comment someone ?

Please sign in to leave a comment.