Pohledy - UNI_SEZNAM_VW
	Tabulky - IFC_CLASS

select
    10*C.ID+case ClassType when 'C' then 2 when 'S' then 3 when 'E' then 4 else 1 end Raddr, -- 1-4 ~ C ... class/caststavby/skupelementu/element
    'C' Tp,
    'C' Parent_Tp,
    C.ID,
    C.Parent_ID,
    C.Visible,
    C.ClassType,
    --
    case C.ClassType
      when 'C' then 2 -- cast stavby
      when 'S' then 3 -- skupina elementu
      when 'E' then 4 -- element
      else 1          -- trida
      end ObjLvl,
    case C.ClassType
      when 'C' then 'Část stavby'
      when 'S' then 'Skupina elem.'
      when 'E' then 'Element'
      else 'Třída'
      end ObjType,
    --
    coalesce(C.Name_CZ,C.Name) Name,
    coalesce(C.Definition_CZ,C.Definition) Def,
    case when length(coalesce(C.Definition_CZ,C.Definition))>50 then rtrim(substr(coalesce(C.Definition_CZ,C.Definition),1,47))||'...' else coalesce(C.Definition_CZ,C.Definition) end Def50,
    case when length(coalesce(C.Definition_CZ,C.Definition))>100 then rtrim(substr(coalesce(C.Definition_CZ,C.Definition),1,97))||'...' else coalesce(C.Definition_CZ,C.Definition) end Def100,
    -- class
    C.IfcIdent,
  --C.Repres,
  --C.IfcRepres,
  --C.Prec,
  --C.PrecV,
  --C.Prec||case when C.PrecV is not null and C.PrecV<>C.Prec then '/'||C.PrecV end Precision, -- P2/P3, pokud se presnosti lisi
    -- property
    null DataUnit,
    null DataTypeSpec,
    null DataType,
    null IfcType,
  --null EnumValues,
    null Link_URL
  from
    IFC_Class C
  where C.Visible is not null