Topics created by pdcict

Hello Henk,

you'll need to query "isys_catg_relation_list" (this is the "relation" category) and inside that table you'll need to select the rows where the field "isys_catg_relation_list__isys_relation_type__id" reference to the isys_relation_type rows with the types "C__RELATION_TYPE__USER" or "C__RELATION_TYPE__ADMIN".

It should look something like this:

SELECT * FROM isys_obj AS obj_main LEFT JOIN isys_catg_relation_list AS j4 ON j4.isys_catg_relation_list__isys_obj__id = obj_main.isys_obj__id LEFT JOIN isys_relation_type AS jn3 ON jn3.isys_relation_type__id = j4.isys_catg_relation_list__isys_relation_type__id WHERE jn3.isys_relation_type__const = 'C__RELATION_TYPE__ADMIN' OR jn3.isys_relation_type__const = 'C__RELATION_TYPE__USER';

Greetings,
Leo