%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.Property Inventory
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()
Queries
query AllFiles()
SQL Query:
SELECT NUMBER,NAME FROM %FileMan."File" WHERE NAME IS NOT NULL ORDER BY NUMBER
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
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
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()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %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()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
Storage
Storage Model: CacheSQLStorage
Maps: 1
Map number 1 is named FILEDataMap
thismap.Global: ^DIC
^DIC({NUMBER})
|
= |
|