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