On this page
AX1076
Axiom.FileSystemInfo
The Axiom.FileSystemInfo system table contains information about the files stored in the Axiom file system.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
ID |
The ID of the folder or file. |
|
Name |
The name of the folder or file (including the file extension). |
|
ItemType |
The type of item. Return values are as follows:
|
|
FolderID |
The ID of the folder where this item is located. For folders, the ID of the immediate parent folder is listed. |
|
FullPath |
The full path of the folder or file. Includes the file name if the item is a file. |
|
FolderPath |
The folder path of the folder or file. Excludes the current file or folder name. |
|
FileGroupID |
The ID of the file group that the folder or file belongs to. Returns blank if the folder or file is not part of a file group. |
|
Description |
The description text for the folder or file. |
|
IsFormsEnabled |
Whether the file is form-enabled (True/False). Returns False for all folders. |
|
LockedByUser |
The login name of the user who currently has the file lock. Returns blank if the file is not locked, or if the item is a folder. |
|
RecordCreatedBy |
The login name of the user who created the file or folder. |
|
RecordCreatedDTM |
The date and time the file or folder was created. |
|
RecordModifiedBy |
The login name of the user who last modified the file or folder. |
|
RecordModifiedDTM |
The date and time the file or folder was last modified. |
Remarks
- Queries to this table are automatically filtered to show only those folders and files that the current user has rights to see.
- The GetData function cannot be used to query this table. The GetDocumentInfo function may be used as a substitute for certain pieces of information about the current file.
Save Type 4 support
Axiom.FileSystemInfo cannot be modified using Save Type 4.
|
Get more information and training resources: www.kaufmanhall.com |
Was this topic helpful? axiom_filesysteminfo.htm |
