xTuple logo

xTuple Connect Guide
Submitting MetaSQL Statements to the xTuple Connect Batch Manager
Prev Ad Hoc Database Queries Next

Submitting MetaSQL Statements to the xTuple Connect Batch Manager

Active vs. Inactive MetaSQL Parameters
The xTupleMetaSQLEmail EDI Profile

When the xTuple Connect package is enabled, a SCHEDULE button appears on the MetaSQL Statements screen. This allows you to submit any of the shared MetaSQL statements to the xTuple Connect Batch Manager. Follow these steps to do so:

  1. Follow this path: System > Design > MetaSQL Statements

  2. Select a MetaSQL statement from the list

  3. Click the SCHEDULE button

  4. The screen should look similar to this:

    Submitting a MetaSQL Statement to the Batch Manager

  5. Set the type and value of each of the parameters in the list in turn (see the section called “Active vs. Inactive MetaSQL Parameters”):

    1. Select a parameter from the list at the top of the Review EDI Before Sending screen

    2. Click the EDIT button

    3. The screen should now look like this:

      Sample Parameter Editor

    4. Choose an appropriate data type from the "Type" list. This will help ensure that the value you enter is valid

    5. Click the "Active" box if you want to send it to the MetaSQL statement

      Note

      You usually want the parameter to be active. See the section called “Active vs. Inactive MetaSQL Parameters” for details.

    6. Enter the desired value for the parameter

  6. Click the ACCEPT button

Prev Up Next
Ad Hoc Database Queries Home Active vs. Inactive MetaSQL Parameters