persistent class %BI.WPivotTable
extends %Persistent
property ColQuery
as array of %String(MAXLEN=10000,TRUNCATE=1);
property Filters
as array of %String(MAXLEN=10000,TRUNCATE=1);
property FixedCol
as %String(MAXLEN=100,TRUNCATE=1);
property FixedRow
as %String(MAXLEN=100,TRUNCATE=1);
property Folder
as %String(TRUNCATE=1);
property PivotName
as %String(MAXLEN=300,TRUNCATE=1) [ Required ];
property PivotNotes
as %String(MAXLEN=32000,TRUNCATE=0);
property PostLoadSkrip
as %String(MAXLEN=10000,TRUNCATE=1);
property PreLoadSkrip
as %String(MAXLEN=10000,TRUNCATE=1);
property RowCell
as array of %String(MAXLEN=10000,TRUNCATE=1);
property RowQuery
as array of %String(MAXLEN=10000,TRUNCATE=1);
query ListAll()
SQL Query
:
SELECT ID,PivotName,PivotNotes,Folder
FROM %BI.WPivotTable ORDER BY PivotName
index (Folder on Folder:Exact);