AX2478
Axiom.PlanFileAttachments
The Axiom.PlanFileAttachments system table contains information about the plan file attachments that have been saved to your system.
Available columns
The following columns can be queried:
| Column | Description |
|---|---|
|
FileGroupName |
The name of the file group. |
|
FileGroupCode |
The file group code. |
|
PlanItemDisplay |
The display name of the plan file (for example, Dept 100). |
|
PlanItemValue |
The plan code for the plan file (for example, 100). |
|
PlanFileName |
The name of the plan file (for example, 100.xlsx). |
|
AttachmentName |
The name of the file attachment. |
|
DocumentID |
The document ID of the file attachment. |
|
Description |
The description of the file attachment. |
|
DateUploaded |
The date the file attachment was uploaded. |
|
UploadedBy |
The user who uploaded the file attachment. |
|
FileSize |
The size of the file attachment. |
|
FileType |
The file format of the file attachment. |
Remarks
-
When querying Axiom.PlanFileAttachments within a plan file, the query is automatically filtered to only return the attachments for the current plan file. Otherwise, the query will return all attachments unless the query is filtered.
-
The file group name returned is the true name, not the display name. If you need the display name, you can use the calc method row for the Axiom query to return it, using a GetFileGroupProperty function. For example:
=GetFileGroupProperty(GetFileGroupId(C4),"FileGroupDisplayName")
Where C4 references the file group name returned by the Axiom query.
Save Type 4 support
Axiom.PlanFileAttachments cannot be modified using Save Type 4.
