code={prefix="s", type="string"}, version={prefix="s", type="string"}, descr={prefix="s", type="string"}, man={prefix="s", type="string"}, svc_group_id={prefix="sg", type="integer"}, svc_group={prefix="g", type="string"}, resource_realm_cnt={type="integer"} } /> select s.svc_id s.svc s.svc_short s.code (select url from svc_operation so where so.operation='create' AND so.svc_id=s.svc_id limit 1) as create_url s.is_production_ready s.resource_realm_type_id s.sort s.version s.icon_src s.descr s.man to_char(s.dt_created, 'YYYY-MM-DD"T"HH24:MI:SS.FF3TZHTZM') as dt_created to_char(s.dt_updated, 'YYYY-MM-DD"T"HH24:MI:SS.FF3TZHTZM') as dt_updated sg.svc_group_id g.svc_group (coalesce(s.svc,'') ||' '|| coalesce(s.svc_short,'') ||' '|| coalesce(s.synonyms,'')) as svc_extended_name (select count(distinct r.resource_realm) from resource_realm r join resource_realm_access a on ( r.resource_realm_id=a.resource_realm_id AND (a.contract_id IN ( select contract_id from contract d where d.contragent_id=k.contragent_id AND NOT d.is_closed ) OR a.contract_id=0) /*0 means access to any contract*/ AND a.is_enabled) where r.resource_realm_type_id=s.resource_realm_type_id) as resource_realm_cnt from svc s left outer join svc_group_svc sg on (s.svc_id=sg.svc_id AND sg.is_enabled) left outer join svc_group g on (sg.svc_group_id=g.svc_group_id) left outer join contragent k on ( k.external_uid= ) where 1=1 order by g.sort, g.svc_group_id length limit---> > почему-то здесь работает без structCopy