QueryXMLList

You can use the QueryXMLList activity to query an existed table in the JD Edwards EnterpriseOne system.

General

The following table describes the configurations in the General tab of the QueryXMLList activity.

Field Module Property? Description
Name No The name of the activity displayed in the process. The default value is QueryXMLList.
JDE Connection Yes Select a JDE Connection shared resource by completing the following steps:
  1. Click the Choose/Create Default Resource icon to open the "Select JdeconnectionResource Resource Template" window, where all the available resources are listed.
  2. In the Matching items panel, click the shared resource you want to select. Click OK.
Table Type No Select one of the following table types:
  1. Table
  2. View
  3. TC
Table Name Yes Select a table name by completing the following steps:
  1. Click the Choose a resource icon; the JDE Object List window is displayed.
  2. Select an object by entering a value in the Please select an object field to match the desired object, or by scrolling up and down the object list. Click OK.
Query Type No Select one of the following query types:
  1. ListCreate

    Creates a list in the specified Table, View or TC.

  2. ListRetrieve

    Retrieves a list from the specified Table, View or TC.

  3. ListDelete

    Deletes a list from the specified Table, View or TC.

Description

In the Description tab, you can add a short description for the QueryXMLList activity.

Advanced

The following table describes the configurations in the Advanced tab of the QueryXMLList activity.

Field Module Property? Description
Get Schema No Click this button to get the schema of the selected table.
Name No The name of the table selected from the Table Name list in the General tab.
Use Attribute No Select this check box if you want to use the attribute as an input parameter for the selected table.
Refresh No Click this button after you complete all the settings in the Advanced tab.
Note: If TC is selected in the Table Type field, you have to select the TC version after clicking Get Schema in the Advanced tab.

Input

The following table describes the input elements in the Input tab of the QueryXMLList activity.

Input Item Data Type Description
The following fields are displayed when Table, or View in the Table Type list, and ListCreate in the Query Type list are selected.
TableName String Specify the name for the table, where ListCreate operations are performed, with single or double quotation marks.
TableType String Enter a table type, such as OWTABLE, OWVIEW, or FOREIGN_TABLE.
DataSelection N/A Specify the data used to create a list in the specified table under this node.
ClauseType N/A Specify the clause type under this node.
ClauseName String Enter the name for the clause with single or double quotation marks. The clause name can be WHERE, OR, or AND.
OperationType String Enter an operation type, such as EQ, NE, or LT.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column, where ListCreate operations are performed, with single or double quotation marks.
TableName String Enter the name for the table, where ListCreate operations are performed, with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column name with single or double quotation marks.
Oprand N/A Specify the supported element types under this node.
LiteralValue String Enter the literal value with single or double quotation marks.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column, where ListCreate operations are performed, with single or double quotation marks.
TableName String Enter the name for the table with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column name with single or double quotation marks.
OpRange N/A Specify the operand range under this node.
LiteralFrom Int Enter the starting literal value with single or double quotation marks.
LiteralTo Int Enter the end literal value with single or double quotation marks.
OpList N/A Specify the operand list under this node.
LiteralValue String Enter the literal value for the operand with single or double quotation marks.
DataSequencing N/A Specify the data sequence for the specified column.
Sort String Sort the specified column in descending or ascending order, with single or double quotation marks.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column with single or double quotation marks.
TableName String Enter the name for the table with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column with single or double quotation marks.
The following fields are displayed when TC in the Table Type list, and ListCreate in the Query Type list are selected.
TCName String Specify the name for the TC, where ListRetrieve operations are performed, with single or double quotation marks.
TCVersion String Specify the version for the TC with single or double quotation marks.
DataSelection N/A Specify the data used to create a list in the specified table under this node.
ClauseType N/A Specify the clause type under this node.
ClauseName String Enter the name for the clause with single or double quotation marks. The clause name can be WHERE, OR, or AND.
OperationType String Enter an operation type, such as EQ, NE, or LT.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column, where ListCreate operations are performed, with single or double quotation marks.
TableName String Enter the name for the table, where ListCreate operations are performed, with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column name with single or double quotation marks.
Oprand N/A Specify the supported element types under this node.
LiteralValue String Enter the literal value with single or double quotation marks.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column with single or double quotation marks.
TableName String Enter the name for the table with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column name with single or double quotation marks.
OpRange N/A Specify the operand range under this node.
LiteralFrom Int Enter the starting literal value with single or double quotation marks.
LiteralTo Int Enter the end literal value with single or double quotation marks.
OpList N/A Specify the operand list under this node.
LiteralValue String Enter the literal value for the operand with single or double quotation marks.
DataSequencing N/A Specify the data sequence for the specified column.
Sort String Sort the specified column in descending or ascending order, with single or double quotation marks.
ColumnAttributes N/A Specify the column attributes for the specified table under this node.
ColumnName String Enter the name for the column with single or double quotation marks.
TableName String Enter the name for the table with single or double quotation marks.
Instance String Enter the instance value for the column with single or double quotation marks.
Alias String Enter an alias for the column with single or double quotation marks.
The following fields are displayed when Table, or View in the Table Type list, and ListRetrieve in the Query Type list are selected.
TableName String Specify the name for the table, where ListRetrieve operations are performed, with single or double quotation marks.
Handle String Specify the handle which is generated by the ListCreate operation and is used to retrieve data from a list.
From String Enter a value to specify where to start retrieving data, with single or double quotation marks.
To String Enter a value to specify where to end retrieving data, with single or double quotation marks.
The following fields are displayed when TC in the Table Type list and ListRetrieve in the Query Type list are selected.
TCName String Specify the name for the TC, where ListRetrieve operations are performed, with single or double quotation marks.
Handle String Specify the handle which is generated by the ListCreate operation and is used to retrieve data from a list.
From String Enter a value to specify where to start retrieving data, with single or double quotation marks.
To String Enter a value to specify where to end retrieving data, with single or double quotation marks.
The following field is displayed when Table, View or TC in the Table Type list, and ListDelete in the Query Type list are selected.
Handle String Specify the handle which is generated by the ListCreate operation and is used to delete a list.

Output

The following table describes the output elements in the Output tab of the QueryXMLList activity.

Output Item Data Type Description
The following fields are displayed when Table, or View in the Table Type list, and ListCreate in the Query Type list are selected.
Status Boolean The status of the QueryXMLList activity. If it runs successfully, the status is true; otherwise, the status is false.
ID String The ID number of the returned message.
Message String The return message after running the QueryXMLList activity.
TableName String The name of the table where ListCreate operations are performed.
Handle String The unique identifier which is used to retrieve data or delete a list.
Session String The session and its value in the process.
Size Int The size of the data in bytes.
ReturnCode String The return code after running the QueryXMLList activity.
The following fields are displayed when TC in the Table Type list and ListCreate in the Query Type list are selected.
Status Boolean The status of the QueryXMLList activity. If it runs successfully, the status is true; otherwise, the status is false.
ID String The ID number of the returned message.
Message String The return message after running the QueryXMLList activity.
TCName String The name of the TC where ListCreate operations are performed.
Handle String The unique identifier which is used to retrieve data or delete a list.
Session String The session and its value in the process.
Size Int The size of the data in bytes.
ReturnCode String The return code after running the QueryXMLList activity.
The following fields are displayed when Table, or View in the Table Type list, and ListRetrieve in the Query Type list are selected.
Status Boolean The status of the QueryXMLList activity. If it runs successfully, the status is true; otherwise, the status is false.
ID String The ID number of the returned message.
Message String The return message after running the QueryXMLList activity.
TableName String The name of the table where ListRetrieve operations are performed.
Handle String The unique identifier which is used to retrieve data from a list.
ReturnCode String The return code after running the QueryXMLList activity.
The following fields are displayed when TC in the Table Type list and ListRetrieve in the Query Type list are selected.
Status Boolean The status of the QueryXMLList activity. If it runs successfully, the status is true; otherwise, the status is false.
ID String The ID number of the returned message.
Message String The return message after running the QueryXMLList activity.
TCName String The name of the TC where ListRetrieve operations are performed.
Handle String The unique identifier which is used to retrieve data from a list.
ReturnCode String The return code after running the QueryXMLList activity.
The following fields are displayed when Table, View or TC in the Table Type list and ListDelete in the Query Type list are selected.
Status Boolean The status of the QueryXMLList activity. If it runs successfully, the status is true; otherwise, the status is false.
ID String The ID number of the returned message.
Message String The return message after running the QueryXMLList activity.
TableName String The name of the table where ListDelete operations are performed.
Handle String The unique identifier which is used to delete a list.
ReturnCode String The return code after running the QueryXMLList activity.

Fault

The following table describes the error schema elements in the Fault tab of the QueryXMLList activity.

Error Schema Element Data Type Description
JDEPluginException
msg String This error message is displayed when the JD Edwards EnterpriseOne plug-in captures an exception for the QueryXMLList activity.
msgCode String This error code is displayed when the JD Edwards EnterpriseOne plug-in captures an exception for the QueryXMLList activity.