Filter for non-null values

[vettloffah]

I'm trying to search for products that have a sku set in the backend API.

This is what I'm trying:

await swell.get("/products/", {
    limit: 100,
   where: { sku: { $ne: null } } },
  });

I am getting all products returned, even ones without skus. When I filter for sku: null I correctly get back only the products without skus, so it seems odd I can't filter the other way. Any advice?

[swellmike]

This seems to work for me using the swell-node SDK. See examples below.

Btw, the where key is redundant. You can apply filter key/values directly. It worked for me with or without the explicit where clause.

---

with sku: null filter:

const result = await swell.get('/products', {
  sku: null,
  fields: ['sku'],
  limit: 3,
});

=> {
  count: 16,
  results: [
    { sku: null, id: '63c1bea94ce74f045039cb0c' },
    { sku: null, id: '63b47422187b270038d2ed9a' },
    { sku: null, id: '639bd4ff4c7aa00ff1cd5ba2' }
  ],
  page: 1,
  pages: {
    '1': { start: 1, end: 3 },
    '2': { start: 4, end: 6 },
    '3': { start: 7, end: 9 },
    '4': { start: 10, end: 12 },
    '5': { start: 13, end: 15 }
  }
}

with sku: {$ne: null} filter:

const result = await swell.get('/products', {
  sku: { $ne: null },
  fields: ['sku'],
  limit: 3,
});

=> {
  count: 6,
  results: [
    { sku: 'TV-MM-KBS-BL', id: '5e5198ce72f5542e005fa4c8' },
    { sku: 'AERO-FLT-350', id: '5e31e67be53f9a59d89600f1' },
    { sku: 'HRO-V60FLT-100', id: '5e31e14ee53f9a59d8947b89' }
  ],
  page: 1,
  pages: { '1': { start: 1, end: 3 }, '2': { start: 4, end: 6 } }
}