Search code examples
odataodata4j

OData filter query

I have tables DEPatientVisit and DEPhysician

i need to filter the data based parameters

Solution

  • OData v4 introduces a new operator 'any', which may resolve your scenario. Your request url would looks like:

    ~/FalconCPDataService.svc/DEPhysicians?$format=json&$expand=DEPatientVisits&$filter=DEPatientVisits/any(v:v/StimulatorGourpId+eq+guid%27F321EDAB-14C6-4FF2-9485-00ABD176EBC4%27)

    For more please reference this:http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html, section 5.1.1.5.1 any