Eclipse Community Forums: BIRT » BIRT - selecting certain values of a dataset

Home » Archived » BIRT » BIRT - selecting certain values of a dataset

BIRT - selecting certain values of a dataset [message #1479261]

Wed, 19 November 2014 04:40

Eclipse User

Hi!
I'm a newbie in Birt ad I got a simple question hopefully,
I have a dataset with several columns, obtained from a .csv file, and from it I created a report aggregated by one of them (ex. ID).
Now I have to extract a certain value from a certain column in correspondance of a certain value of another column.
In SQL I'd do this:

SELECT column1
FROM table
WHERE column2 = "value"

I tried several things, including creating a computed column like this:

Data Type. String
Aggregation: First
Expression: row["column1"]
Filter: BirtComp.equalTo(row["column2"],"value")

but the result is not what I'm searching for.

Hope to get a response from you,

Thanks,

Dario

Re: BIRT - selecting certain values of a dataset [message #1479765 is a reply to message #1479261]

Wed, 19 November 2014 13:10

Eclipse User

I am not sure I understand what you are trying to accomplish, but the first two options that pop to mind are 1) use a sub-query or 2) use a filter

Previous Topic:	Using hibernate datasource with Birt 4.3.2
Next Topic:	Caused by: org.eclipse.birt.chart.exception.ChartException: Duplicate aggregation name: COUNT

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 14 23:29:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter