AX1076

Axiom.FileSystemInfo

The Axiom.FileSystemInfo system table contains information about the files stored in the Axiom file system.

IMPORTANT: Queries to this table can be very resource-intensive, depending on factors such as the number of files in the system and user permissions to those files. Consider other alternatives to obtain file information and only query this table if absolutely necessary.

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:

  • CalculationMethodLibrary
  • DataDiagramXML
  • DataExplorerXML
  • Driver
  • ExportPackageXML
  • Folder
  • ImportPackageXML
  • JobXML (Scheduler job)
  • Plan
  • ProcessDefinitionXML
  • Report
  • RibbonXML
  • SavedFilter (filter in Filter Library)
  • ShortcutListXML (custom task pane)
  • Template
  • Undefined
  • WebReportXML
  • WorkflowXML

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.

See also