Tabulky - IFC_PROPERTY_SET - X_PROPERTY_SET_CLASS - X_PROPERTY_SET_PROPERTY

select
    10*S.ID+5 Raddr, -- 5 ~ S ... property Set
    S.ID,
    --
    S.Kdo,
    S.Kdy,
    To_Char(S.Kdy,'dd.mm.yyyy') Kdy_DMR,
    To_Char(S.Kdy,'dd.mm.yyyy hh24:mi') Kdy_DMRHM,
    --
    S.visible,
    case when S.Visible like '%I%' then 'Y' else 'N' end is_I,
    case when S.Visible like '%P%' then 'Y' else 'N' end is_P,
    case when S.Visible like '%S%' then 'Y' else 'N' end is_S,
    case when S.Visible like '%Z%' then 'Y' else 'N' end is_Z,
    --
    S.ifdGuid,
    S.Name,
    S.Name_CZ,
    S.Definition,
    case when length(S.Definition)>50 then rtrim(substr(S.Definition,1,47))||'...' else S.Definition end Def50,
    case when length(S.Definition)>100 then rtrim(substr(S.Definition,1,97))||'...' else S.Definition end Def100,
    S.Definition_CZ,
    case when length(S.Definition_CZ)>50 then rtrim(substr(S.Definition_CZ,1,47))||'...' else S.Definition_CZ end Def50_CZ,
    case when length(S.Definition_CZ)>100 then rtrim(substr(S.Definition_CZ,1,97))||'...' else S.Definition_CZ end Def100_CZ,
    ( select
          count(*)
        from
          X_Property_Set_Class X
        where X.Property_Set_ID=S.ID
    ) ClassNr,
    ( select
          count(*)
        from
          X_Property_Set_Property X
        where X.Property_Set_ID=S.ID
    ) PropertyNr
  from
    IFC_Property_Set S