Skip to main content

%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
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()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheSQLStorage

Maps: 1

  • Map number 1 is named FILEDataMap

    thismap.Global: ^DIC

  • ^DIC({NUMBER})
    =
    Node Delimiter Piece Name
    0 "^" 1 NAME
    "%A" "^" 2 DATE
FeedbackOpens in a new tab