OData过滤器嵌套查询 [英] OData filter nested query

问题描述

假设我们有一个雇员json结果集，并分配了可用的审阅者(作为嵌套的json结果集).我想找出分配一名审阅者/未向该雇员分配审阅者的情况.

Let's assume we have an employee json resultset and assigned reviewer (as nested json resultset) available. I would like to find out case where a reviewer is assigned/and reviewer not assigned to the employee.

通过使用下面的查询，我可以分配指定的审阅者.

By using the query below I was able to get assigned reviewer.

$filter=Reviewer/any(reviewer: reviewer/ReviewerId gt 0)

这将返回可以使用审阅者的所有员工.但是，当审阅者不可用(或为空)时，如何返回结果?谢谢.

This returns all employees where reviewer is available. But how do I return result where reviewer is unavailable (or empty)? Thanks.

推荐答案

如果您希望获取原始过滤器查询未返回的所有实体，则可以在查询内容的前面加上"not"您已经:

If you're looking to get all the entities that weren't returned by your original filter query, you could just put a "not" in front of what you have already:

$filter=not Reviewer/any(reviewer: reviewer/ReviewerId gt 0)

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