Using Cross Reference Table Applications
Spectrum includes powerful cross reference table applications that allow administrators and advanced users to quickly access and manage customer-specific cross reference tables from within the Spectrum user interface. You can use the application to create cross reference tables, and then import data to the table or use the application to add data. Customer cross reference tables reside in their own schema within the Spectrum database called LOFTXREF.
For example, you could use a cross reference table application to view and modify effective dates for your label templates and to automatically verify the dates before the label template can be used for printing.
Important: If you are using the Loftware-supplied database, data from these tables is not permitted for use outside of Spectrum. For example, you cannot copy data from a table in Spectrum to an external database. This data is for Spectrum-use only.
What Cross Reference Table Applications Are
A cross reference table application is a ready-made application that serves as a "front-end interface" to the cross reference tables that you have created. The following applications are provided in the Cross Reference Table App folder in Spectrum:
- XrefUserApplication allows users to view and modify data in the tables
- XrefAdminApplication allows Administrators view and modify data in the tables, as well as create, modify, and delete tables in the database
What Cross Reference Table Applications Can Do
Depending on your permissions and the user profile assigned to you, you can use a cross reference table application in Applications
Tip: For assistance with cross reference table applications or to have Loftware create a custom cross reference table application for you, contact Loftware's Professional Services Group.
How Cross Reference Table Applications Work
A cross reference table application links numerous forms, business rules, and data services together to allow you to access and manage data in your cross reference tables. All relevant objects are provided in the Cross Reference Table App folder in Spectrum.
When you create a cross reference table, the table and its audit table are added to the LOFTXREF schema in the database. A pair of data services is also created for the table – a JDBC Data Service for READ access, and a JDBC Update Data Service for UPDATE access. The data services are automatically saved in the Cross Reference Table App folder and started.
Example
If you create a cross reference table named MYTABLENAME, the table and its audit table named MYTABLENAME_A exist in the LOFTXREF schema, and two JDBC data services named MYTABLENAME_READ and MYTABLENAME_UPDATE are created in the Cross Reference Table App folder.
Default Columns in a Cross Reference Table
When you create a cross reference table, the table includes the following columns by default.
| Column Name | Data Type | Description |
|---|---|---|
|
ID |
Number |
The internal identification number of the cross reference table row. ID numbers of deleted rows are not reused. |
|
CREATED |
DateTime |
The date and time when the row was created. |
|
MODIFIED |
DateTime |
The date and time when the last edit was made to the row. |
|
CREATED_ISSUER |
String |
The user name of the user who created the row. |
|
LAST_UPDATED_ISSUER |
String |
The user name of the user who last edited the row. |
Columns in an Audit Record Table
A cross reference table audit record includes the following columns, where O_ is the old audit record value and N_ is the new audit record value.
| Column Name | Data Type | Description |
|---|---|---|
|
ID |
Number |
The internal identification number of the audit record row. |
|
AUDIT_ACTION |
String |
The type of audit action performed on the cross reference table row: CREATE, INSERT, UPDATE, or DELETE. |
|
AUDIT_DATE |
DateTime |
The date and time when the audit action was performed on the cross reference table row. |
|
O_ID |
Number |
The internal identification number of the cross reference table row. This field is empty for rows with an AUDIT_ACTION of INSERT. |
|
N_ID |
Number |
The internal identification number of the cross reference table record or row. |
|
O_CREATED |
DateTime |
The date and time when the row was created. The value is NA for rows with an AUDIT_ACTION of INSERT. |
|
N_CREATED |
DateTime |
The date and time when the row was created. |
|
O_MODIFIED |
DateTime |
The date and time when the last audit auction was performed on the row. The value is NA for rows with an AUDIT_ACTION of INSERT. |
|
N_MODIFIED |
DateTime |
The date and time when the new audit action was performed on the row. |
|
O_CREATED_ISSUER |
String |
The user name of the user who created the row. This field is empty for rows with an AUDIT_ACTION of INSERT. |
|
N_CREATED_ISSUER |
String |
The user name of the user who created the row. |
|
O_LAST_UPDATED_ISSUER |
String |
The user name of the last user who edited the row. |
|
O_LAST_UPDATED_ISSUER |
String |
The user name of the user who edited the row. |
|
O_MYCOLUMNNAME |
String, Number, or Date/Time |
The old data in the cross reference table row in the MYCOLUMNNAME column. |
|
N_MYCOLUMNNAME |
String, Number, or Date/Time |
The new data in the cross reference table row in the MYCOLUMNNAME column. |