nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MODIFYING THE QUERY DYNAMICALLY

arunkumarb

Hi, 
 
I have a query as shon below. I placed this query in dataset. Now If i pass the parameters like JAN,FEB,MAR....I would like to replace 'APR' with my parameter value like JAN, FEB.... 
 
select 
sum(APR_OPBAL) AS AA, 
sum(APR_OPBAL_VAL_PTR), 
sum(APR_OPBAL_VAL_BPTR), 
sum(APR_PURCHASE_QTY), 
sum(APR_PURCHASE_VAL_PTR), 
sum(APR_PURCHASE_VAL_BPTR), 
sum(APR_SOLD_QTY), 
sum(APR_SOLD_VAL_PTR), 
sum(APR_SOLD_VAL_BPTR), 
sum(APR_ADJUST_QTY), 
sum(APR_ADJUST_VAL_PTR), 
sum(APR_ADJUST_VAL_BPTR), 
sum( APR_HMSRET_QTY), 
sum(APR_HMSRET_VAL_PTR), 
sum(APR_HMSRET_VAL_BPTR), 
sum( APR_CLBAL), 
sum(APR_CLBAL_VAL_PTR), 
sum( APR_CLBAL_VAL_BPTR) 
from tbl_summary_rate where year=2010 
 
 
plz help me. 
 
Thanks and Regards, 
Arun

Find more posts tagged with

Comments

Clement Wong

Arun, 
 
Assuming your original query in the Data Set is "APR", you can overwrite the beforeOpen method of the Data Set and use Java String method, replaceAll, to replace the original text with the selected parameter value. 
 
Example: 
<pre class='_prettyXprint _lang-auto _linenums:0'>this.queryText = this.queryText.replaceAll("APR", params["yourMonthParm"]);</pre>
 
Note to be safe, that in your original query text, you may want to use an obscure dummy text name for that month in the original text such as XXXXXXX so that you won't clobber any other values that may have "APR". Or instead of searching for "APR", you search for "sum(APR_" and you replace it with "sum(" plus the parameter month plus "_".