queryCollection.('collection_name').skip() and queryCollection.('collection_name').where(key, 'LIKE', value) or where(key, 'IN', array) not working for version 3.2.2

[fandy8255]

Environment

---

• Operating System: Windows_NT
• Node Version: v20.16.0
• Nuxt Version: 3.14.1592
• CLI Version: 3.15.0
• Nitro Version: 2.10.4
• Package Manager: npm@10.8.1
• Builder: -
• User Config: default
• Runtime Modules: @nuxt/image@1.8.1, @nuxtjs/supabase@1.4.3, @pinia/nuxt@0.9.0, pinia-plugin-persistedstate@4.1.3, @nuxt/content@3.2.2
• Build Modules: -

---

Version

v3.2.2

Reproduction

https://stackblitz.com/edit/github-9ynqdouz?file=app%2Fpages%2F%5B...slug%5D.vue

Description

Ive not been able to use .skip() for my articles.md queries and aso not been able to filter articles by tag_names,

queryCollection('blog').skip(2).all() is not working
queryCollection('blog').where('tags', 'IN', 'tag_name').all() is not working

Here is a small fragment reproducing the issue, what could be the problem here? Thanks

{{ article.id }}

no articles found

<script setup> import { onMounted } from 'vue'; useHead({ link: { rel: 'stylesheet', href: 'https://unpkg.com/bs-brain@2.0.4/components/blogs/blog-3/assets/css/blog-3.css', }, }); const articles = useState('articles'); onMounted(async () => { /* const { data } = await useAsyncData('blog', () => queryCollection('blog').where('category', '=', 'Instagram').all() ); */ //WORKING //const { data } = await useAsyncData('blog', () => queryCollection('blog').limit(1).all()) //WORKING const { data } = await useAsyncData('blog', () => queryCollection('blog').skip(2).all() ); //NOT WORKING //console.log('data', data); /* const { data } = await useAsyncData('blog', () =>{ return queryCollection('blog').where('tags','IN','Vue').all() })*/ //NOT WORKING console.log('blog data', data); articles.value = data; window.scrollTo(0, 0); }); </script> <style> .hero-section { background: linear-gradient(to bottom right, #ff7eb9, #ff758c); color: white; /*height: 90vh;*/ width: 100%; background-image: url('/assets/images/hero-banner.jpg'); background-size: cover; background-position: center; /*padding: 100px 0;*/ } a { color: azure; } @media only screen and (max-width: 600px) { #main-container { padding: 1vw; } } </style>

Additional context

No response

Logs

[fandy8255]

okay so i found that skip() only works when limit is also chained :

queryCollection('blog') .order('date', 'DESC') .skip(skip) .limit(itemsPerPage) .all() ,
what still isnt working is :

const { data } = await useAsyncData('blog', () =>{ return queryCollection('blog').where('tags','IN','Instagram').all() }) im trying to query articles with a specific tag ,

here is how the frontmatter looks like:

`---
title: Article Three
subtitle: La Mejor De Todas
description: and fetch your Markdown, JSON, YAML and CSV files through a MongoDB like API, acting as a Git-based Headless CMS.
image: 'https://i.ib.co/HgwqGW/1.jpg'
tags: ['VueJS', 'Nuxt', 'Instagram']
published: true
category: Instagram
date: '2025-03-01'

Getting started

Empower your NuxtJS application with @nuxtjs/content module: write in a content/ directory and fetch your Markdown, JSON, YAML and CSV files through a MongoDB like API, acting as a Git-based Headless CMS.

Writing content

Learn how to write your content/, supporting Markdown, YAML, CSV and JSON: https://content.nuxtjs.org/writing.

Fetching content

Learn how to fetch your content with $content: https://content.nuxtjs.org/fetching.

Displaying content

Learn how to display your Markdown content with the <nuxt-content> component directly in your template: https://content.nuxtjs.org/displaying.

image

`

[farnabaz]

This is indeed an SQL restriction, You can use limit separately, but if you use skip you need to define limit too.

About the array search, IN is not what you expect. You can use LIKE operator to match the tag

Checkout #2960 (comment)

Closing this to followup in #2960