Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / %SYS namespace / %FileMan.File
Private  Storage   

%FileMan.File


persistent class %FileMan.File extends
%Persistent

This file stores the descriptive information for all files in the FileMan managed database.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 6 3 1


Summary


Properties
%Concurrency DATE FIELDS GLOBALNAME NAME
NUMBER VERSION

Methods
%%OIDGet %1Check %AddJrnObjToSyncSet %AddToSaveSet
%AddToSyncSet %BMEBuilt %BindExport %BuildIndices
%BuildObjectGraph %CheckConstraints %CheckConstraintsForExtent %ClassIsLatestVersion
%ClassName %Close %ComposeOid %ConstructClone
%Delete %DeleteExtent %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %DowngradeConcurrency %ExecuteAfterTriggers
%ExecuteBeforeTriggers %Exists %ExistsId %Extends
%FileIndices %GUID %GUIDSet %GetLock
%GetParameter %GetSwizzleObject %Id %IncrementCount
%IsA %IsModified %IsNull %JournalObject
%KillExtent %LockExtent %LockId %New
%NormalizeObject %ObjectIsNull %ObjectModified %Oid
%OnBeforeAddToSync %OnDetermineClass %Open %OpenId
%OriginalNamespace %PackageName %PurgeIndices %Reload
%RemoveFromSaveSet %ResolveConcurrencyConflict %RollBack %SQLAcquireLock
%SQLAcquireTableLock %SQLAfterTriggers %SQLBeforeTriggers %SQLBuildIndices
%SQLBuildPurgeIndexForRow %SQLBuildPurgeIndices %SQLCheckUnique %SQLCheckUniqueIndices
%SQLCheckUniqueKeys %SQLCopyIcolIntoName %SQLCopyNameIntoIcol %SQLCreateInsDelTables
%SQLDefineiDjVars %SQLDelete %SQLDeleteChildren %SQLDeleteTempStreams
%SQLEExit %SQLExists %SQLFKeyDelLock %SQLFieldValidate
%SQLGetLock %SQLGetOld %SQLGetOldAll %SQLGetOldIndex
%SQLInsert %SQLInsertComputes %SQLInsertStreams %SQLInvalid
%SQLInvalid2 %SQLMVDelete %SQLMVIndexDelete %SQLMVIndexInsert
%SQLMVIndexUpdate %SQLMVInsert %SQLMVUpdate %SQLMissing
%SQLNormalizeCompFields %SQLNormalizeFields %SQLPurgeIndices %SQLQuickBulkInsert
%SQLQuickBulkLoad %SQLQuickBulkSave %SQLQuickBulkUpdate %SQLQuickDelete
%SQLQuickDeleteChildren %SQLQuickFindPKeyByRowID %SQLQuickFindRowIDByPKey %SQLQuickInsert
%SQLQuickLoad %SQLQuickLoadChildren %SQLQuickLogicalToOdbc %SQLQuickOdbcToLogical
%SQLQuickUpdate %SQLReleaseLock %SQLReleaseTableLock %SQLStorageValidation
%SQLTrigDelTab %SQLTrigInsTab %SQLUnlock %SQLUnlock2
%SQLUnlockError %SQLUnlockRef %SQLUpdate %SQLUpdateComputes
%SQLUpdateStreams %SQLValidateCompFields %SQLValidateFields %SQLicompView
%SQLnBuild %Save %SaveDirect %SaveIndices
%SerializeObject %SetModified %SortBegin %SortEnd
%SyncObjectIn %SyncTransport %UnlockExtent %UnlockId
%UpgradeConcurrency %ValidateIndices %ValidateObject


Parameters


• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties


• property DATE as %Library.FilemanDate [ SqlFieldName = DATE ];
FileMan Field Label: 'DATE' FileMan Field Number: '21'
• relationship FIELDS as %FileMan.Field [ Inverse = FILE,Cardinality = children ];
• property GLOBALNAME as %Library.String(COLLATION="EXACT",MAXLEN=255,TRUNCATE=0) [ SqlFieldName = GLOBAL_NAME,Transient ];
FileMan Field Label: 'GLOBAL NAME' FileMan Field Number: '1'
• property NAME as %Library.String(COLLATION="EXACT",MAXLEN=45,MINLEN=3,TRUNCATE=0) [ SqlFieldName = NAME ];
FileMan Field Label: 'NAME' FileMan Field Number: '.01'
• property NUMBER as %Library.String(COLLATION="EXACT",TRUNCATE=0);
FileMan Field Label: 'NUMBER' FileMan Field Number: '.001'
• property VERSION as %Library.String(COLLATION="EXACT",MAXLEN=255,TRUNCATE=0) [ SqlFieldName = VERSION,Transient ];
FileMan Field Label: 'VERSION' FileMan Field Number: '51'

Queries


• query AllFiles()
SQL Query :
SELECT NUMBER,NAME FROM %FileMan."File"
WHERE NAME IS NOT NULL
ORDER BY NUMBER
• query AllFilesByName()
SQL Query :
SELECT NUMBER,NAME FROM %FileMan."File"
WHERE NAME IS NOT NULL
ORDER BY NAME
• query ListFilesByName(file As %Library.String)
SQL Query :
SELECT NUMBER,NAME FROM %FileMan."File"
WHERE "NAME" %STARTSWITH :file
ORDER BY NAME

Indices


• index (IDKeyIndex on NUMBER) [IdKey,PrimaryKey,Unique];