...
The difference between this filter and the previous examples is that RegulatedEntity-IMO OR RegulatedEntity- OFFICIAL_NO are the same filter type RegulatedEntity
similarlySimilarly:
"Filter": "Status='Draft’ OR Status=’InProgress’ is not supported but "Filter": "Status='Draft, InProgress’ is supported.
Query a list of ServiceRequest using a Date Range using the “DateRangeUtc” keyword
Code Block | ||
---|---|---|
| ||
{
"UserId": 9873,
"ServiceId": 0,
"Services": null,
"OrganizationId": 0,
"IncludeRegulatedEntities": false,
"Page": 1,
"PageSize": 25,
"Filter": "DateRangeUtc=20210801-20210803"
}
|
DateRangeUtc=20210802 - Query the date for a single given day (inclusive)
DateRangeUtc=20210802-20210802 - Query the date for a given range (inclusive)
Specifying a Sort Order
Code Block | ||
---|---|---|
| ||
{
"UserId": 9873,
"ServiceId": 0,
"Services": null,
"OrganizationId": 0,
"IncludeRegulatedEntities": false,
"Page": 1,
"PageSize": 25,
"Filter": "DateRangeUtc=20210801-20210803"
} |
OrderBy Syntax
OrderBy-{Id|Date}={Asc|Ascending|Desc|Descending} the query itself is case insensitive
Notes
OrderBy-Id=Ascending is the same as OrderBy-Id=Asc
OrderBy-Date=Ascending is the same as OrderBy-Date=Asc
OrderBy-Id=Descending is the same as OrderBy-Id=Desc and is the same as OrderBy-Id (without using a sort direction)
OrderBy-Date=Descending is the same as OrderBy-Id=Desc and is the same as OrderBy-Date (without using a sort direction)
Know Issues
PlaceOfSupply is case sensitive
If an unsupported type is being used, it will be discarded .
Service Requests will be retrieving without taking that condition into account.