OFBiz data sources for BIRT
Locked
 
|
I do not want to use SQL to define my reports in BIRT as I do not
think I can get the performance that I need. Are there other options that are more OFBiz-centric than writing Mysql stored procedures. Thanks, -Al |
|
You can retrieve the data with minilanguage....
examples in the system. or look in the ofbiz help index, there is a chapter on birt. Regards, Hans -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: > I do not want to use SQL to define my reports in BIRT as I do not > think I can get the performance that I need. Are there other options > that are more OFBiz-centric than writing Mysql stored procedures. > > Thanks, > > -Al -- Ofbiz on twitter: http://twitter.com/apache_ofbiz Myself on twitter: http://twitter.com/hansbak Antwebsystems.com: Quality services for competitive rates. |
Re: OFBiz data sources for BIRT
|
|
Hello Byers,
You can also use groovy for retrieving data and put them in birtParameters map and pass the map to rptdesign or else you can get data in rptdesign itself. -- Thanks and Regards Santosh Malviya On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker <[hidden email]>wrote: > You can retrieve the data with minilanguage.... > examples in the system. > > or look in the ofbiz help index, there is a chapter on birt. > > Regards, > Hans > > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Myself on twitter: http://twitter.com/hansbak > Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > Quality services for competitive rates. > > On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: > > I do not want to use SQL to define my reports in BIRT as I do not > > think I can get the performance that I need. Are there other options > > that are more OFBiz-centric than writing Mysql stored procedures. > > > > Thanks, > > > > -Al > > -- > Ofbiz on twitter: http://twitter.com/apache_ofbiz > Myself on twitter: http://twitter.com/hansbak > Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > Quality services for competitive rates. > > |
|
|
Thanks Santosh and Hans. Please see questions below.
On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya <[hidden email]> wrote: > Hello Byers, > > You can also use groovy for retrieving data and put them in birtParameters > map and pass the map to rptdesign or else you can get data in rptdesign > itself. I am familiar with setting birtParameters as input to sql query statements, but you are saying that I could pass in entire datasets? Could you direct me to anything that explains how to tell birt to use that parameter for the dataset? > > -- > Thanks and Regards > Santosh Malviya > > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker > <[hidden email]>wrote: > >> You can retrieve the data with minilanguage.... >> examples in the system. Are you saying that there are examples in the system of where the minilanguage is used to retrieve data and that data is then passed to a birt report? If that is the case can anyone help me find those examples; I looked for all instances of "birt" but not sure that would have helped me find it. >> >> or look in the ofbiz help index, there is a chapter on birt. I had found a chapter on how to set up birt and how to setup a SQL based data source. Do you know if there is help content that talks about using other data sources or was that probably the chapter you were thinking of? Thanks again, -Al >> >> Regards, >> Hans >> >> >> -- >> Ofbiz on twitter: http://twitter.com/apache_ofbiz >> Myself on twitter: http://twitter.com/hansbak >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: >> Quality services for competitive rates. >> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: >> > I do not want to use SQL to define my reports in BIRT as I do not >> > think I can get the performance that I need. Are there other options >> > that are more OFBiz-centric than writing Mysql stored procedures. >> > >> > Thanks, >> > >> > -Al >> >> -- >> Ofbiz on twitter: http://twitter.com/apache_ofbiz >> Myself on twitter: http://twitter.com/hansbak >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: >> Quality services for competitive rates. >> >> > |
Re: OFBiz data sources for BIRT
|
|
Hello Byers,
Inline............. On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <[hidden email]>wrote: > Thanks Santosh and Hans. Please see questions below. > > On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya > <[hidden email]> wrote: > > Hello Byers, > > > > You can also use groovy for retrieving data and put them in > birtParameters > > map and pass the map to rptdesign or else you can get data in rptdesign > > itself. > > I am familiar with setting birtParameters as input to sql query > statements, but you are saying that I could pass in entire datasets? > Could you direct me to anything that explains how to tell birt to use > that parameter for the dataset? > Consider following example: - If I want to show firstName and lastName in rptdesign then I'll do following in groovy birtParameters = []; person = delegator.findOne("Person", [partyId : partyId], false); firstName = person.firstName; lastName = person.lastName; birtParameters.firstName = firstName; birtParameters.lastName = lastName; request.setAttribute("birtParameters", birtParameters); In rptdesign I have to do following: in open method: - firstName = params["firstName"].value; lastName = params["lastName"].value; in fetch method: - row["firstName"] = firstName; row["lastName"] = lastName; make sure datasets are same as firstName and lastName. HTH > > > > > -- > > Thanks and Regards > > Santosh Malviya > > > > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker > > <[hidden email]>wrote: > > > >> You can retrieve the data with minilanguage.... > >> examples in the system. > > Are you saying that there are examples in the system of where the > minilanguage is used to retrieve data and that data is then passed to > a birt report? If that is the case can anyone help me find those > examples; I looked for all instances of "birt" but not sure that would > have helped me find it. > > >> > >> or look in the ofbiz help index, there is a chapter on birt. > > I had found a chapter on how to set up birt and how to setup a SQL > based data source. Do you know if there is help content that talks > about using other data sources or was that probably the chapter you > were thinking of? > > Thanks again, > > -Al > > >> > >> Regards, > >> Hans > >> > >> > >> -- > >> Ofbiz on twitter: http://twitter.com/apache_ofbiz > >> Myself on twitter: http://twitter.com/hansbak > >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > >> Quality services for competitive rates. > >> > >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: > >> > I do not want to use SQL to define my reports in BIRT as I do not > >> > think I can get the performance that I need. Are there other options > >> > that are more OFBiz-centric than writing Mysql stored procedures. > >> > > >> > Thanks, > >> > > >> > -Al > >> > >> -- > >> Ofbiz on twitter: http://twitter.com/apache_ofbiz > >> Myself on twitter: http://twitter.com/hansbak > >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > >> Quality services for competitive rates. > >> > >> > > > -- Thanks and Regards Santosh Malviya |
|
|
Santosh,
Thank you, that was extremely helpful. Do you think the concept can be extended to passing in a list of rows as birtParameters? -Al On Wed, Jul 28, 2010 at 11:45 PM, Santosh Malviya <[hidden email]> wrote: > Hello Byers, > > Inline............. > > On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <[hidden email]>wrote: > >> Thanks Santosh and Hans. Please see questions below. >> >> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya >> <[hidden email]> wrote: >> > Hello Byers, >> > >> > You can also use groovy for retrieving data and put them in >> birtParameters >> > map and pass the map to rptdesign or else you can get data in rptdesign >> > itself. >> >> I am familiar with setting birtParameters as input to sql query >> statements, but you are saying that I could pass in entire datasets? >> Could you direct me to anything that explains how to tell birt to use >> that parameter for the dataset? >> > > Consider following example: - > If I want to show firstName and lastName in rptdesign then I'll do following > in groovy > birtParameters = []; > person = delegator.findOne("Person", [partyId : partyId], false); > firstName = person.firstName; > lastName = person.lastName; > > birtParameters.firstName = firstName; > birtParameters.lastName = lastName; > request.setAttribute("birtParameters", birtParameters); > > In rptdesign I have to do following: > > in open method: - > > firstName = params["firstName"].value; > lastName = params["lastName"].value; > > in fetch method: - > > row["firstName"] = firstName; > row["lastName"] = lastName; > > make sure datasets are same as firstName and lastName. > > HTH > >> >> > >> > -- >> > Thanks and Regards >> > Santosh Malviya >> > >> > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker >> > <[hidden email]>wrote: >> > >> >> You can retrieve the data with minilanguage.... >> >> examples in the system. >> >> Are you saying that there are examples in the system of where the >> minilanguage is used to retrieve data and that data is then passed to >> a birt report? If that is the case can anyone help me find those >> examples; I looked for all instances of "birt" but not sure that would >> have helped me find it. >> >> >> >> >> or look in the ofbiz help index, there is a chapter on birt. >> >> I had found a chapter on how to set up birt and how to setup a SQL >> based data source. Do you know if there is help content that talks >> about using other data sources or was that probably the chapter you >> were thinking of? >> >> Thanks again, >> >> -Al >> >> >> >> >> Regards, >> >> Hans >> >> >> >> >> >> -- >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz >> >> Myself on twitter: http://twitter.com/hansbak >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: >> >> Quality services for competitive rates. >> >> >> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: >> >> > I do not want to use SQL to define my reports in BIRT as I do not >> >> > think I can get the performance that I need. Are there other options >> >> > that are more OFBiz-centric than writing Mysql stored procedures. >> >> > >> >> > Thanks, >> >> > >> >> > -Al >> >> >> >> -- >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz >> >> Myself on twitter: http://twitter.com/hansbak >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: >> >> Quality services for competitive rates. >> >> >> >> >> > >> > > > > -- > Thanks and Regards > Santosh Malviya > |
Re: OFBiz data sources for BIRT
|
|
Hello Byers,
I didn't try it but if you want to pass a list then you have to put the list into the birtParameters and then iterate that list in fetch method of rptdesign. -- Thanks and Regards Santosh Malviya On Thu, Jul 29, 2010 at 11:29 AM, Al Byers <[hidden email]>wrote: > Santosh, > > Thank you, that was extremely helpful. Do you think the concept can be > extended to passing in a list of rows as birtParameters? > > -Al > > On Wed, Jul 28, 2010 at 11:45 PM, Santosh Malviya > <[hidden email]> wrote: > > Hello Byers, > > > > Inline............. > > > > On Thu, Jul 29, 2010 at 10:11 AM, Al Byers <[hidden email] > >wrote: > > > >> Thanks Santosh and Hans. Please see questions below. > >> > >> On Wed, Jul 28, 2010 at 9:57 PM, Santosh Malviya > >> <[hidden email]> wrote: > >> > Hello Byers, > >> > > >> > You can also use groovy for retrieving data and put them in > >> birtParameters > >> > map and pass the map to rptdesign or else you can get data in > rptdesign > >> > itself. > >> > >> I am familiar with setting birtParameters as input to sql query > >> statements, but you are saying that I could pass in entire datasets? > >> Could you direct me to anything that explains how to tell birt to use > >> that parameter for the dataset? > >> > > > > Consider following example: - > > If I want to show firstName and lastName in rptdesign then I'll do > following > > in groovy > > birtParameters = []; > > person = delegator.findOne("Person", [partyId : partyId], false); > > firstName = person.firstName; > > lastName = person.lastName; > > > > birtParameters.firstName = firstName; > > birtParameters.lastName = lastName; > > request.setAttribute("birtParameters", birtParameters); > > > > In rptdesign I have to do following: > > > > in open method: - > > > > firstName = params["firstName"].value; > > lastName = params["lastName"].value; > > > > in fetch method: - > > > > row["firstName"] = firstName; > > row["lastName"] = lastName; > > > > make sure datasets are same as firstName and lastName. > > > > HTH > > > >> > >> > > >> > -- > >> > Thanks and Regards > >> > Santosh Malviya > >> > > >> > On Thu, Jul 29, 2010 at 6:35 AM, Hans Bakker > >> > <[hidden email]>wrote: > >> > > >> >> You can retrieve the data with minilanguage.... > >> >> examples in the system. > >> > >> Are you saying that there are examples in the system of where the > >> minilanguage is used to retrieve data and that data is then passed to > >> a birt report? If that is the case can anyone help me find those > >> examples; I looked for all instances of "birt" but not sure that would > >> have helped me find it. > >> > >> >> > >> >> or look in the ofbiz help index, there is a chapter on birt. > >> > >> I had found a chapter on how to set up birt and how to setup a SQL > >> based data source. Do you know if there is help content that talks > >> about using other data sources or was that probably the chapter you > >> were thinking of? > >> > >> Thanks again, > >> > >> -Al > >> > >> >> > >> >> Regards, > >> >> Hans > >> >> > >> >> > >> >> -- > >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz > >> >> Myself on twitter: http://twitter.com/hansbak > >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > >> >> Quality services for competitive rates. > >> >> > >> >> On Wed, 2010-07-28 at 18:00 -0600, Al Byers wrote: > >> >> > I do not want to use SQL to define my reports in BIRT as I do not > >> >> > think I can get the performance that I need. Are there other > options > >> >> > that are more OFBiz-centric than writing Mysql stored procedures. > >> >> > > >> >> > Thanks, > >> >> > > >> >> > -Al > >> >> > >> >> -- > >> >> Ofbiz on twitter: http://twitter.com/apache_ofbiz > >> >> Myself on twitter: http://twitter.com/hansbak > >> >> Antwebsystems.com <http://twitter.com/hansbak%0AAntwebsystems.com>: > >> >> Quality services for competitive rates. > >> >> > >> >> > >> > > >> > > > > > > > > -- > > Thanks and Regards > > Santosh Malviya > > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |