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; } } }

to get all value in list box by dynamic query

404040

i am having query with multiple table but i didt get in before open script can u give clear idea to get value for all and particular value

my databases

SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;

can u give idea for get value in dynamic query in before open?

with script?

Find more posts tagged with

Comments

kclark

If I understand you're wanting to add a "Select All" value to your parameter and allowing the user to select this? If that's what you're trying to do <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/356-all-parameter-values/'>take a look at this devshare</a> You can add "All Customers" as the default parameter then add some script like this in the beforeOpen of your dataset<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if( params["NewParameter"].value != "(All Customers)" ){

this.queryText = this.queryText + " where customernumber = " + params["NewParameter"].value
}</pre>

404040

thanks for replying my question .... u r point view is only one table.... but in my databases am having three table with "where" condition then "and" condition when i tried your query it is say that " sql query cant get result set data" like that ...........and

so give some idea to understood clearly because am new to birt ...

consider am having a list box with "all" and "particular name" ......or else with check box for "all" and list box to select "particular name" give idea according to my query.......plz..plz..plz....

404040

thanks for replying my question .... u r point view is only one table.... but in my databases am having three table with "where" condition then "and" condition when i tried your query it is say that " sql query cant get result set data" like that ...........and

SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;

so give some idea to understood clearly because am new to birt ...

consider am having a list box with "all" and "particular name" ......or else with check box for "all" and list box to select "particular name" give idea according to my query.......plz..plz..plz....

kclark

Are you trying to have one list box with "All" as an option or several? Looking at your statement it looks like you need to use double quotes instead of single.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT O_OUTLET_NAME as "NAME",OIF_ITEM_CODE as "code",IM_ITEM_NAME as "ITEM NAME",OIF_RATE as "RATE",OIF_QTY*OIF_RATE as "AMOUNT",OIF_DISCOUNT as "DISCOUNT",OIF_TAX as "TAX",OIF_AMOUNT as "NETAMOUNT"
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;</pre>

404040

thank for reply

screen_Tes

hi,

our requirement

List box contains list of outlet and "ALL" outlet option
that is

ALL
outlet1
outlet2
outlet3
.
.

Now i want click All , display all outlet sales details .
select outlet1, display outlet sales details for that outlet only
Note :

Sales details are pointed another table.

How to execute another query/ Sales table query ?