z.B. Nextcloud Kontakte
 
SQL:
----
create view  ocl_card_app.ocl_card_raw  as
SELECT distinct
	cprop.cardid  							as cardid_adressid, 
	max( cprop.value ) filter (where name = 'FN')  			as FN_adressnr,
	max( cprop.value ) filter (where name = 'ORG')  		as ORG_name1,
	--
	max( cprop.value ) filter (where name = 'CATEGORIES')  			    as CATEGORIES,
	split_part( min( cprop.value ) filter (where name = 'CATEGORIES'), ',', 1)  as CATEGORIES_adr_knz,  -- z.B. I,K
	--
	max( cprop.value ) filter (where name = 'EMAIL') as EMAIL_email1,
	max( cprop.value ) filter (where name = 'TEL')   as TEL_telefon,
	--
	max( cprop.value ) filter (where name = 'ADR')  		     as ADR,
	split_part( max( cprop.value ) filter (where name = 'ADR'), ';', 3)  as ADR_strasse,  -- z.B. ADR	;;R-Platz 34;Wien;;1013;
	split_part( max( cprop.value ) filter (where name = 'ADR'), ';', 6)  as ADR_plz,
	split_part( max( cprop.value ) filter (where name = 'ADR'), ';', 4)  as ADR_ort,
	--
	split_part( max( cprop.value ) filter (where name = 'ADR'), ';', 7)  as ADR_land
--
FROM 
	      oc_cards			      c
	join  oc_cards_properties  cprop  on  c.id = cprop.cardid
group by
    cprop.cardid
order by 
	1
;





	Wenn der Innendienst keine Zeit für Erfassungen aufwenden will jedoch per Desktop Angebote und Abrechnung erledigt. z.B. - Nextcloud Kontakte -> Interessenten - Nextcloud Tabellen -> Anfragepositionen


	...
	...