read for query parameters to be used as search criteria; use any combination of fields from the
unposted_wire table using a prefix of unposted_wire or no prefix.
For example,
/wires/search?driver_id=MBROOKS&check_amount=>50&trans_date_time=>=t-100
would find unposted wires to driver MBROOKS greater than $50 entered within the last 100 days.
Sorting: To sort the result set, you can provide the following reserved
query parameter: orderBy If the orderBy parameter is not provided a default sort of
uposted_wire.trans_date_time+DESC will be applied.
For example,
/wires/search?unposted_wire.ok2post=Y&orderBy=unposted_wire.check_number+DESC
would return unposted wire records that are marked ready to post sorted descending by the
unposted_wire.check_number. Multiple sort columns can be provided in a comma delimited format.
orderBy=prefix.field+direction,prefix.field+direction
Pagination: To page the result set, you can provide the following
reserved query parameters: recordLength and recordOffset
For example,
/locations/search?unposted_wire.ok2post=Y&recordLength=100&recordOffset=50
would return 100 records starting at the 51st record in the return record set. If no recordLength
parameter is provided the search result maximum value in the mobile service control file will be
applied. Note: Result size is limited to 1000 records unless specifically configured using
the
-Dloadmaster.api.maxresultsize vmparam.
Changed After Date: To return only records that have been changed or
added since a specific date and time, you can provide the
changedAfterDate parameter. Dates are limited to the audit setting
and days to keep value in the table properties configuration.
For example,
/wires/search?unposted_wire.ok2post=Y&changedAfterDate=t-1 would
return unposted wire records marked ready to post that have been added or updated since the
beginning of the previous day.
Change Types: To further define the types
of changes you want to filter, use the changedAfterType parameter. This parameter is
to be used in conjunction with changedAfterDate to give the ability to specify if you
want added or updated records.
Allowed values: [Add, Update]. Any other value
will result in an exception. If the ChangedAfterType parameter is not provided, both
added and updated records will be returned. If you do not provide a corresponding
ChangedAfterDate the
ChangedAfterType parameter will be ignored.
For example,
/wires/search?unposted_wire.ok2post=Y&changedAfterDate=t-1&changedAfterType=Add
would return unposted wire records marked ready to post that have been added since the beginning
of the previous day. |