2.18. Pohled "UNI_PROPSET_VW"
| název sloupce | Typ | výchozí | upravitelný |
|---|
| RADDR | NUMBER ( 22 ) | | Ne |
| TP | CHAR ( 1 ) | | Ne |
| PARENT_TP | CHAR ( 1 ) | | Ne |
| ID | NUMBER ( 22 ) | | Ne |
| PARENT_ID | NUMBER ( 22 ) | | Ne |
| VISIBLE | VARCHAR2 ( 20 ) | | Ne |
| CLASSTYPE | VARCHAR2 ( 0 ) | | Ne |
| OBJLVL | NUMBER ( 22 ) | | Ne |
| OBJTYPE | CHAR ( 14 ) | | Ne |
| NAME | VARCHAR2 ( 400 ) | | Ne |
| DEF | VARCHAR2 ( 4000 ) | | Ne |
| DEF50 | VARCHAR2 ( 4000 ) | | Ne |
| DEF100 | VARCHAR2 ( 4000 ) | | Ne |
| IFCIDENT | VARCHAR2 ( 0 ) | | Ne |
| DATAUNIT | VARCHAR2 ( 0 ) | | Ne |
| DATATYPESPEC | VARCHAR2 ( 0 ) | | Ne |
| DATATYPE | VARCHAR2 ( 0 ) | | Ne |
| IFCTYPE | VARCHAR2 ( 0 ) | | Ne |
| LINK_URL | VARCHAR2 ( 0 ) | | Ne |
select
10*S.ID+5 Raddr, -- 5 ~ S ... property Set
'S' Tp,
'C' Parent_Tp,
S.ID,
X.Class_ID Parent_ID,
S.Visible,
null ClassType,
--
5 ObjLvl,
'Skupina vlast.' ObjType,
--
coalesce(S.Name_CZ,S.Name) Name,
coalesce(S.Definition_CZ,S.Definition) Def,
case when length(coalesce(S.Definition_CZ,S.Definition))>50 then rtrim(substr(coalesce(S.Definition_CZ,S.Definition),1,47))||'...' else coalesce(S.Definition_CZ,S.Definition) end Def50,
case when length(coalesce(S.Definition_CZ,S.Definition))>100 then rtrim(substr(coalesce(S.Definition_CZ,S.Definition),1,97))||'...' else coalesce(S.Definition_CZ,S.Definition) end Def100,
-- class
null IfcIdent,
--null Repres,
--null IfcRepres,
--null Prec,
--null PrecV,
--null Precision,
-- property
null DataUnit,
null DataTypeSpec,
null DataType,
null IfcType,
--null EnumValues,
null Link_URL
from
X_Property_Set_Class X,
IFC_Property_Set S
where S.Visible is not null
and X.Property_Set_ID(+)=S.ID
