How can i create sql query using delegator?

Hi i have an entity like entity entity-name=EmplLeave package-name=org.ofbiz.humanres.employmenttitle=Employee Leave Entity field name=partyId type=id-ne/ field name=fromDate type=date-time/ field name=thruDate type=date-time/ prim-key field=partyId/

Re: Ofbiz demo product elimination

Thanks Anurag but what delegator name should i use as the delegator is provide in EntityDataLoadContainer.java. Do i need to write my own delegator -- View this message in context: http://n4.nabble.com/Ofbiz-demo-product-elimination-tp1836946p1862062.html Sent from the OFBiz

RE: Ofbiz demo product elimination

Thanks for ur valuable reply. entity-name=EmplLeave this is new entity created in default database Regards Anurag Walia Date: Wed, 14 Apr 2010 23:32:37 -0800 From: ml-node+1862062-1236036246-227...@n4.nabble.com To: walia.anu...@hotmail.com Subject: Re: Ofbiz demo product elimination

Re: How can i create sql query using delegator?

Le 15/04/2010 08:51, Anurag Walia a écrit : Hi i have an entity like entity entity-name=EmplLeave package-name=org.ofbiz.humanres.employmenttitle=Employee Leave Entity field name=partyId type=id-ne/ field name=fromDate type=date-time/ field name=thruDate

Re: How can i create sql query using delegator?

Thanks for valuable reply but unable to find is coming fromDate because it should change into from_Date by entitymodel delegator.findByAndCache(EmplLeave, UtilMisc.toMap(month(fromDate), submitmonth,year(fromDate),submityear), null); Regards Anurag -- View this message in context:

Re: How can i create sql query using delegator?

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, at 9:29 PM, Anurag

Re: Multitenancy support

If we want non-demo instructions then we'd need to describe how to create some ext data with the tenant info and then change the first install command to do a readers=seed,ext. Regards Scott On 15/04/2010, at 3:22 AM, Adrian Crum wrote: That Wiki page is a work in progress - so there is some

on-event-update-area and parameters

Hi all, I'm looking to retrieve parameters when using on-event-update-area in a form and the event-type submit. As an example, when using the example ajax (https://localhost:8443/example/control/authview/findExampleAjax), I'd like when submitting a new example, to have it back in my edition

Re: Multitenancy support

That would be very helpful! -Adrian --- On Thu, 4/15/10, Scott Gray scott.g...@hotwaxmedia.com wrote: From: Scott Gray scott.g...@hotwaxmedia.com Subject: Re: Multitenancy support To: user@ofbiz.apache.org Date: Thursday, April 15, 2010, 3:06 AM If we want non-demo instructions then we'd

Session Invalidate !

Hi All, I am facing a strange issue with session in my OFBiz app. In one flow, to go from screen A to screen B user needs authorization. Screen A is having one session which contains a cart some cart items in it. When an anonymous user tries to go from screen A to screen B application asks

Re: Using custom delegator in simple method

Thanks both of the suggested solutions will work for me. I think I'll try the shorter call-class-method for now. Brett On Wed, Apr 14, 2010 at 10:35 PM, Scott Gray scott.g...@hotwaxmedia.comwrote: You might be better off doing a call-class-method for DelegatorFactory.getDelegator(String)

not allowed to edit amount field in entity OrderAdjustment using webtools

I am not allowed to edit the amount field in the OrderAdjustment entity using webtools (ofbiz 9.04). Is this a bug or is there a reason for it?

Re: not allowed to edit amount field in entity OrderAdjustment using webtools

I am guessing that amounts are not accessible because they would mess up the BI data. This is a good features to keep audits honest. = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation

Error while running Cobertura tests in framework/base

I downloaded the latest Cobertura jar and dropped it in framework/base/lib. I tried to run the tests-cobertura ant task and I got an error message: classes: [javac16] Compiling 2 source files to C:\ofbiz\framework\base\build\classes [javac16]

tracing OrderAdjustment trying to figure out how it works

Everytime I create an OrderHeader, it is somehow automatically associated with the only OrderAdjustment row in my DB. OrderReadHelper.java orderheader.getRelated(OrderAdjustment); //always returns the OrderAdjustment row, why? Also, when I create a new OrderAdjustment using webtools I can't

Re: not allowed to edit amount field in entity OrderAdjustment using webtools

I guessing that you're guessing wrong, it's most likely a bug in webtools. That said, it wouldn't be a great idea to try and modify that sort of data in webtools. Regards Scott HotWax Media http://www.hotwaxmedia.com On 16/04/2010, at 4:58 AM, BJ Freeman wrote: I am guessing that amounts

Re: tracing OrderAdjustment trying to figure out how it works

You may need to restate the question, it doesn't really make sense to me. Regards Scott HotWax Media http://www.hotwaxmedia.com On 16/04/2010, at 7:07 AM, Patrick wrote: Everytime I create an OrderHeader, it is somehow automatically associated with the only OrderAdjustment row in my DB.

Re: tracing OrderAdjustment trying to figure out how it works

this helps in tracing. https://demo-stable.ofbiz.apache.org/webtools/control/ArtifactInfo put in OrderAdjustment You will see what is returned with getrelated take a look at createOrderAdjustment

OSGi based OFBiz framework

Hi, I have been working on OSGi and OFBiz integration for a while. I could successfully, run the OFBiz framework (entity engine and service engine) as OSGi services. With this integration it is possible to run Framework only OFBiz and use the OFBiz service engine for non form widget

Multi-lingual suport for FOP in OFBIZ 9.04?

Hello, I tried to generate PDF files in OFBIZ 9.04 using FOP. The Chinese characters appear as ### in the PDF file. Any one can advise? Thanks! -- View this message in context: http://n4.nabble.com/Multi-lingual-suport-for-FOP-in-OFBIZ-9-04-tp1934541p1934541.html Sent from the OFBiz - User

Re: Multi-lingual suport for FOP in OFBIZ 9.04?

Search the mailing list for FOP fonts -Adrian --- On Thu, 4/15/10, Koon Sang koon-sang_kh...@igine.com wrote: From: Koon Sang koon-sang_kh...@igine.com Subject: Multi-lingual suport for FOP in OFBIZ 9.04? To: user@ofbiz.apache.org Date: Thursday, April 15, 2010, 7:38 PM Hello, I tried

Re: Multitenancy support

I am still going through the code trying to figure out how ext for different tenants can be loaded, that is unique to that tenant. one example is loading the productstore with the defaults and the theme that has been created for that tenant. or how to configure the emails of a productstore for

Re: Multi-lingual suport for FOP in OFBIZ 9.04?

Hello Koon, Please refer following mail with subject: Simplified Chinese characters are displayed as square boxes in POS and simplified chinese problem, also go for page http://cwiki.apache.org/confluence/x/9ABk . you will get solution for your problem. Thanks Regards Brajesh Patel Koon

Postgre SQL

Hi, I am new to Ofbiz how can i Integrate Postgre SQl in Ofbiz , Can anyone give me suggestion to Integrate Ofbiz with Postgre SQL Thanks in Advance -- Regards, Prabhakaran.D +91 99 520 93 900

Re: Postgre SQL

On the home page of ofbiz.apache.org is a link to documentation. find the Apache OFBiz Technical Production Setup Guide look under Database Setup = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation

Re: Postgre SQL

also not covered in the doc is ant download-PG-JDBC = BJ Freeman http://bjfreeman.elance.com Strategic Power Office with Supplier Automation http://www.businessesnetwork.com/automation/viewforum.php?f=93 Specialtymarket.com http://www.specialtymarket.com/ Systems