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

Passing Multiple values On Single Parameter

Abdur Rahmaan · 2016-06-27T15:12:46+00:00

Hi, After going through several posts related to passing multiple values on a single parameter, i wrote my sql in the BIRT dataset as select m.country,tp.categoryLev1 ,tp.categoryLev2,m.sentiment, (case when m.sentiment=1 then 'S1' when m.sentiment=2 then 'S2' when…

Abdur Rahmaan

Hi,
 
After going through several posts related to passing multiple values on a single parameter, i wrote my sql in the BIRT dataset as select m.country,tp.categoryLev1 ,tp.categoryLev2,m.sentiment, 
(case when m.sentiment=1 then 'S1' when m.sentiment=2 then 'S2' 
when m.sentiment=3 then 'S3' when m.sentiment=4 then 'S4' end) as rating 
from mentionmysql.topic tp 
join mentionmysql.master m on m._id=tp._id 
where m.Country like ? and tp.categoryLev1 IN ('****') and m.MentionCreatedDate between str_to_date(?,'%d/%m/%Y') and str_to_date(?,'%d/%m/%Y'); 
and wrote the script for before open for the same dataset as ,
 
this.queryText = this.queryText.replace("****", params["CategoryLev1"].value.join(","));
 
Yet i did not get any positive result.
FYI I use spagobi studio (Eclipse Platform Version: Luna SR2 (4.4.2)) for creating BIRT report.
 
My parameter name is CategoryLev1. All parameters are defined as text box so that I can configure these parameters as list box on spagobi server.
 
can anyone help me out. Thanks

Find more posts tagged with

Comments

Abdur Rahmaan

Has anybody solution for this ?. Please inform me as it is very urgent. FYI i need to pass characters as multiple values (for eg: 'Products','Terms','Parts',....) and not id's.

pricher

Hi,
 
The statement
 
this.queryText = this.queryText.replace("****", params["CategoryLev1"].value.join(","));
 
works only when the report parameter is defined as a List, a Combo Box, or a Radio Button. In this case, the parameter values are returned as an array and the "join" method is used to convert the array into a list.
 
Instead, try using
 
this.queryText = this.queryText.replace("'****'", params["CategoryLev1"].value);
 
Notice also that you need to replace '****', not just ****.
 
Hope this helps,
 
P.

Abdur Rahmaan

Thanks a lot. It is working now..

simbam

I found out the solution to this problem is 
 
select m.country,tp.categoryLev1 ,tp.categoryLev2,m.sentiment, 
(case when m.sentiment=1 then 'S1' when m.sentiment=2 then 'S2' 
when m.sentiment=3 then 'S3' when m.sentiment=4 then 'S4' end) as rating 
from mentionmysql.topic tp 
join mentionmysql.master m on m._id=tp._id where m.Country like ? and tp.categoryLev1 IN ("****") and m.MentionCreatedDate between str_to_date(?,'%d/%m/%Y') and str_to_date(?,'%d/%m/%Y');
 
1.// place (****) place holder in double quotes "" 
 
2.in the script beforeOpen()
 
this.queryText = this.queryText.replace('"****"', params["categoryLev1"].value);
 
 have your quotes like this ' "****"' and make sure parameter categoryLev1 is a textbox