Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Trading Networks Built-In Services Reference | IS Document Types | Summary of Elements in this Folder | wm.tn.rec:queryInput
 
wm.tn.rec:queryInput
The input for a query.
Variables
pageSize
String Optional. The page size to use when enumerating over the query results. The default is 100.
queryID
String The ID of the query. This ID can be used in the wm.tn.query:getQueryResults service to get the query results.
criteria
Document Contains the filter criteria of the query. The document contains the following variables:
*dateRange Document The start date and end date of the documents. Only those documents that fall within this date range are retrieved. The document contains the following variables:
*startDate String A timestamp that filters the documents that were received after the specified value. For Java developers, this must be the long value obtained from the java.sql.Timestamp object.
*endDate String A timestamp that filters the document that were received before the specified value. For Java developers, this must be the long value obtained from the java.sql.Timestamp object.
*isOrQuery String Whether the join condition for the filter criteria that you specify in the fields variable is AND or OR. You can set the following values:
*true - OR
*false - AND (Default)
receiverEqualsSender
String Whether the sub-query that you specify in the dynamicCriteria variable of the wm.tn.rec:queryField IS document type must apply to both sender and receiver. The values can be true or false. The default value is false.
If the value is true and the sub-query that you specify in dynamicCriteria is for sender ID, then the same sub-query is used for receiver ID too.
Similarly, if the value is true and the sub-query specified in dynamicCriteria is for receiver ID, then the same sub-query is used for sender ID too.
fields
Document List The filter criteria for fields such as DocTimestamp, DocID. For the document structure, see wm.tn.rec:queryField.
sortOrder
Document List. The column name by which the results must be sorted. Each document in the document list contains the following variables:
*columnName String The column name for sorting. For the list of valid values, see List of Column names.
*isAscending String The order by which the results set must be sorted (ascending or descending). Valid values are:
*ASC Ascending
*DESC Descending
resultSet
Columns
String List The names of the columns that must be available in the result set. For the list of valid values, see List of Column names.