I am guessing your are more interested in the sql and mysql. I think you will get better support in this if you go to mysql support. I personally use postgresql, so I am not much help on mysql. :D
BJ Freeman sent the following on 6/2/2009 4:45 AM: > I am sorry I am lost > are you talking about the output of ofbiz from ofbiz data layer to mysql > or just sql. > > you solutions is sql only I did not see a entity related one. > > > lns_lns sent the following on 6/2/2009 4:35 AM: >> Hi BJ, >> i know how to order and group an resutlset... >> however i need to order before grouping, that's not the way mysql supports >> it... >> wich is why there's the workaround i posted, so my real problem is not >> ordering but nesting two querys >> if you test the query i wrote and compare it with the result of the "normal" >> qeury (order and group in the same select statement) you will see the >> difference, since mysql first groups and the orders... >> so, you got some tip on how to accomplish the effect? >> thanks! >> >> BJ Freeman wrote: >>> Entities, as well as View entities define data storage and relationship >>> to other entities. >>> the findby and orderby are methods/attributes taken on the entity. >>> >>> do a search of the code for orderby or groupby >>> you will get a lot of examples. >>> >>> >>> lns_lns sent the following on 6/1/2009 5:09 AM: >>>> Hi, >>>> I have to select some columns from a table they have to be, first >>>> ordered, >>>> then grouped. >>>> in SQL it looks like this: >>>> >>>> SELECT s2, s1, s3 FROM >>>> (SELECT SOMETABLE.SOMETHING2 AS s2, SOMETABLE.SOMETHING1 AS s1, >>>> SOMETABLE.SOMETHING3 AS s3 >>>> FROM SOMETABLE ORDER BY SOMETHING1,SOMETHING2) b >>>> WHERE s1='something' >>>> GROUP BY s1 >>>> >>>> When queried directly to the MYSQL server this works perfectly, but now i >>>> have to implement it in ofbiz, bsh.. >>>> First I wanted to create two "view-entity"s but I couldn't find anything >>>> about order-by in the alias tag. >>>> Is there a way to add an ORDER BY clause in the <alias>? >>>> If not, is there another way to get this query ported to ofbiz? >>>> >>>> Thanks in advance! >>>> Regards >>>> Lukas >>> -- >>> 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. >>> >>> >>> > -- 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.
