Hello Thomas,
that's easy, here is a query for all objects with a primary contact:
SELECT
j1.isys_obj__title AS 'object',
j2.isys_obj__title AS 'primary contact'
FROM isys_obj AS j1
LEFT JOIN isys_catg_contact_list
ON isys_catg_contact_list__isys_obj__id = j1.isys_obj__id
LEFT JOIN isys_connection
ON isys_connection__id = isys_catg_contact_list__isys_connection__id
LEFT JOIN isys_obj AS j2
ON j2.isys_obj__id = isys_connection__isys_obj__id
WHERE TRUE
AND isys_catg_contact_list__primary_contact = 1
Maybe you want to add something like this (only all server):
AND j1.isys_obj__isys_obj_type__id = 5
Regards,
jkondek
