Need ability to query z.array() fields (e.g. tags) in the latest nuxt-content module (v3.alpha.8)

[humblemodulo]

Discussed in #2955

^{Originally posted by humblemodulo January 7, 2025}
In the previous version of nuxt-content (v2) I would simply query tags like so:

  .where({ tags: { $contains: tagSlug } })

However there is no contains in v3, and the logic for IN seems to require the reverse operation. I've tried LIKE and that doesn't work either.

Definitely need to know the best way to find values in z.array() field types.

As it stands, I'm forced to retrieve all, then run JS .filter() on the results. Quite inefficient.

[farnabaz]

Could you provide a simple reproduction?
The proper way to do this in sqlite is using json_each operator, which is not yet supported in Content query builder.
However, I believe we can achieve your goal with simpler solution with LIKE. If you provide a simple reproduction we can sort it out.

[UphkcRNqmafQWcSSSSSS]

 .where('tags', 'LIKE', `%${route.params.tag}%`)

[terrarum]

I believe I've run into the same problem as @humblemodulo - the above use of LIKE solved my problem but here's a repo demonstrating the issue: https://github.com/terrarum/nuxt-in-tag-repro

app.vue contains the example and the above solution, but with this schema definition:

schema: z.object({
  tags: z.array(z.string()).default([]),
})

and this frontmatter:

---
tags:
  - show
  - tag1
---

I expected to be able to filter posts like so:

  return queryCollection('blog')
      .where('tags', 'IN', 'show')
      .all()

But instead it returns nothing.

[brandsquare]

Have the same issue as @terrarum and @humblemodulo

[terrarum]

I have updated my reproduction repo above to @nuxt/content v3.1.0. The problem persists, as do the horrors.

[mklueh]

facing a similar issue, as I have a custom slug defined which is now part of the meta object. I can't use the .path() method because I do not want to rely on the file name as route slug.

However I haven't found a way to access the slug in the query. Using .where("meta.slug","=",mySlug) was my first assumption, but not working.

So using like solves it, but I'd which there would be a cleaner approach in the future Thanks @UphkcRNqmafQWcSSSSSS for the tip