Direct web services extended query parameters

The following parameters, when specified as elements of input parameters to SOAP query functions such as get, getKeys, and getRecords, has the additional behavior of filtering and modifying the results that are returned.

Note: Extended query element names are preceded by two underscore characters.
Table 1.
Parameter Description Example
__encoded_query Specify an encoded query string to be used in filtering the returned results. The encoded query string format is similar to the value that may be specified in asysparm_query URL parameter. You may refer to the encoded query building example in the RSS feed generator examples. <__encoded_query>active=true^category='hardware'</__encoded_query>
__order_by Instruct the returned results to be ordered by the specified field <__order_by>priority</__order_by>
__order_by_desc Instruct the returned results to be ordered by the specified field, in descending order <__order_by_desc>opened_date</__order_by_desc>
__exclude_columns Specify a list of comma delimited field names to exclude from the result set <__exclude_columns>sys_created_on,sys_created_by,caller_id,priority</__exclude_columns>
__limit Limit the number of records that are returned <__limit>100</__limit>
__first_row Instruct the results to be offset by this number of records from the beginning of the set. When used with __last_row has the effect of querying for a window of results. The results are inclusive of the first row number. <__first_row>250</__first_row>
__last_row Instruct the results to be limited by this number of records from the beginning of the set, or the__start_row value when specified. When used with __first_row has the effect of querying for a window of results. The results are less than the last row number, and does not include the last row. <__last_row>500</__last_row>
__use_view Specify a Form view by name, to be used for limiting and expanding the results returned. When the form view contains deep referenced fields eg.caller_id.email, this field will be returned in the result as well <__use_view>soap_view</__use_view>