Navision Odata服务过滤器不起作用

Question

我在navision

中有一个服务

https://.......?$format=json返回我结果

value: [
{
  No: "000001",
  Description: "MAGE Dummy",
  Shelf_No: "",
  recVendor_Predal: "",
  ETag: "32;GwAAAAJ7BjAAMAAwADAAMAAxAAAAAAA=9;7842639340;"
},
{
  No: "10",
  Description: "Test",
  Shelf_No: "",
  recVendor_Predal: "",
  ETag: "20;GwAAAAJ7AjEAMAAAAAAA9;7683646470;"
},
{
  No: "10000",
  Description: "ALU - FC R9-290X DCII Backplate",
  Shelf_No: "",
  recVendor_Predal: "",
  ETag: "28;GwAAAAJ7BTEAMAAwADAAMAAAAAAA9;7794545540;"
},
{
  No: "100001",
  Description: "TOP Plexi - Acrylic block front DS rev 1.3",
  Shelf_No: "4M-5E",
  recVendor_Predal: "123123",
  ETag: "32;GwAAAAJ7BjEAMAAwADAAMAAxAAAAAAA=9;7842639440;"
},
....

如果我尝试用

过滤掉

https://.......?$format=json$filter=recVendor_Predal%20ne%20%27%27它返回了我相同的结果，就像滤镜将被忽略。

但是，如果我将相同的过滤器用于其他属性，则该过滤器具有影响：

https://.......?$format=json$filter=Shelf_No%20ne%20%27%27返回

{
  No: "100001",
  Description: "TOP Plexi - Acrylic block front DS rev 1.3",
  Shelf_No: "4M-5E",
  recVendor_Predal: "123123",
  ETag: "32;GwAAAAJ7BjEAMAAwADAAMAAxAAAAAAA=9;7842639440;"
},
{
  No: "100004",
  Description: "SPOJKA Hitra M Barb 10mm - Black",
  Shelf_No: "4O-7A",
  recVendor_Predal: "",
  ETag: "32;GwAAAAJ7BjEAMAAwADAAMAA0AAAAAAA=9;7683646500;"
},
....

可能是什么问题，..

Answer 1

不确定为什么第二个过滤器有效，但是您是否尝试使用＆amp; $ filter ...仅$ filter？像https：//.......？$格式= json＆amp; $ filter = recvendor_predal％20ne％20％20％27％27