Postgresql, contacts and extra fields: order by error

When an extra field exists and the search based on the field was made, then there was an error.

Patch:
*** class.addressbook_ui.inc.php 2010-05-12 13:35:52.976112187 +0200
— orig 2010-05-12 13:36:30.996529192 +0200


*** 909,915 ****
switch($query[‘order’]) // “xxx<>’’ DESC” sorts contacts with empty order-criteria always at the end
{ // we don’t exclude them, as the total would otherwise depend on the order-criteri
case ‘org_name’:
! $order = "egw_addressbook.org_name<>’’ DESC,egw_addressbook.org_name $sort,n_family $sort,n_given $sor
break;
default:
if ($query[‘order’][0] == ‘#’) // we order by a custom field
— 909,915 ----
switch($query[‘order’]) // “xxx<>’’ DESC” sorts contacts with empty order-criteria always at the end
{ // we don’t exclude them, as the total would otherwise depend on the order-criteri
case ‘org_name’:
! $order = “org_name<>’’ DESC,org_name $sort,n_family $sort,n_given $sort”;
break;
default:
if ($query[‘order’][0] == ‘#’) // we order by a custom field

When an extra field exists and the search based on the field was made, then
there was an error.
…
! $order = "egw_addressbook.org_name<>’'
DESC,egw_addressbook.org_name $sort,n_family $sort,n_given $sor

Thanks. Committed r30129.
Nathan



eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers