you can create the entity by using https://localhost:8443/webtools/control/view/ModelInduceFromDb once you clean them up you can use the entities created with java or minilang to do CRUD services. ofbiz will even create the CRUD services for you. http://www.nabble.com/The-fancy-new-entity-auto-service-execution-engine-td18674040.html
you can use the mini lang to find records then update them. http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginners+Development+Guide+Using+Practice+Application+%28Hello+World...%29 look at part 3. the applications\party\script\org\ofbiz\party\party\PartySimpleMethods.xml can give you ideas. you can also https://localhost:8443/webtools/control/EntitySQLProcessor look at the framework\webtools\webapp\webtools\WEB-INF\actions\entity\EntitySQLProcessor.groovy Vikas Jadhav sent the following on 5/20/2009 11:47 PM: > Hi, > > I am using GenericDelegator to to retrieve or store data from the tables. > > But I am facing some problems to update some records using delegators. > > e.g. I have a table as below. > EMP (empId primary key, name, age, salary, dept foreign key) > > Here I want to update the salary of all the employees who belongs to > specific department. > e.g. > UPDATE EMP set salary=salary * 10 where dept='QA'; > > So, how to put this in ofbiz delegator. > How to set fields to update in query. > > especially.. how to put salary=salary*10 in fieldsToUpdate map? > > Thanks, > Vikas > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
