nuxt/content queryCollection not returning results when using .order()

Hey all - I'm using Nuxt Content for the first time and loving it but I've hit an issue with trying to order results from the queryCollection(). Here's my .md file frontmatter:

---
title: test post 2
date: 2025-01-01
---

Test!

---
title: test post 2
date: 2025-01-01
---

Test!

and i'm trying to query it like so:

return queryCollection('posts')
    .order('date', 'DESC')
    .select('path', 'title', 'date')
    .all()

return queryCollection('posts')
    .order('date', 'DESC')
    .select('path', 'title', 'date')
    .all()

Which isn't returning any results. But, if I take away the

date

date

part:

return queryCollection('posts')
    //.order('date', 'DESC')
    .select('path', 'title', /*'date'*/)
    .all()

return queryCollection('posts')
    //.order('date', 'DESC')
    .select('path', 'title', /*'date'*/)
    .all()

it does successfully return the content. I do see the following error in the logs for

npm run dev

npm run dev

 ERROR  [nuxt] [request error] [unhandled] [500] no such column: "date" - should this be a string literal in single-quotes?

 ERROR  [nuxt] [request error] [unhandled] [500] no such column: "date" - should this be a string literal in single-quotes?

but I'm not really sure what to do with it. I've scanned the nuxt/content docs and AFAIK I'm doing this correctly.

Any help is appreciated!

Nuxt•14mo ago•

4 replies

Whitey

nuxt/content queryCollection not returning results when using .order()

Hey all - I'm using Nuxt Content for the first time and loving it but I've hit an issue with trying to order results from the queryCollection(). Here's my .md file frontmatter:

---
title: test post 2
date: 2025-01-01
---

Test!

---
title: test post 2
date: 2025-01-01
---

Test!

and i'm trying to query it like so:

return queryCollection('posts')
    .order('date', 'DESC')
    .select('path', 'title', 'date')
    .all()

return queryCollection('posts')
    .order('date', 'DESC')
    .select('path', 'title', 'date')
    .all()

Which isn't returning any results. But, if I take away the

date

date

part:

return queryCollection('posts')
    //.order('date', 'DESC')
    .select('path', 'title', /*'date'*/)
    .all()

return queryCollection('posts')
    //.order('date', 'DESC')
    .select('path', 'title', /*'date'*/)
    .all()

it does successfully return the content. I do see the following error in the logs for

npm run dev

npm run dev

 ERROR  [nuxt] [request error] [unhandled] [500] no such column: "date" - should this be a string literal in single-quotes?

 ERROR  [nuxt] [request error] [unhandled] [500] no such column: "date" - should this be a string literal in single-quotes?

but I'm not really sure what to do with it. I've scanned the nuxt/content docs and AFAIK I'm doing this correctly.

Any help is appreciated!

nuxt/content queryCollection not returning results when using .order()

Similar Threads

nuxt/content queryCollection not returning results when using .order()

Similar Threads

Similar Threads

Similar Threads