Home > Class Reference > ENSLIB namespace > %FileMan.File

%FileMan.File

persistent class %FileMan.File extends %Library.Persistent

SQL Table Name: %FileMan.File

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

Parameters

parameter READONLY = 1;
Inherited description: 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;
FileMan Field Label: 'DATE' FileMan Field Number: '21'
Property methods: DATEDateToLogical(), DATEDisplayToLogical(), DATEGet(), DATEIsValid(), DATELogicalToDate(), DATELogicalToDisplay(), DATELogicalToOdbc(), DATEOdbcToLogical(), DATESet(), DATETimeStampToLogical()
relationship FIELDS as array of %FileMan.Field [ InitialExpression = $listbuild("%FileMan.Field","FILE",+$this,"children",1,1) , Transient , Inverse = FILE , Cardinality = children ];
Property methods: FIELDSGet(), FIELDSGetObject(), FIELDSGetObjectId(), FIELDSGetSwizzled(), FIELDSIsEmpty(), FIELDSIsValid(), FIELDSNewObject(), FIELDSRClose(), FIELDSRExec(), FIELDSRFetch(), FIELDSRelate(), FIELDSSQLCompute(), FIELDSSet(), FIELDSUnRelate()
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 methods: GLOBALNAMECompute(), GLOBALNAMEDisplayToLogical(), GLOBALNAMEGet(), GLOBALNAMEIsValid(), GLOBALNAMELogicalToDisplay(), GLOBALNAMELogicalToOdbc(), GLOBALNAMENormalize(), GLOBALNAMESQLCompute(), GLOBALNAMESet(), GLOBALNAMESetT()
property NAME as %Library.String (COLLATION = "EXACT", MAXLEN = 45, MINLEN = 3, TRUNCATE = 0);
FileMan Field Label: 'NAME' FileMan Field Number: '.01'
Property methods: NAMEDisplayToLogical(), NAMEGet(), NAMEIsValid(), NAMELogicalToDisplay(), NAMELogicalToOdbc(), NAMENormalize(), NAMESet()
property NUMBER as %Library.String (COLLATION = "EXACT", TRUNCATE = 0) [ Required ];
FileMan Field Label: 'NUMBER' FileMan Field Number: '.001'
Property methods: NUMBERDisplayToLogical(), NUMBERGet(), NUMBERIsValid(), NUMBERLogicalToDisplay(), NUMBERLogicalToOdbc(), NUMBERNormalize(), NUMBERSet()
property VERSION as %Library.String (COLLATION = "EXACT", MAXLEN = 255, TRUNCATE = 0) [ Transient ];
FileMan Field Label: 'VERSION' FileMan Field Number: '51'
Property methods: VERSIONCompute(), VERSIONDisplayToLogical(), VERSIONGet(), VERSIONIsValid(), VERSIONLogicalToDisplay(), VERSIONLogicalToOdbc(), VERSIONNormalize(), VERSIONSQLCompute(), VERSIONSet(), VERSIONSetT()

Inherited Methods

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

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

Indexes

index (IDKeyIndex on NUMBER) [IdKey, PrimaryKey, Type = key, Unique];
Index methods: IDKeyIndexCheck(), IDKeyIndexDelete(), IDKeyIndexExists(), IDKeyIndexOpen(), IDKeyIndexSQLCheckUnique(), IDKeyIndexSQLExists(), IDKeyIndexSQLFindPKeyByConstraint(), IDKeyIndexSQLFindRowIDByConstraint()

Storage