From 96d9e025dfac14f1f6bf71f568bebb8338300c76 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Fri, 21 Oct 2016 17:56:57 +0200 Subject: [PATCH] view_contact --- etc/dbq/owncloud.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/etc/dbq/owncloud.php b/etc/dbq/owncloud.php index b98a6bb3..ce93a28b 100644 --- a/etc/dbq/owncloud.php +++ b/etc/dbq/owncloud.php @@ -14,12 +14,12 @@ $DBQ['owncloud'] = [ #.",name.value as name" #.",tel.value as tel" .",TRIM(CONCAT(" - ."(SELECT value FROM oc_cards_properties p WHERE p.name='ORG' AND p.cardid=c.id AND p.addressbookid=c.addressbookid)" + ."COALESCE((SELECT value FROM oc_cards_properties p WHERE p.name='ORG' AND p.cardid=c.id AND p.addressbookid=c.addressbookid),'')" .",' '," - ."(SELECT value FROM oc_cards_properties p WHERE p.name='FN' AND p.cardid=c.id AND p.addressbookid=c.addressbookid)" + ."COALESCE((SELECT value FROM oc_cards_properties p WHERE p.name='FN' AND p.cardid=c.id AND p.addressbookid=c.addressbookid),'')" .")) as name" - .",(SELECT value FROM oc_cards_properties p WHERE p.name='TEL' AND p.cardid=c.id AND p.addressbookid=c.addressbookid ORDER BY preferred DESC LIMIT 1) as tel" - .",(SELECT value FROM oc_cards_properties p WHERE p.name='EMAIL' AND p.cardid=c.id AND p.addressbookid=c.addressbookid ORDER BY preferred DESC LIMIT 1) as email" + .",COALESCE((SELECT value FROM oc_cards_properties p WHERE p.name='TEL' AND p.cardid=c.id AND p.addressbookid=c.addressbookid ORDER BY preferred DESC LIMIT 1),'') as tel" + .",COALESCE((SELECT value FROM oc_cards_properties p WHERE p.name='EMAIL' AND p.cardid=c.id AND p.addressbookid=c.addressbookid ORDER BY preferred DESC LIMIT 1),'') as email" . " FROM oc_cards c GROUP BY c.id HAVING name IS NOT NULL AND name<>''" , 'row_parse_pre' => 'owncloud_row_parse', -- 2.47.3