PrintUsing Cross Reference Table Applications

Loftware Enterprise SP 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 Loftware Enterprise SP 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 Loftware Enterprise SP 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 Loftware Enterprise SP. For example, you cannot copy data from a table in Loftware Enterprise SP to an external database. This data is for Loftware Enterprise SP-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 Loftware Enterprise SP:

  • 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  to view, search, create, edit, and delete tables in your database, view audit records, and import and export data using a CSV file.

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 Loftware Enterprise SP.

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.