What You See on the ServiceNow Adapter Extended Query Parameters Page

The following table describes the key information on the ServiceNow Adapter Extended Query Parameters page. For example, if you selected Incident as the table in which to query records and GET as the operation to perform on the table in ServiceNow, you may select a number from the Order by dropdown list in the Extended Query Parameters section and select short_description in the Include Fields section.

Element	Description
Extended Query Parameter	Select the extended query parameters to use from the following list: Order By — Uses the specified field to order the returned results. Order By desc — Uses the specified field to order the returned results in descending order. First row — Offsets the results by this number of records from the beginning of the set. When used with Last row, it has the effect of querying for a window of results. The results include the first row number. Last row — Limits the results by this number of records from the beginning of the set or the start row values when specified. When used with First row, it has the effect of querying for a window of results. Returns fewer results than the last row number and does not include the last row. Limit — Limits the number of records returned. Use view — Specifies the name of a form view that is used to limit and expand the returned results. When the form view contains deeply referenced fields (for example, caller_id.email), this field is also returned in the result.
Include Fields	Select the fields to include.
Filter By Field Name	Type the initial letters of the field name to filter the display of names in the list.
Select Fields to include	Displays the fields available to select from the application.
Included Fields	Displays the selected fields.
Encoded query	Build a custom query. For example: Incident number is INC0022759 and Active is true