Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
languagejson
{
    "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
languagejson
{
    "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.