Login  Register

SQL problem postgresql

Posted by BJ Freeman on Oct 09, 2007; 1:36pm
URL: http://ofbiz.116.s1.nabble.com/SQL-problem-postgresql-tp184292.html

Ok track down the problem with profileview
Some thing changed in the SQL portion that
changes the way the SQL is generate for the database.
It might be
svn commit: r575396 - in /ofbiz/trunk/framework: entity/ entity/config/
entity/dtd/ entity/src/org/ofbiz/entity/config/
entity/src/org/ofbiz/entity/connection/
entity/src/org/ofbiz/entity/jdbc/
entity/src/org/ofbiz/entity/transaction/ geronimo/src/org/...

findByAnd ( "PartyNoteView" , UtilMisc .toMap ( "targetPartyId" ,
partyId ) , UtilMisc .toList ( "-noteDateTime" ) )
.toMap ( "targetPartyId" , partyId ) in the bsh gets changed to
PN.PARTY_ID AS TARGET_PARTY_ID
for the DB