find method of payload with filter by reference

[haughty juniper]

I'm trying to do a custom query in my app built with payload. In this query I filter my Orders collection using the Warehouse collection that are related. I'm trying this way but I can't do it

 const orders = await payload.find({
   collection: 'orders',
   where: {warehouse: {equals:   "640a22cacc1ca5ce8e415958"}},
    page: page,
 });

@here

[void iron]

Hey @haughty juniper - looks like you're on the right path here, are you getting an error when you run this payload.find?

Also, is your snippet above wrapped with an async function?

e.g.

const getOrders = async () => {
  const orders = await payload.find({
    collection: 'orders',
    where: {...},
  });

  return orders;
}

[haughty juniper]

Hey @void iron
yes, this is an async function, but it returns an empty array

[void iron]

@haughty juniper on your orders collection, is warehouse a relationship field to another collection?

and is your access control on the orders collection set to true?

[haughty juniper]

What configuration in access control should I set?