You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Amine AZZI <ba...@gmail.com> on 2007/07/04 22:22:22 UTC

GenericDelegator

Hi all,

I am working on a project where reports are generated through BIRT. I am
using the scripting feature to make the data set.
In the script I am instanciating a org.ofbiz.entity.GenericDelegator object.
and I am using the findAll method to retireive a complete list of a entity.

The report works fine but it gives me only the half of the true count of the
entities in the database. I tries a new BIRT report using a direct JDBC
connection and the report gives the total number.

Does the GenericDelegator use a pagination feature, and how I can disable
it? or at least make the number the records taken at once greater.

Regards.
Amine.

Re: GenericDelegator

Posted by Rodrigo Souza <ac...@gmail.com>.
Ok,

Welcome to OfBiz! ;)

2007/7/4, Amine AZZI <ba...@gmail.com>:
> I found the problem, I forgot to check for null values on a field. and BIRT
> stopped retrieving rows from that row and on, stangely the problem record
> was exactly at the middle of the table, which made me think that the
> GenericDelegator don't retrieve all records at once.
>
> Sorry for the noise.
> Amine.
>
> 2007/7/4, Rodrigo Souza <ac...@gmail.com>:
> >
> > 2 ways,
> >
> > 1 - Use selectCountByCondition; ( High cost, two querys executes)
> >
> > 2 - Use selectListIteratorByCondition; ( Low cost - do not create
> > instance of GenericValues). See PartyServices.findParty method to
> > example.
> >
> >
> >
> >
> > 2007/7/4, Amine AZZI <ba...@gmail.com>:
> > > Hi all,
> > >
> > > I am working on a project where reports are generated through BIRT. I am
> > > using the scripting feature to make the data set.
> > > In the script I am instanciating a org.ofbiz.entity.GenericDelegatorobject.
> > > and I am using the findAll method to retireive a complete list of a
> > entity.
> > >
> > > The report works fine but it gives me only the half of the true count of
> > the
> > > entities in the database. I tries a new BIRT report using a direct JDBC
> > > connection and the report gives the total number.
> > >
> > > Does the GenericDelegator use a pagination feature, and how I can
> > disable
> > > it? or at least make the number the records taken at once greater.
> > >
> > > Regards.
> > > Amine.
> > >
> >
>

Re: GenericDelegator

Posted by Amine AZZI <ba...@gmail.com>.
I found the problem, I forgot to check for null values on a field. and BIRT
stopped retrieving rows from that row and on, stangely the problem record
was exactly at the middle of the table, which made me think that the
GenericDelegator don't retrieve all records at once.

Sorry for the noise.
Amine.

2007/7/4, Rodrigo Souza <ac...@gmail.com>:
>
> 2 ways,
>
> 1 - Use selectCountByCondition; ( High cost, two querys executes)
>
> 2 - Use selectListIteratorByCondition; ( Low cost - do not create
> instance of GenericValues). See PartyServices.findParty method to
> example.
>
>
>
>
> 2007/7/4, Amine AZZI <ba...@gmail.com>:
> > Hi all,
> >
> > I am working on a project where reports are generated through BIRT. I am
> > using the scripting feature to make the data set.
> > In the script I am instanciating a org.ofbiz.entity.GenericDelegatorobject.
> > and I am using the findAll method to retireive a complete list of a
> entity.
> >
> > The report works fine but it gives me only the half of the true count of
> the
> > entities in the database. I tries a new BIRT report using a direct JDBC
> > connection and the report gives the total number.
> >
> > Does the GenericDelegator use a pagination feature, and how I can
> disable
> > it? or at least make the number the records taken at once greater.
> >
> > Regards.
> > Amine.
> >
>

Re: GenericDelegator

Posted by Rodrigo Souza <ac...@gmail.com>.
2 ways,

1 - Use selectCountByCondition; ( High cost, two querys executes)

2 - Use selectListIteratorByCondition; ( Low cost - do not create
instance of GenericValues). See PartyServices.findParty method to
example.




2007/7/4, Amine AZZI <ba...@gmail.com>:
> Hi all,
>
> I am working on a project where reports are generated through BIRT. I am
> using the scripting feature to make the data set.
> In the script I am instanciating a org.ofbiz.entity.GenericDelegator object.
> and I am using the findAll method to retireive a complete list of a entity.
>
> The report works fine but it gives me only the half of the true count of the
> entities in the database. I tries a new BIRT report using a direct JDBC
> connection and the report gives the total number.
>
> Does the GenericDelegator use a pagination feature, and how I can disable
> it? or at least make the number the records taken at once greater.
>
> Regards.
> Amine.
>