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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 19 November 2014 09:40

dario di franceschi

Messages: 1
Registered: November 2014

Junior Member

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

Report message to a moderator

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

Wed, 19 November 2014 18:10

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

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

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:42:56 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter