Eclipse Community Forums: BIRT » Perform sorting based on user input

Home » Archived » BIRT » Perform sorting based on user input

Perform sorting based on user input [message #503331]

Fri, 11 December 2009 12:36

Eclipse User

Hi,

I am exploring possibilities to sort based on user input.
For example, when we run a report, the parameter dialog shows up and it has two radio buttons "Ascending" and "Descending". User can pick either button to decide how a field will be sorted.

I know how to define the parameter but do not know how to use it to sort. please advise.

Re: Perform sorting based on user input [message #503348 is a reply to message #503331]

Fri, 11 December 2009 16:06

Eclipse User

Neil,

You can always define the sort in the beforeFactory

importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.org.eclipse.birt.report.model.api.ele ments);
importPackage(Packages.com.ibm.icu.util);
importPackage(Packages.org.eclipse.birt.data.engine.api);

delm = reportContext.getDesignHandle().findElement("mytable");
sc = StructureFactory.createSortKey();
sc.setKey("row[\"ORDERNUMBER\"]");
sc.setDirection(params["mysortdirection"].value);
ph = delm.getPropertyHandle(TableHandle.SORT_PROP);
ph.addItem(sc);

or modify an existing one like:

delm = reportContext.getDesignHandle().findElement("mytable2");
ph = delm.getPropertyHandle(TableHandle.SORT_PROP);
//get number or iterate
sk = ph.get(0);
sk.setDirection(params["mysortdirection"].value);

the parameter mysortdirection needs to be either desc or asc.

Jason

Neil Wang wrote:
> Hi,
>
> I am exploring possibilities to sort based on user input.
> For example, when we run a report, the parameter dialog shows up and it
> has two radio buttons "Ascending" and "Descending". User can pick either
> button to decide how a field will be sorted.
>
> I know how to define the parameter but do not know how to use it to
> sort. please advise.

Re: Perform sorting based on user input [message #503787 is a reply to message #503348]

Tue, 15 December 2009 13:59

Eclipse User

Hi,

Thank you for your reply. This is what I have done:
1. I have this in the beforeFactory script.
importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.org.eclipse.birt.report.model.api.ele ments);
importPackage(Packages.com.ibm.icu.util);
importPackage(Packages.org.eclipse.birt.data.engine.api);

delm = reportContext.getDesignHandle().findElement("Package");
sc = StructureFactory.createSortKey();
sc.setKey("row[\"ORDERNUMBER\"]");
sc.setDirection(params["SortDirection"].value);
ph = delm.getPropertyHandle(TableHandle.SORT_PROP);
ph.addItem(sc);

and this is what I got:
The following items have errors:

Table Package:
- Fail to compute value from sort, group or filter expression.
A BIRT exception occurred: There are errors evaluating script "row[ORDERNUMBER"]"; Invalid bound column name: ORDERNUMBER
Caused by: org.mozilla.javascript.EvaluatorException: Invalid bound column name: ORDERNUMBER.

please advise.

Re: Perform sorting based on user input [message #503802 is a reply to message #503787]

Tue, 15 December 2009 15:50

Eclipse User

Neil,

Select the table in the design you are trying to change sorting on.
Next select the binding tab next to properties. This list all of the
columns you can sort on. Is ORDERNUMBER in this list?

Jason

Neil Wang wrote:
> Hi,
>
> Thank you for your reply. This is what I have done:
> 1. I have this in the beforeFactory script.
> importPackage(Packages.org.eclipse.birt.report.model.api);
> importPackage(Packages.org.eclipse.birt.report.model.api.ele ments);
> importPackage(Packages.com.ibm.icu.util);
> importPackage(Packages.org.eclipse.birt.data.engine.api);
>
> delm = reportContext.getDesignHandle().findElement("Package");
> sc = StructureFactory.createSortKey();
> sc.setKey("row[\"ORDERNUMBER\"]");
> sc.setDirection(params["SortDirection"].value);
> ph = delm.getPropertyHandle(TableHandle.SORT_PROP);
> ph.addItem(sc);
>
> and this is what I got:
> The following items have errors:
>
> Table Package:
> - Fail to compute value from sort, group or filter expression.
> A BIRT exception occurred: There are errors evaluating script
> "row[ORDERNUMBER"]"; Invalid bound column name: ORDERNUMBER
> Caused by: org.mozilla.javascript.EvaluatorException: Invalid bound
> column name: ORDERNUMBER.
>
> please advise.

Re: Perform sorting based on user input [message #503847 is a reply to message #503802]

Tue, 15 December 2009 14:42

Eclipse User

Hi Jason,

I don't have "ORDERNUMBER" in any of the data set. One of the data sets is called "Package" and there is a table called "Package" in the layout. My goal is to be able to sort the entries in the detail row of the "Package" table. I can definitely add a field called "ORDERNUMBER" under the "Package" data set and establish a binding between "ORDERNUMBER" and the "Package" table in the layout. Should I do this? If yes, what value should it have?
Also, I am using BIRT 2.3.2.

please advise.

Re: Perform sorting based on user input [message #503857 is a reply to message #503847]

Tue, 15 December 2009 19:18

Eclipse User

Neil,

Swap
sc.setKey("row[\"ORDERNUMBER\"]");

with whatever column you want to sort on
sc.setKey("row[\"MYCOL\"]");

Jason

Neil Wang wrote:
> Hi Jason,
>
> I don't have "ORDERNUMBER" in any of the data set. One of the data sets
> is called "Package" and there is a table called "Package" in the layout.
> My goal is to be able to sort the entries in the detail row of the
> "Package" table. I can definitely add a field called "ORDERNUMBER" under
> the "Package" data set and establish a binding between "ORDERNUMBER" and
> the "Package" table in the layout. Should I do this? If yes, what value
> should it have?
> Also, I am using BIRT 2.3.2.
>
> please advise.

Re: Perform sorting based on user input [message #503994 is a reply to message #503857]

Wed, 16 December 2009 13:34

Eclipse User

It works. Thank you very much.

Previous Topic:	BIRT Master page
Next Topic:	Rounding behaviour BIRT and Excel

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 00:46:44 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter