本文介绍了OData过滤器查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有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过滤器查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!