Eclipse Community Forums: BIRT » change query depending on locale [solved]

Home » Archived » BIRT » change query depending on locale [solved]

change query depending on locale [solved] [message #1223515]

Mon, 23 December 2013 11:21

Eclipse User

Hi

I'm trying to modify the SQL query for a Chart depending on the locale. What I get so far :

beforeFactory

var mylocale=reportContext.getLocale().toString().substr(1,2)

But I'm stuck on retrieving the parameter and inserting on the query. Something like this:

Select * from table where country=' + param["mylocale"] + '

Any help would be much appreciated

[Updated on: Fri, 07 February 2014 12:53] by Moderator

Re: change query depending on locale [message #1240442 is a reply to message #1223515]

Thu, 06 February 2014 08:19

Eclipse User

any hint?

Re: change query depending on locale [message #1240476 is a reply to message #1240442]

Thu, 06 February 2014 09:53

Eclipse User

I don't think it is necessary to use a report parameter such "mylocale" here. You could try this:

In the query of your dataset, use a question mark like this:

Select * from table where country=?

Then in parameters section of the dataset, edit the parameter and just fill the "Default value" property with the expression you mentionned:

reportContext.getLocale().toString().substr(1,2)

I hope this helps!

Re: change query depending on locale [message #1240557]

Thu, 06 February 2014 14:07

Eclipse User

Hi donino

i'm afraid I gave a wrong example.
The real query is more a thing like this:

If locale is French, select French_name, french_description from product

If locale is English, select englîsh_name, english_description from product

I can get the locale but I'm stuck on getting the proper SQL to work in the dataset

Thanks in advance

[Updated on: Thu, 06 February 2014 15:58] by Moderator

Re: change query depending on locale [message #1240983 is a reply to message #1240557]

Fri, 07 February 2014 04:50

Eclipse User

In this case you need to change your query depending on the value of the locale. In the beforeOpen script of the dataset. You probably need to use aliases so that BIRT can still match columns dataset with the result of the query. It would be something like:

var mylocale=reportContext.getLocale().toString().substr(1,2);
if (mylocale=="fr"){
    this.queryText="select French_name as name, french_description as description from product";
}else if(mylocale=="en"){
    this.queryText="select englîsh_name as name, english_description as description from product";
}

Let me know if it helps

[Updated on: Fri, 07 February 2014 04:54] by Moderator

Re: change query depending on locale [message #1241250 is a reply to message #1240983]

Fri, 07 February 2014 12:52

Eclipse User

So easy I feel stupid right now Sad

worked perfectly.

Thanks domino

[Updated on: Fri, 07 February 2014 12:53] by Moderator

Re: change query depending on locale [message #1371736 is a reply to message #1240476]

Wed, 21 May 2014 10:16

Eclipse User

donino donino wrote:
> I don't think it is necessary to use a report parameter such "mylocale"
> here. You could try this:
>
> In the query of your dataset, use a question mark like this:
> Select * from table where country=?
>
> Then in parameters section of the dataset, edit the parameter and just
> fill the "Default value" property with the expression you mentionned:
> reportContext.getLocale().toString().substr(1,2)
>
> I hope this helps!

Jose,
You could use something like this in the beforeOpen() of the data source

var locale = reportContext.getLocale().toString()
locale = locale.substr(3,4);

this.queryText = "select * from customers where country = '" + locale + "'";

Previous Topic:	I need some help with few things - drill, hyperlinks etc.
Next Topic:	BIRT Report ppt is not opening in MS Office 2013

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 19:19:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter