persistent class %FileMan.File
extends %Persistent
This file stores the descriptive information for all files in the FileMan managed database.
• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted.
Tables are projected to SQL as READONLY.
• 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,Required ];
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'
• query AllFiles()
SQL Query
:
SELECT NUMBER,NAME FROM "File"
ORDER BY NUMBER
• query AllFilesByName()
SQL Query
:
SELECT NUMBER,NAME FROM "File"
ORDER BY NAME
• query ListFilesByName(file As %Library.String)
SQL Query
:
SELECT NUMBER,NAME FROM "File"
WHERE "NAME" %STARTSWITH :file
ORDER BY NAME
• index (IDKeyIndex on NUMBER) [IdKey,PrimaryKey,Unique];
