How do I get posts that have a certain category set to it?

ahmetskilinc

7 months ago

1 1

const stringifiedQuery = qs.stringify(
  {
    where: {
      category: {
        name: {
          equals: req.query.name,
        },
      },
    },
  },
  { addQueryPrefix: true }
);

Post: {
  /*...*/
  title,
  category: Category,
  /*...*/
}

Category: {
  id,
  name,
}

• Selected Answer
  

  jmikrut

  Payload Team

  7 months ago

  Hey @ahmetskilinc — here's how you'd do that:

  const stringifiedQuery = qs.stringify(
    {
      where: {
        'category.name': {
          equals: req.query.name,
        },
      },
    },
    { addQueryPrefix: true }
  );

  You have to use dot notation to query on nested relationship fields, but this should be golden!

  2 replies
• 

  ahmetskilinc

  7 months ago

  Thank you!

• 

  ahmetskilinc

  7 months ago

  Hey @jmikrut how about with an array of tags?

  Post: {
    /*...*/
    title,
    tags: Tag[],
    /*...*/
  }
  
  Tag: {
    id,
    name,
  }