How to filter query by field value

mozomig3 years ago

5

• 

  jarrod_not_jared

  3 years ago

  With the rest API, you can add a query to the url params

  /api/posts?where[status][equals]=published
  
  

  FYI, Payload has some built in draft functionality that you might want to check out!

  https://payloadcms.com/docs/versions/overview#collection-config
• 

  mozomig3 years ago

  But what can I do if I don’t want give users access to resource (posts) if it don’t have published status?

• 

  jarrod_not_jared

  3 years ago

  Use access control on the collection:

  
  

  read: ({ req: { user } }) => {
    if (user) {
      return true;
    }
  
    return {
      or: [
        {
          status: {
            equals: 'published',
          },
        },
        {
          status: {
            exists: false,
          },
        },
      ],
    };
  },

  
  
  

  🙂

• 

  mozomig3 years ago

  I try it and write to here by result, thank you 🙏

• 

  jarrod_not_jared

  3 years ago

  Yep no problem, you may need to adjust the user check, i.e. if you only want users with a certain role or something to be able to always read posts