CODEWITHSUNDEEP
web-servicesodatais-emptynavision
Marko Zadravec
Marko Zadravec

Reputation: 8738

Navision OData service filter not working

I have a service in Navision

https://.......?$format=json return me the results

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;"
},
....

If I try and filter it out with

https://.......?$format=json$filter=recVendor_Predal%20ne%20%27%27 it returns me the same results, like the filter would be ignored.

But if I use the same filter for another properties, then the filter have an affect :

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

{
  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;"
},
....

What could be wrong,..

Upvotes: 0

Views: 276

Answers (1)

MaweMawe
MaweMawe

Reputation: 21

Not sure why the second filter works but have you tried using &$filter... istead of just $filter? Like https://.......?$format=json&$filter=recVendor_Predal%20ne%20%27%27

Upvotes: 1

Related Questions