Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to get dataset filters
How to get dataset filters [message #55608] Thu, 16 April 2009 15:56 Go to next message
Eclipse UserFriend
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 .
Re: How to get dataset filters [message #55635 is a reply to message #55608] Thu, 16 April 2009 16:00 Go to previous messageGo to next message
Eclipse UserFriend
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 .
>
>
Re: How to get dataset filters [message #55996 is a reply to message #55608] Fri, 24 April 2009 22:41 Go to previous messageGo to next message
Linda ChanFriend
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
Re: How to get dataset filters [message #56047 is a reply to message #55996] Mon, 27 April 2009 10:11 Go to previous messageGo to next message
Eclipse UserFriend
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
Re: How to get dataset filters [message #56074 is a reply to message #56047] Tue, 28 April 2009 03:31 Go to previous message
Linda ChanFriend
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
Re: How to get dataset filters [message #595529 is a reply to message #55608] Thu, 16 April 2009 16:00 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
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 .
>
>
Re: How to get dataset filters [message #595634 is a reply to message #55608] Fri, 24 April 2009 22:41 Go to previous message
Linda ChanFriend
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
Re: How to get dataset filters [message #595652 is a reply to message #55996] Mon, 27 April 2009 10:11 Go to previous message
Eclipse UserFriend
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
Re: How to get dataset filters [message #595657 is a reply to message #56047] Tue, 28 April 2009 03:31 Go to previous message
Linda ChanFriend
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
Previous Topic:Open Data Access (ODA) API Changes in Galileo
Next Topic:A few last-minute changes to DTP APIs (sorry for late notice)
Goto Forum:
  


Current Time: Sun Nov 29 08:50:35 GMT 2020

Powered by FUDForum. Page generated in 0.02240 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top