Ich konnte die Abfrage über den SQL Explorer bauen. Über das Baukastenprinzip habe ich es nicht lösen können. Falls jemand vor dem gleichen Problem steht, hier meine Lösung. Bestimmt ist die Abfrage noch optimierbar.
SELECT
obj_main.isys_obj__id AS '__id__',
j2.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###0_1',
obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1',
j3.isys_catg_accounting_list__inventory_no AS 'LC__CMDB__CATG__ACCOUNTING_INVENTORY_NO###0_38'
FROM isys_obj AS obj_main
INNER JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id
LEFT JOIN isys_obj_type AS j2 ON j2.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id
LEFT JOIN isys_catg_accounting_list AS j3 ON j3.isys_catg_accounting_list__isys_obj__id = obj_main.isys_obj__id
WHERE TRUE
AND (
(j2.isys_obj_type__id != '60' )
AND
(j2.isys_obj_type__id != '63' )
)
AND (
(j2.isys_obj_type__id = '10' )
OR
(j2.isys_obj_type__id = '11' )
OR
(j2.isys_obj_type__id = '22' )
OR
(j2.isys_obj_type__id = '32' )
OR
(j2.isys_obj_type__id = '38' )
OR
(j2.isys_obj_type__id = '96' )
OR
(j2.isys_obj_type__id = '97' )
OR
(j2.isys_obj_type__id = '100' )
OR
(j2.isys_obj_type__id = '101' )
OR
(j2.isys_obj_type__id = '103' )
)
AND (
(j3.isys_catg_accounting_list__inventory_no IS NULL OR j3.isys_catg_accounting_list__inventory_no = '' ) OR
(obj_main.isys_obj__title != j3.isys_catg_accounting_list__inventory_no)
)
AND ( obj_main.isys_obj__status != '6' )
ORDER BY obj_main.isys_obj__title DESC```
