Eclipse Community Forums: DTP » How to get dataset filters

Help

Home

Home » Eclipse Projects » DTP » How to get dataset filters

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

How to get dataset filters [message #55608]

Thu, 16 April 2009 15:56

Eclipse User

Originally posted by: f.paillette.idea-informatique.fr

Hi,
First of all, I am a newbi and I hope I am in the good group...
I work with a personal ODA plugin and I have troubles when I prepare queries
on big tables (+-800 000 rows) because my filters are not applied in my
query in the Prepare function.
So, I want to get access to dataset filters in my Query.Prepare function.
I don't know how to obtain pointer to theses last.

Someone to help me ?

Thanks in advance, Frederic

PS : Sorry for my bad English .

Report message to a moderator

Re: How to get dataset filters [message #55635 is a reply to message #55608]

Thu, 16 April 2009 16:00

Eclipse User

Originally posted by: brianf.sybase.com

Hi Frederic!

Unfortunately the person best apt to help you is on vacation until next week
sometime. But hopefully she can answer your question upon her return...

--Fitz

"Frederic PAILLETTE" <f.paillette@idea-informatique.fr> wrote in message
news:gs7kf6$23k$1@build.eclipse.org...
> Hi,
> First of all, I am a newbi and I hope I am in the good group...
> I work with a personal ODA plugin and I have troubles when I prepare
> queries
> on big tables (+-800 000 rows) because my filters are not applied in my
> query in the Prepare function.
> So, I want to get access to dataset filters in my Query.Prepare function.
> I don't know how to obtain pointer to theses last.
>
> Someone to help me ?
>
>
> Thanks in advance, Frederic
>
> PS : Sorry for my bad English .
>
>

Report message to a moderator

Re: How to get dataset filters [message #55996 is a reply to message #55608]

Fri, 24 April 2009 22:41

Linda Chan

Messages: 845
Registered: July 2009

Senior Member

Hi Frederic,

By "dataset filters", I presume you meant input parameter on a data set
query?
Which version of DTP or BIRT are you using? Prior to DTP 1.7, the ODA
runtime API sets an input parameter value only after IQuery#prepare, and
before it is executed. In 1.7, new experimental API is introduced to pass
in parameter and property values to an IQuery before its query text is
prepared; see http://wiki.eclipse.org/Galileo_DTP_ODA_API_Changes_Spec

So if you are working with the earlier API, one way to handle this is to do
minimal syntax checking at #prepare, and defer the full "prepare" operations
till #executeQuery is called. Hope this helps.

Linda

Report message to a moderator

Re: How to get dataset filters [message #56047 is a reply to message #55996]

Mon, 27 April 2009 10:11

Eclipse User

Originally posted by: f.paillette.idea-informatique.fr

Hi Linda,

Thanks for your answer.

By "dataset filters", I mean filters declared in the dataset editor window.
My query is designed graphicaly so I can't insert filters in the query. That
is why I want to get filters declared 2 tabs below to apply them.

I use DTP 1.6.2 and BIRT 2.3.2

So either I will update the version of DTP, or using the basic filter
verification. Assuming that I prefer start by perform a minimal syntax
checking, how do I access the filter from the Prepare and Execute functions
?

Thank you in advance

Frederic

"Linda Chan" <lchan@actuate.com> a

Report message to a moderator

Re: How to get dataset filters [message #56074 is a reply to message #56047]

Tue, 28 April 2009 03:31

Linda Chan

Messages: 845
Registered: July 2009

Senior Member

> By "dataset filters", I mean filters declared in the dataset editor
> window.
> My query is designed graphicaly so I can't insert filters in the query.
> That
> is why I want to get filters declared 2 tabs below to apply them.
> how do I access the filter from the Prepare and Execute functions

I'm afraid the "Filters" defined in BIRT Data Set Editor is something
defined purely in the BIRT host, and are not visible to an ODA data
provider. In other words, the BIRT filters' processing is handled by the
BIRT data engine, and are not pushed down to an ODA runtime driver.
Can you use "Parameters" instead, whose input values do get passed to an ODA
runtime driver via the call to IQuery#set<datatype> methods?
You can enable the Parameters tab in BIRT Data Set Editor by configuring
your o.e.d.c.oda.design.ui.dataSource extension's dataSetUI element:
<dataSetUI

supportsInParameters="true"

....

</dataSetUI>

Linda

Report message to a moderator

Re: How to get dataset filters [message #595529 is a reply to message #55608]

Thu, 16 April 2009 16:00

Brian Fitzpatrick

Messages: 500
Registered: July 2009

Senior Member

Hi Frederic!

Unfortunately the person best apt to help you is on vacation until next week
sometime. But hopefully she can answer your question upon her return...

--Fitz

"Frederic PAILLETTE" <f.paillette@idea-informatique.fr> wrote in message
news:gs7kf6$23k$1@build.eclipse.org...
> Hi,
> First of all, I am a newbi and I hope I am in the good group...
> I work with a personal ODA plugin and I have troubles when I prepare
> queries
> on big tables (+-800 000 rows) because my filters are not applied in my
> query in the Prepare function.
> So, I want to get access to dataset filters in my Query.Prepare function.
> I don't know how to obtain pointer to theses last.
>
> Someone to help me ?
>
>
> Thanks in advance, Frederic
>
> PS : Sorry for my bad English .
>
>

Report message to a moderator