Reports
Report
Contains all reports in Argos.
| Id |
INTEGER |
Unique record identifier. |
| Name |
TEXT |
Name of the report. |
| DataBlock_Id |
INTEGER |
Record id of the parent DataBlock. |
| Type |
TEXT |
The type of report such as "CSV" or "Banded". |
| Description |
TEXT |
Description of the what report is used for. |
| Author |
TEXT |
Author of the report. |
| CreateDate |
DATETIME |
Date and time the report was created. |
| ModifiedBy |
TEXT |
User that last modified the report. |
| ModifyDate |
DATETIME |
Date and time the report was last modified. |
| Private |
BOOLEAN |
True if this report is private to the author. |
| Guid |
TEXT |
The globally unique id for this report. |
| ExtProp |
TEXT |
Extended properties (XML format). |
| Licensed |
BOOLEAN |
'Yes' if this object contains licensed data. |
| RevisionControl |
INTEGER |
Indicates if this report is under revision control. (0 = No, 1 = Yes, 2 = Use Parent). |
| MaxRevisions |
INTEGER |
Maximum number of revisions to keep. |
| LastRunDate |
DATETIME |
Date and time the report was last run. |
ReportNote
Any notes that are associated with the report.
| Id |
INTEGER |
Unique record identifier. |
| Report_Id |
INTEGER |
Link to Report record. |
| Title |
TEXT |
The title of this note. |
| AddedDate |
DATETIME |
The date and time this note was added. |
| ActivityDate |
DATETIME |
Last date and time this note was modified. |
| Author |
TEXT |
The user who added this note. |
| ModifiedBy |
TEXT |
The user who last modified this note. |
| Text |
TEXT |
The text of the note. |
ReportRevision
Tracks revisions of reports. Functions as a version-control system for Argos objects.
| Id |
INTEGER |
Unique record identifier. |
| Report_Id |
INTEGER |
Foreign key to Report record. |
| Author |
TEXT |
Author of the revision. |
| ActivityDate |
DATETIME |
Date and time this revision was edited/created. |
| Active |
BOOLEAN |
True if the record is the active revision. |
| Note |
TEXT |
Notes for this revision. |
ReportData
| Name |
TEXT |
Name of the element. |
| ReportRevision_Id |
INTEGER |
Link to ReportRevision record. |
| ContentType |
TEXT |
MIME type of the associated data. |
ReportLock
| Id |
INTEGER |
Unique record identifier corresponding to a record in NodeLock. |
| Report_Id |
INTEGER |
Foreign key to Report record. |
ReportSavedState
Contains saved run states of reports.
| Id |
INTEGER |
Unique record identifier. |
| Report_Id |
INTEGER |
Foreign key to Report record. |
| Name |
TEXT |
Name of this saved state. |
| CreateDate |
DATETIME |
The date and time this record was created. |
ReportApi
API settings of a report.
| Id |
INTEGER |
Unique record identifier and link to Report record. |
| Enabled |
BOOLEAN |
Yes if this record is enabled. |
| UniqueId |
TEXT |
Unique textual identifier used to reference this record. |
| Username |
TEXT |
User that is used to run the referenced report. |
| Password |
TEXT |
Encrypted password for the user. |
| Variables |
TEXT |
List of pre-configured variable values. |
ReportRun
All reports currently being run in the system.
| Id |
INTEGER |
Unique record identifier. |
| Session_Id |
INTEGER |
Foreign key to XRef_Session record. |
| Report_Id |
INTEGER |
Foreign key to Report record. |
| UniqueId |
TEXT |
Unique Id provided to clients at access the queued records. |
| CreateDate |
DATETIME |
The date this record was created. |
| ActivityDate |
DATETIME |
The date this record was last modified. |
| Status |
TEXT |
Current status of running reports. |
| Configuration |
TEXT |
JSON formatted string with configuration data to run a report. |
| Result |
TEXT |
JSON formatted string with configuration data to run a report. |
Draft_Report
Associates the Draft record to a Report record.
| Draft_Id |
INTEGER |
Link to Draft. |
| Report_Id |
INTEGER |
Link to Report. |
| ReportRevision_Id |
INTEGER |
Link to ReportRevision. |