| How to get dataset filters [message #55608] |
Thu, 16 April 2009 11: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 .
|
|
|
|
|
|
| Re: How to get dataset filters [message #56074 is a reply to message #56047] |
Mon, 27 April 2009 23:31  |
| Eclipse User |
|
|
|
> 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 12:00 |
| Eclipse User |
|
|
|
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 18:41 |
| Eclipse User |
|
|
|
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 06: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
|
|
|
| Re: How to get dataset filters [message #595657 is a reply to message #56047] |
Mon, 27 April 2009 23:31 |
| Eclipse User |
|
|
|
> 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
|
|
|
Powered by
FUDForum. Page generated in 0.51254 seconds
Home