OData过滤器查询 [英] OData filter query

问题描述

我有DEPatientVisit和DEPhysician表

I have tables DEPatientVisit and DEPhysician

我需要过滤基于数据的参数

i need to filter the data based parameters

推荐答案

OData v4引入了新的运算符"any"，可以解决您的情况.您的请求网址如下:

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)

有关更多信息，请参考: http://docs.oasis-open.org/odata/odata/v4.0/odata-v4.0-part2-url-conventions.html ，第5.1.1.5.1节

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

这篇关于OData过滤器查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！