Query Non-Empty Array Fields in Payload CMS Version 3

zed0547last year

8

const result = await payload.find({
  collection: 'posts',
  where: {
    scheduledActions: { equals: [] },
  },
  limit: 10000,
  depth: 0,
})

• 

  dkirchhoflast year

  "not_equals: []" seems to work. Have a try on documents, where the array is not yet defined.

• 

  zed0547last year

  OH, sorry you mentioned

  "Not Equals"

  and I read this as "equals" accidentally

  
  
  

  My mistake, but glad you figured it out in the end

• 

  ritsu0455last year

  This works ^ because MongoDB can accept that value, generally, for now there's no any payload "official" way that works in all database adapters and guaranteed to not break in the future

• 

  zed0547last year

  I guess an adapter agnostic way would be a distinct operator here?

• 

  ritsu0455last year

  Maybe something like

  scheduledActions._length: { equals: 0 }
• 

  dkirchhoflast year

  Since I use mongodb, im fine with the specific solution. Thank you.

  
  

  Just wondering, why the "old syntax" doesn't work anymore.

  
  
  @423216344302092288

  scheduledActions._length throws the same error

• 

  ritsu0455last year

  scheduledActions._length

  is just my imagination for a possible in the future official way to do this

  
  
  

  The old syntax doesn't work anymore probably because we expect

  0

  as a field defined in the payload config now

• 

  dkirchhoflast year

  Got it. Thanks again 🙂