read for query parameters to be used as search criteria; use any combination of fields from tables:
drs_settle_hist - use drs_settle_hist or no prefixmovement - use movement prefixpayee - use payee prefix
For example, /settlements/history?drs_settle_hist.pay_date=>=t-7&movement.loaded=L
would return settlement history records from loaded movements having a check date within the last 7 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 drs_settle_hist.transfer_date+DESC will be applied.
For example, /settlements/history/search?drs_settle_hist.payee_id=*&orderBy=drs_settle_hist.pay_date+DESC would return settlement history records for all payees sorted descending by check date. 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, /settlements/history/search?drs_settle_hist.payee_id=*&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.
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, /settlements/historysearch?drs_settle_hist.loaded=L&changedAfterDate=t-1 would return settlement history for loaded movements 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, /settlements/history/search?drs_settle_hist.loaded=L&changedAfterDate=t-1&changedAfterType=Add would return settlement history for loaded movements that have been added since the beginning of the previous day. |