Class Reference
Cache for UNIX 2018.1.3
InterSystems: The power behind what matters   
Documentation  Search
Private  Storage  

persistent class %BI.WPivotTable extends %Persistent

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
11 1 1


Summary

Properties
ColQuery Filters FixedCol FixedRow Folder
PivotName PivotNotes PostLoadSkrip PreLoadSkrip RowCell
RowQuery

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %ClassIsLatestVersion %ClassName %ComposeOid
%ConstructClone %Delete %DeleteExtent %DeleteId
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %Exists
%ExistsId %Extends %GUID %GUIDSet
%GetLock %GetParameter %GetSwizzleObject %Id
%InsertBatch %IsA %IsModified %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PhysicalAddress %PurgeIndices %Reload %RemoveFromSaveSet
%ResolveConcurrencyConflict %RollBack %Save %SaveDirect
%SaveIndices %SerializeObject %SetModified %SortBegin
%SortEnd %SyncObjectIn %SyncTransport %UnlockExtent
%UnlockId %ValidateIndices %ValidateObject


Properties

• 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);

Queries

• query ListAll()
SQL Query :
SELECT ID,PivotName,PivotNotes,Folder
FROM %BI.WPivotTable ORDER BY PivotName

Indices

• index (Folder on Folder:Exact);


Copyright © 1997-2020, InterSystems Corporation