How to use meta.category or meta.date in .where() query?

[ivanradojevic-web-dev]

const route = useRoute()
const { data } = await useAsyncData(route.path, () => {
  return queryCollection('docs')
    .where('date', '<', '2024-04-04')
    .where('category', '=', 'news')
    .all()
})

How can I use category or date in .where() queries?!?

{
"date": "2024-01-10",
"category": "economy"
}

[yudin-s]

In v3, fields such as category and date are easiest to query when they are part of the collection schema. If a frontmatter field is not declared in the schema, Nuxt Content keeps it under meta, and querying nested meta.* values is not the path I would rely on.

Define the fields in content.config.ts:

import { defineCollection, defineContentConfig, z } from "@nuxt/content"

export default defineContentConfig({
  collections: {
    docs: defineCollection({
      type: "page",
      source: "**/*.md",
      schema: z.object({
        date: z.string(),
        category: z.string()
      })
    })
  }
})

Then this should work as a normal query:

const { data } = await useAsyncData(route.path, () => {
  return queryCollection("docs")
    .where("date", "<", "2024-04-04")
    .where("category", "=", "news")
    .all()
})

A couple of gotchas:

• Keep dates in ISO format (YYYY-MM-DD) if you compare them as strings.
• Restart/rebuild after changing content.config.ts so the generated collection types/storage are refreshed.
• If you want category to accept only known values, use something like z.enum(["economy", "news"]) instead of z.string().