title: How to get correct value of parameter in CDE dashboard sql query?
body: <p>I have created basic dashboards and looks good till now.</p>
  
  <p>Now I have added parameters for run time analysis. Here is what I did :</p>
  
  <ol>
  <li>Added simple parameter. name = "noofdays"</li>
  <li>Created a Select Component, daysselect. added to a panel.</li>
  <li>Create a value array. values are : 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. corresponding arg is same for array values.</li>
  <li>created "sql over sqlJdbc" component. Added all required values. Creates a simple query.</li>
  <li>created a bar chart for the query in #4. Worked like a charm</li>
  <li><p>Nof in "sql over sqlJdbc" component, used the parameter like below ("noofdays" is visible in parameters on the</p>
  
  <pre><code>SELECT `a1`,count(`a2`)
  FROM `app_crd`
  WHERE `a3`='RECV'
  and `a4`='CONDITION'
  and where  DATE_SUB(CURDATE(),INTERVAL ${noofdays} DAY) &lt;= `datecolumn`
  group by `a1`
  </code></pre></li>
  </ol>
  
  <p>When i check my logs, I see that ${noofdays} return null.</p>
  
  <p>How do i get the correct value?</p>
  
  <p>Thanks
  Ajay</p>