Invoice application query incase of Customer Returns

2023-08-13 Thread Mandar K
Hi Team How ofbiz handles the adjustment of the Sales Invoice against the Customer Return Invoice and the payments made by Customer after deducting the amount. Example: We have Sales Invoice of 1000 $ Customer Returns you items amounting to 200 $, so Customer Return Invoice is created for 200 $.

Re: Gradle Version query and notice of initwrapper.sh error

2023-06-05 Thread SOD OSCARFONO
Thanks Dan, I shared a very basic version of the play I created which is actually an LXC target deployment with postgres. We're keen to avoid Docker, and on glance it seems this is what you're using here, but I'm sure I will find these useful for our purposes. I was able to spend a little ti

Re: Gradle Version query and notice of initwrapper.sh error

2023-06-05 Thread Daniel Watford
Hello, Since you are automating with ansible deployments of OFBiz, you might be interested in the container images that the project is using for the demo servers. Note: Container images are provided by the project as a convenience for users, but are not an officially supported distribution method

Re: Gradle Version query and notice of initwrapper.sh error

2023-06-05 Thread SOD OSCARFONO
Managed to finally get a working setup, creating an Ansible role with the following tasks: --- - name: Install package requirements ansible.builtin.apt: pkg: - curl - git - openjdk-19-jdk state: present update_cache: yes - name: Create direct

Gradle Version query and notice of initwrapper.sh error

2023-06-04 Thread SOD OSCARFONO
Greetings, I'm attempting to build OfBiz as per the instructions located here: https://ofbiz.apache.org/business-users.html#UsrInstall ... and within the INSTALL file. I have successfully downloaded, verified, and extracted the archive contents, yet am stuck as the init-gradle-wrapper.sh scr

Re: Query regarding setting up gitlab ci/cd pipeline for ofbiz

2022-08-29 Thread Jacques Le Roux
Hi Sumesh, This is indeed a known issue: https://issues.apache.org/jira/browse/OFBIZ-11161 HTH Jacques Le 29/08/2022 à 09:32, Sumesh R Acharya a écrit : Hello community, As i seen some example for java project where pipeline generates an artifact (.jar file) after building the project. That

Query regarding setting up gitlab ci/cd pipeline for ofbiz

2022-08-29 Thread Sumesh R Acharya
Hello community, As i seen some example for java project where pipeline generates an artifact (.jar file) after building the project. That jar file can directly be executed without the requirement of any other files. - when trying in local system- In case of ofbiz when running the (ofbiz.jar)

Re: Caching does not work if offset and limit are used in a query

2022-07-08 Thread Nicolas Malin
the query on it has the pagination > implementation. The search on this view returns more than one page of data > and I would like to cache this. I've observed that the cache does not work > as expected if I have the offset and limit in the query. Also, if I change > the page size t

Caching does not work if offset and limit are used in a query

2022-07-07 Thread Rishi Agr
Hi, I have created a view and the query on it has the pagination implementation. The search on this view returns more than one page of data and I would like to cache this. I've observed that the cache does not work as expected if I have the offset and limit in the query. Also, if I change the

Re: Query about Bizzness Time Theme

2022-05-27 Thread Jacques Le Roux
Hi Gokula, Your message has been moderated, else it would not have reached this Mailing List. Please subscribe to the user ML for such questions and then use your email client. See why here http://ofbiz.apache.org/mailing-lists.html. You will get a better support, people can answer you on the

Query about Bizzness Time Theme

2022-05-27 Thread Benjamin Franklin
Respected Sir/ Madam, Is there any way that I can able to get bizzness time theme? I know it's been removed from the trunk. I personally liked it and I've searched everywhere but in the end I found that without the styles(only with simple html). If the bizzness time theme is fou

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Madhi Krishnan
he database, you can use EntityQuery > < > https://www.hotwaxsystems.com/ofbiz/ofbiz-development/ofbiz-entity-query-api-simplifies-query-process/ > > > API > > If you still intend to do it using SQL query. You can do that using > SQLProcessor > < > https://ci.a

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Aditya Sharma
Hello Madhi Krishnan, I would recommend using OFBiz OOTB implementation for the database related operations. To fetch data from the database, you can use EntityQuery <https://www.hotwaxsystems.com/ofbiz/ofbiz-development/ofbiz-entity-query-api-simplifies-query-process/> API If you still

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Chandrabhan Pal
          PreparedStatement ps = connection.prepareStatement(rawSQLQuery1);                     ResultSet rs = ps.executeQuery();                     while (rs.next()) {                        //put you logic here with resultSet data                     } catch(Exception e){ //Handle Exception } On 9/20

Re: How to use Raw sql query in ofbiz

2018-09-20 Thread Nicolas Malin
nyone please tell me how to use raw sql query in ofbiz.. If you have any sources or example it will be better.. Thank You

How to use Raw sql query in ofbiz

2018-09-20 Thread Madhi Krishnan
Hey all can anyone please tell me how to use raw sql query in ofbiz.. If you have any sources or example it will be better.. Thank You

[MODERATE EMAIL] Query parameter in SSL request

2017-12-18 Thread Deepak Dixit
Mon, 18 Dec 2017 21:50:04 -0700 (MST) Subject: Query parameter in SSL request Hello All, I am working on ofbiz forms in XML and ftl. I ran a scan using IBM Appscan tool. I got "Query parameter in SSL request" in various forms in XML and FTL. Kindly guide how can i resolve the issues?

Re: Query Regarding OFBiz Features

2017-06-08 Thread Abhishek Sharma
ve them. We're running such a platform developed on OFBiz. > > Kind Regards, > > Shi Jinghai > > -邮件原件- > 发件人: Abhishek Sharma [mailto:sharma.abhishek2...@gmail.com] > 发送时间: 2017年6月6日 23:12 > 收件人: user@ofbiz.apache.org > 主题: Query Regarding OFBiz Features

Re: Query Regarding OFBiz Features

2017-06-08 Thread Shi Jinghai
user@ofbiz.apache.org 主题: Query Regarding OFBiz Features Hi Team, I have few queries regarding features in OFBiz. It will be great if anyone can help me out in resolving these queries - 1) Do OFBiz support market place like option i.e. anyone can create their store and sell their product on a single

Query Regarding OFBiz Features

2017-06-06 Thread Abhishek Sharma
Hi Team, I have few queries regarding features in OFBiz. It will be great if anyone can help me out in resolving these queries - 1) Do OFBiz support market place like option i.e. anyone can create their store and sell their product on a single OFBiz instance. 2) Can we add product directly in st

RE: Query Regarding OFBiz Features

2017-06-04 Thread Jacques Le Roux
Moderated mail, copied on user ML Hi Abhishek, Your message has been moderated. Please subscribe and use the user ML for questions See how here http://ofbiz.apache.org/mailing-lists.html Thanks Jacques ForwardedMessage.eml Sujet : Query Regarding OFBiz Features De : Abhishek Sharma Date

[Moderated mail] Query Regarding OFBiz Features

2017-06-04 Thread Deepak Dixit
.org Date: Sat, 3 Jun 2017 21:49:42 +0530 Subject: Query Regarding OFBiz Features Hi Team, I have few queries regarding features in OFBiz. It will be great if anyone can help me out in resolving these queries - 1) Do OFBiz support market place like option i.e. anyone can create their store and sell t

Re: FW: write native query in ofbiz

2017-04-02 Thread Jacques Le Roux
Jacques Le 02/04/2017 à 11:19, Ahmad Al ajarmeh a écrit : Thanks you a lot, I want to use native query ; Because there are some special modifications i have it ,then I want to use native query to send direct SQL to database Best Regards, Ahmad Alajarmeh Java Developer P.O.B

Re: query on ofbiz service

2015-08-01 Thread Jacques Le Roux
Hi, Sorry, your description is to vague for me to help you. You should better describe your problem and ask on OFBiz user ML. Just subscribe there http://ofbiz.apache.org/mailing-lists.html and send a more detailed message about your problem . You will get a better support and it's more fair to

Re: BigFish Gift Card Query

2015-01-02 Thread Prateek Ashtikar
essor. BigFish currently has > > > support for Tender Card. We would need to extend BigFish in order to > > offer > > > support for any other Gift Card service. > > > > > > Please visit http://bigfish.solveda.com/bfSpecs.html and go to "Cart > and > > &g

Re: BigFish Gift Card Query

2015-01-02 Thread Divesh Dutta
r any other Gift Card service. > > > > Please visit http://bigfish.solveda.com/bfSpecs.html and go to "Cart and > > Checkout" (section 17) for additional information on Gift Card payments > > using BigFish. > > > > Nick > > > > On 12/30/2014 11:18

Re: BigFish Gift Card Query

2014-12-30 Thread Nick Rosser
a.com/bfSpecs.html and go to "Cart and Checkout" (section 17) for additional information on Gift Card payments using BigFish. Nick On 12/30/2014 11:18 AM, Prateek Ashtikar wrote: Hello, I've query in using "BigFish" and OFBiz for the eCommerce site implementation. But I

Re: BigFish Gift Card Query

2014-12-30 Thread Prateek Ashtikar
tp://bigfish.solveda.com/bfSpecs.html and go to "Cart and > Checkout" (section 17) for additional information on Gift Card payments > using BigFish. > > Nick > > On 12/30/2014 11:18 AM, Prateek Ashtikar wrote: > >> Hello, >> >> I've query in using &qu

Re: BigFish Gift Card Query

2014-12-30 Thread Nick Rosser
://bigfish.solveda.com/bfSpecs.html and go to "Cart and Checkout" (section 17) for additional information on Gift Card payments using BigFish. Nick On 12/30/2014 11:18 AM, Prateek Ashtikar wrote: Hello, I've query in using "BigFish" and OFBiz for the eCommerce site im

BigFish Gift Card Query

2014-12-30 Thread Prateek Ashtikar
Hello, I've query in using "BigFish" and OFBiz for the eCommerce site implementation. But I don't see any information that BigFish do support for the Gift card and its possible functionality like GC purchase, GC balance enquiry, GC reload, GC unload etc.. I can't se

REPLACE in query

2014-01-23 Thread Jad El Omeiri
Hi, Does anyone know how I would be able to do such a query in Ofbiz: / SELECT dbo.tblJobs.JobID, REPLACE(dbo.tblProperties.PostCode, ' ', '') AS PostcodeNoSpaces FROM dbo.tblJobs INNER JOIN dbo.tblProperties ON dbo.tblJobs.PropertyID = dbo.tblProperties.PropertyID WHE

Re: Promotion Query

2012-11-02 Thread Rohit Jain
relevant categories to be included and include its subsets. > 4 - Always exclude will be if parent category is included and this > category is to be excluded. > > > Hope the above helps... > > Dev Panda > > -Rohit Jain wrote: - > To: user@ofbiz.apache.org > From

Re: Promotion Query

2012-11-02 Thread Deb Panda
and include its subsets. 4 - Always exclude will be if parent category is included and this category is to be excluded. Hope the above helps... Dev Panda -Rohit Jain wrote: - To: user@ofbiz.apache.org From: Rohit Jain Date: 11/02/2012 02:55PM Subject: Promotion Query Hello All, we

Re: Query Regarding Populating Dependent Drop-Down For State - Country

2012-06-04 Thread baidehiprasad
Thanks Ankit , your reply really helped me a lot .. Regards:: Baidehi Prasad -- View this message in context: http://ofbiz.135035.n4.nabble.com/Query-Regarding-Populating-Dependent-Drop-Down-For-State-Country-tp4632929p4633161.html Sent from the OFBiz - User mailing

Re: Query Regarding Populating Dependent Drop-Down For State - Country

2012-06-01 Thread Yashwant Dhakad
Hi Baidehi Prasad, You can refer the PartyScreens.xml file in this you see the editcontactmech screen. -- Thanks& Regards, Yashwant Dhakad Enterprise Software Developer HotWax Media Pvt. Ltd. http://www.hotwaxmedia.com On 06/01/2012 05:51 PM, baidehi prasad wrote: Hi , I am newb in O

Re: Query Regarding Populating Dependent Drop-Down For State - Country

2012-06-01 Thread Ankit Jain
Check below link and trace the request. https://demo-trunk.ofbiz.apache.org:8443/ecommerce/control/newcustomer Regards, Ankit Jain On Fri, Jun 1, 2012 at 5:51 PM, baidehi prasad wrote: > Hi , >   I am newb in OFBiz , as i am not able to Populate Dependent Drop-Down > For State - Country  . >

Query regarding raising Purchase Order For Fixed Assets without using Catalog

2012-05-29 Thread baidehi prasad
Hi , I am newb in OFBiz , as i am not able to find the way to raise Purchase Order for Fixed Assets without using Catalog . can any one help me out to find the steps -- *Thank You:: Baidehi Prasad *

Re: Does ofbiz support regular query for mysql database?

2012-02-11 Thread Jacques Le Roux
ine, so that you can define the data model you need, and the database to persist your data is automatically created. OFBiz can use several databases including MySQL, Derby, Postgres, Oracle and Microsoft SQL Server. You use the entity engine rather than directly create a MySQL query. There are se

Re: Does ofbiz support regular query for mysql database?

2012-02-10 Thread Paul Foxworthy
directly create a MySQL query. There are several benefits: your application will continue to work even if you change your mind about which database you want to use, and you can reconfigure your data model and the entity engine will automatically adjust the structure of the database. More on the

generate complicated query using entity engine !

2010-10-20 Thread Prashant Punekar
Hi, Has anyone used "case when" statement using entity engine ? Here is the query which I want to generate using the entity engine . Update velocity_retailer_counter Set total$ = CASE

Re: query ofbi

2010-10-08 Thread Divesh Dutta
Use DynamicViewEntity class for this. For eg: look at OrderLookupServices.java Thanks -- Divesh Dutta. On Oct 8, 2010, at 4:15 PM, Deepa Priolkar wrote: > Hi , > > > > Need some help, want to know how to do sql joins using delegator > methods. > > > > Thanks & Regards, > > Deepa > > >

query ofbi

2010-10-08 Thread Deepa Priolkar
Hi , Need some help, want to know how to do sql joins using delegator methods. Thanks & Regards, Deepa Disclaimer: This message and the information contained here

FW: Query regarding rptdesign file

2010-08-25 Thread KeertiA Sharma
From: KeertiA Sharma Sent: Tuesday, August 24, 2010 4:32 PM To: 'user@ofbiz.apache.org' Subject: Query regarding rptdesign file Hi, I am unable to fetch the complete list of data from entity in rptdesign file.i want to fetch a field which has multiple values in it and use field'

Re: Query regarding rptdesign file

2010-08-24 Thread Ravindra Mandre
Hi, the following example may help, order/webapp/ordermgr/reports/CouponSalesReport.rptdesign based on list you can find out the value of specific field. Regards Ravindra Mandre On Tue, Aug 24, 2010 at 4:32 PM, KeertiA Sharma < keertia.sha...@lntinfotech.com> wrote: > Hi, > I am unable to fet

Query regarding rptdesign file

2010-08-24 Thread KeertiA Sharma
Hi, I am unable to fetch the complete list of data from entity in rptdesign file.i want to fetch a field which has multiple values in it. Kindly help me. Thanks Keerti A Sharna ILabs | L&T Infotech Limited Plot No. EL - 200, TTC Electronic Zone, Shil Mahape Road Vashi, Navi Mumbai 400 710 Phone

Re: Query regarding ofbiz-BIRT integration

2010-08-12 Thread BJ Freeman
If you have reviewed the Birt example in ofbiz that is probably the best there is. https://demo-trunk.ofbiz.apache.org/example/control/Report in the last week there was some discussion about this you might check the mailing list. Swapnil Sawant sent the following on 8/11/2010 10:33 PM: Hi,

RE: Query regarding ofbiz-BIRT integration

2010-08-12 Thread Swapnil Sawant
infotech.com -Original Message- From: Santosh Malviya [mailto:santosh.of...@gmail.com] Sent: Thursday, August 12, 2010 2:04 PM To: user@ofbiz.apache.org Subject: Re: Query regarding ofbiz-BIRT integration Hello Swapnil, If you have formed query in groovy then why are you again doing query in rptd

Re: Query regarding ofbiz-BIRT integration

2010-08-12 Thread Santosh Malviya
Hello Swapnil, If you have formed query in groovy then why are you again doing query in rptdesign file, can you put your open and fetch code here to better understand. -- Thanks and Regards Santosh Malviya On Thu, Aug 12, 2010 at 1:00 PM, Swapnil Sawant < swapnil.saw...@lntinfotech.com>

RE: Query regarding ofbiz-BIRT integration

2010-08-12 Thread Swapnil Sawant
e I should be able to run that report from ofbiz code. What settings / tasks I would have to do on BIRT GUI side to achieve this? Thanks & Regards, Swapnil Sawant -Original Message- From: Santosh Malviya [mailto:santosh.of...@gmail.com] Sent: Thursday, August 12, 2010 12:21

Re: Query regarding ofbiz-BIRT integration

2010-08-11 Thread Santosh Malviya
Hello Swapnil, Instead of writing code in open and fetch method of rptdesign, you can use groovy to fetch data and then just get your data in open from groovy and set into fetch method, and groovy is easy to maintain than rptdesign. -- Thanks and Regards Santosh Malviya On Thu, Aug 12, 2010 at

Query regarding ofbiz-BIRT integration

2010-08-11 Thread Swapnil Sawant
Hi, I am new to report generation in ofbiz using BIRT GUI. For achieving report generation in ofbiz, I follow below steps : 1. Prepare the report using BIRT GUI (designing format of report, assigning entity data to the fields in it) 2. Generate the code out of it . 3. Once

query regarding SECAs

2010-07-19 Thread varun bhansaly
Hi, I am facing issues with attribute "result-map-name" in my SECA definition Listed below is the scenario i am trying to implement Service definitions - SECA definition - The problem - For each invocation of service "CA", same result map "result" remains the same until & unle

query on SECA definition

2010-07-19 Thread varun bhansaly
Hi, I am facing issues with attribute "result-map-name" in my SECA definition Listed below is the scenario i am trying to implement Service definitions - SECA definition - The problem - For each invocation of service "CA", same result map "result" remains the same until & unle

Re: Group By Query

2010-05-16 Thread Atul Vani
, 2010 at 4:01 PM, Atul Vani wrote: hi Kranti, you might wanna use setGroupBy function from DynamicViewEntity.java -- Thanks & Regards Atul Vani Jr. Software Developer HotWax Media Pvt. Ltd. http://www.hotwaxmedia.com/ Kranti Agrawal wrote: Hi, I need to do a query whi

Re: Group By Query

2010-05-14 Thread Kranti Agrawal
p; Regards > Atul Vani > Jr. Software Developer > HotWax Media Pvt. Ltd. > http://www.hotwaxmedia.com/ > > > > Kranti Agrawal wrote: > >> Hi, >> >> I need to do a query which will group by a particular element, >> like i need a count of all the male an

Re: Group By Query

2010-05-14 Thread Atul Vani
hi Kranti, you might wanna use setGroupBy function from DynamicViewEntity.java -- Thanks & Regards Atul Vani Jr. Software Developer HotWax Media Pvt. Ltd. http://www.hotwaxmedia.com/ Kranti Agrawal wrote: Hi, I need to do a query which will group by a particular element, like i need a c

Group By Query

2010-05-14 Thread Kranti Agrawal
Hi, I need to do a query which will group by a particular element, like i need a count of all the male and female customers for my store. How do i do that? Regards, Kranti Agrawal Student, IIIT Bangalore krantiagrawal.blogspot.com

Re: How can i create sql query using delegator?

2010-04-15 Thread Scott Gray
OFBiz doesn't work like this, look for example usage of the EntityCondition class in the codebase. Ultimately you'll need to be doing a "greater than month start and less than month end" type of query. Regards Scott HotWax Media http://www.hotwaxmedia.com On 15/04/2010

Re: How can i create sql query using delegator?

2010-04-15 Thread Anurag Walia
View this message in context: http://n4.nabble.com/How-can-i-create-sql-query-using-delegator-tp1858040p1873104.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: How can i create sql query using delegator?

2010-04-15 Thread Erwan de FERRIERES
Le 15/04/2010 08:51, Anurag Walia a écrit : Hi i have an entity like i want a sql query like this by delegator SELECT * from empl_leave where party_Id=10411 and month(from_date)='4' and year(from_date)='2010'

How can i create sql query using delegator?

2010-04-14 Thread Anurag Walia
Hi i have an entity like i want a sql query like this by delegator SELECT * from empl_leave where party_Id=10411 and month(from_date)='4' and year(from_date)='2010' ;(this is runnig on console) but when i am trying

Re: hi, I am a freshman of ofbiz I want see the query ofbiz produced,but i dnot know how to do that.

2010-04-13 Thread Jacques Le Roux
, edit the debug.properties file in ${OFBizInstallFolder}\framework\base\config and set print.verbose=true. OFBiz produces the following Query: SELECT HotelGuest.FIRST_NAME, HotelGuest.LAST_NAME, Hotel.HOTEL_NAME, HotelOwner.FIRST_NAME, HotelOwner.LAST_NAME FROM (OFBIZ.PERSON_L HotelGuest

hi, I am a freshman of ofbiz I want see the query ofbiz produced,but i dnot know how to do that.

2010-04-13 Thread 于向军
clicking OK. This change will only last the duration of this session. To make the change permanent, edit the debug.properties file in ${OFBizInstallFolder}\framework\base\config and set print.verbose=true. OFBiz produces the following Query: SELECT HotelGuest.FIRST_NAME

Re: given a list of facilityIds can I do a DB query and get a list of corresponding facility entities

2010-04-12 Thread David E Jones
Use the IN operator. -David On Apr 12, 2010, at 2:47 PM, Patrick wrote: > I have a list of facilityIds and I want the entities. I know I could > put it in a for loop and do x number of database queries, but I was > hoping there was a faster way since I know that DB queries are the > bottlene

given a list of facilityIds can I do a DB query and get a list of corresponding facility entities

2010-04-12 Thread Patrick
I have a list of facilityIds and I want the entities. I know I could put it in a for loop and do x number of database queries, but I was hoping there was a faster way since I know that DB queries are the bottleneck. Thanks Patrick

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Hans Bakker
parison between the report file providede in ofbiz and the one I > >> genenrated in RCP designer please go through my previous mail once again > >> and > >> help me to solve the problem > >> > > >> > -Original Message- > >> > From

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Hans Bakker
ng reports that's is why I have shown the > > comparison between the report file providede in ofbiz and the one I > > genenrated in RCP designer please go through my previous mail once again and > > help me to solve the problem > > > > > > -Original Mes

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Michael Xu (xudong)
in RCP designer please go through my previous mail once again and >> help me to solve the problem >> > >> > -----Original Message- >> > From: Hans Bakker [mailto:mailingl...@antwebsystems.com] >> > Sent: Tuesday, January 19, 2010 12:44 PM >&g

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Michael Xu (xudong)
ween the report file providede in ofbiz and the one I > genenrated in RCP designer please go through my previous mail once again and > help me to solve the problem > > > > -Original Message- > > From: Hans Bakker [mailto:mailingl...@antwebsystems.com] > > Sent: Tues

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Michael Xu (xudong)
hi Hans, Thanks. I tried pentaho and found the ad hoc report is really useful. With such a feature, then end user can design report through web UI. -- Regards, Michael Xu (xudong) www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135 9807 | Fax: (8610) 62670096 On Tue, Ja

RE: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Hans Bakker
e to solve > the problem > > -Original Message- > From: Hans Bakker [mailto:mailingl...@antwebsystems.com] > Sent: Tuesday, January 19, 2010 12:44 PM > To: user@ofbiz.apache.org > Subject: Re: Query regarding BIRT report generation in OFBiz > > I can o

RE: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Ashish Tiwari
akker [mailto:mailingl...@antwebsystems.com] Sent: Tuesday, January 19, 2010 12:44 PM To: user@ofbiz.apache.org Subject: Re: Query regarding BIRT report generation in OFBiz I can only advise you to study the existing reports, especially how the data is retrieved with minilanguage. Regards, Hans O

Re: Query regarding BIRT report generation in OFBiz

2010-01-19 Thread Hans Bakker
Probably sure that can be done, however remember that currently the report is prepared outside ofbiz, within eclipse and imported into OFBiz. This means that a simple version of the report preparation function should be duplicated within the ofbiz environment which does not really sound as an easy

Re: Query regarding BIRT report generation in OFBiz

2010-01-18 Thread Michael Xu (xudong)
hi Hans, A quick question. Is it feasible to implement ad hoc report on top of birt in ofbiz? -- Regards, Michael Xu (xudong) www.wizitsoft.com | Office: (8610) 6267 0615 ext 806 | Mobile: (86) 135 0135 9807 | Fax: (8610) 62670096 On Tue, Jan 19, 2010 at 3:14 PM, Hans Bakker wrote: > I can onl

Re: Query regarding BIRT report generation in OFBiz

2010-01-18 Thread Hans Bakker
I can only advise you to study the existing reports, especially how the data is retrieved with minilanguage. Regards, Hans On Tue, 2010-01-19 at 12:28 +0530, Ashish Tiwari wrote: > Hi Hans, > > what I have done so far is: > > 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1

Query regarding BIRT report generation in OFBiz

2010-01-18 Thread Ashish Tiwari
Hi Hans, what I have done so far is: 1. I have generated a .rptdesign file through Birt RCP designer 2_5_1. 2. Now in ofbiz I m trying to display this report file. 3.When I try to display the default .rptdesign file provided in ofbiz i.e. product.rptdesign file it is successfully displayed in of

Re: Conversion of sql query

2010-01-13 Thread Santosh Malviya
Thanks Awdesh, I'll give it a try. Thanks and Regards Santosh Malviya On Wed, Jan 13, 2010 at 6:48 PM, Awdesh Parihar wrote: > Hello Santosh, > See my comment inline. > > On Wed, Jan 13, 2010 at 6:34 PM, Santosh Malviya >wrote: > > > Hi Pradeep, > > I did the same but in my view entity only one

Re: Conversion of sql query

2010-01-13 Thread Awdesh Parihar
Hello Santosh, See my comment inline. On Wed, Jan 13, 2010 at 6:34 PM, Santosh Malviya wrote: > Hi Pradeep, > I did the same but in my view entity only one field for each attrName and > attrValue, while I want two different attrName and attrValue, it may be > because of over writing the fields. >

Re: Conversion of sql query

2010-01-13 Thread Santosh Malviya
> method. > > With regards, > S K Pradeep kumar, > > > > On Wed, Jan 13, 2010 at 6:05 PM, Santosh Malviya >wrote: > > > Hi list, > > > > I have a sql query and I want to do the same with ofbiz entity model. > > > > The query is as follo

Re: Conversion of sql query

2010-01-13 Thread S K Pradeep kumar
Hi Santosh , Create the view entity for all your tables and use delegator.findByCondition method. With regards, S K Pradeep kumar, On Wed, Jan 13, 2010 at 6:05 PM, Santosh Malviya wrote: > Hi list, > > I have a sql query and I want to do the same with ofbiz entity model. > >

Conversion of sql query

2010-01-13 Thread Santosh Malviya
Hi list, I have a sql query and I want to do the same with ofbiz entity model. The query is as follows: select p.* from product_attribute pa1,product_attribute pa2, product p where pa1.attr_name = 'language' and pa1.attr_value ='english' and pa2.attr_name = 'genres'

Re: Query about Cache in groovy

2009-12-11 Thread Jacques Le Roux
[mailto:d...@me.com] Sent: Friday, December 11, 2009 3:53 PM To: user@ofbiz.apache.org Subject: Re: Query about Cache in groovy By default there is a timeout on this cache. -David On Dec 11, 2009, at 4:20 AM, Pankaj Jain wrote: Hi In ofbiz, when we use a groovy file , in ist call to groovy, .g

RE: Query about Cache in groovy

2009-12-11 Thread Pankaj Jain
@ofbiz.apache.org Subject: Re: Query about Cache in groovy By default there is a timeout on this cache. -David On Dec 11, 2009, at 4:20 AM, Pankaj Jain wrote: > Hi > > In ofbiz, when we use a groovy file , in ist call to groovy, .groovy file is > read and parsed and then we store the generate

RE: Query about Cache in groovy

2009-12-11 Thread Pankaj Jain
But it is taking expire time as 0, that means the component in cache will never expire. -Original Message- From: David E Jones [mailto:d...@me.com] Sent: Friday, December 11, 2009 3:53 PM To: user@ofbiz.apache.org Subject: Re: Query about Cache in groovy By default there is a timeout

Re: Query about Cache in groovy

2009-12-11 Thread David E Jones
By default there is a timeout on this cache. -David On Dec 11, 2009, at 4:20 AM, Pankaj Jain wrote: > Hi > > In ofbiz, when we use a groovy file , in ist call to groovy, .groovy file is > read and parsed and then we store the generated class file in a cache and > after that for every next c

Query about Cache in groovy

2009-12-11 Thread Pankaj Jain
Hi In ofbiz, when we use a groovy file , in ist call to groovy, .groovy file is read and parsed and then we store the generated class file in a cache and after that for every next call to groovy, we refer the cache to get the class file. But if we update the .groovy files at run time, the chang

Re: A simple SOAP Query?

2009-11-26 Thread Jacques Le Roux
uld be of greater use for most people, since they can start editing the java files directly without having to be concerned about the implementation at all... -- View this message in context: http://www.nabble.com/A-simple-SOAP-Query--tp22946566p23366335.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: A simple SOAP Query?

2009-11-26 Thread Jacques Le Roux
c Weather Pojo integrated)... I am sure this would be of greater use for most people, since they can start editing the java files directly without having to be concerned about the implementation at all... -- View this message in context: http://www.nabble.com/A-simple-SOAP-Query--tp22946566p2

RE: Query in Load balancing with job scheduling

2009-11-10 Thread Abhai Chaudhary
--Original Message- From: pankaj.j...@lntinfotech.com [mailto:pankaj.j...@lntinfotech.com] Sent: Tuesday, November 10, 2009 2:10 AM To: user@ofbiz.apache.org Subject: Query in Load balancing with job scheduling Hi We have implemented load balancing in ofbiz for that we have used one Apache serv

Query in Load balancing with job scheduling

2009-11-10 Thread Pankaj . Jain
Hi We have implemented load balancing in ofbiz for that we have used one Apache server as load balancer and 2 to 3 OFBiz instances on tomcat server It is working fine. but I want to know how it is going to effect job scheduling in ofbiz ?? As if 3 instances of server are running on same databa

Re: Query Regarding ExecutionContext

2009-09-24 Thread Pankaj . Jain
Thanks Adrian for details. I've already look into the "Discussion : ExecutionContext" thread on dev list but didn't found any roadmap/ overview of ExecutionContext concept, if you can add any small document / page on OFBiz documentation list with objectives and initial information then it wou

Re: Underlying Query for View-entity

2009-09-23 Thread Jacques Le Roux
https://issues.apache.org/jira/browse/OFBIZ-1030 Jacques From: "Yoke Power" Hi Su, I believe the query is not printed even in the Verbose, But if you have a capability to debug, the query is constructed in the org.ofbiz.entity.datasource.GenericDAO class; there are multiple select

Re: Underlying Query for View-entity

2009-09-23 Thread Scott Gray
It is also normally possible to adjust your database settings to have it log all SQL statements. Regards Scott HotWax Media http://www.hotwaxmedia.com On 24/09/2009, at 1:24 PM, Yoke Power wrote: Hi Su, I believe the query is not printed even in the Verbose, But if you have a capability

Re: Query Regarding ExecutionContext

2009-09-23 Thread Yoke Power
Hi Pankaj Would you mind sharing your Multi-tenancy design or approach for the same. We are interested in Multi-tenancy as well. - YOKEPOWER On Wed, Sep 23, 2009 at 10:55 AM, Adrian Crum wrote: > pankaj.j...@lntinfotech.com wrote: > >> 1) Is there any rode map or document link that I can refer

Re: Underlying Query for View-entity

2009-09-23 Thread Yoke Power
Hi Su, I believe the query is not printed even in the Verbose, But if you have a capability to debug, the query is constructed in the org.ofbiz.entity.datasource.GenericDAO class; there are multiple select methods in there where the query is constructed. You could modify the code to add a print

Re: Query Regarding ExecutionContext

2009-09-23 Thread Adrian Crum
pankaj.j...@lntinfotech.com wrote: 1) Is there any rode map or document link that I can refer to know the objectives of ExecutionContext? The documentation is in the dev mailing list. Just search for subject contains ExecutionContext. 2) What is the status of implementation of execution cont

Underlying Query for View-entity

2009-09-23 Thread su2
Hello All, Is it possible to see underlying queries for view-entity? I tried checking checkbox for verbose in Adjust Debugging Level. And tried to see in runtime/log but was not able to see any SQL query there. Am I looking at the right file? Is there any other way? I really appreciate all

Re: Query Regarding ExecutionContext

2009-09-23 Thread Pankaj . Jain
Hi I am looking into execution context code to implement multitenancy in ofbiz. I want to know: 1) Is there any rode map or document link that I can refer to know the objectives of ExecutionContext? 2) What is the status of implementation of execution context in ofbiz? Means how much % it has

Re: A simple SOAP Query?

2009-09-20 Thread Jacques Le Roux
ned about the implementation at all... -- View this message in context: http://www.nabble.com/A-simple-SOAP-Query--tp22946566p25454562.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/A-simple-SOAP-Query--tp2294656

Query regarding custom MRP report generation

2009-09-16 Thread Ponnulakshmi Sivakumar
Hi, We are working on customizing Ofbiz for a make to order system. We have modified the presentation layer to suit our needs. We now need to create a custom MRP report. The MRP report should do the following: - Calculate the consolidated material requirements for all the products ordered in a sa

  1   2   3   >