Dynamic ordering

[ozgurdemir]

I'm trying to order a GROQ query dynamically by passing an $order variable.

Hardcoding does work

const query = groq`{"BlogPosts": *[_type=='blog_post'] | order(publishedAt desc)}`;
const { data, status } = await useSanityQuery(query)

Passing a variable does not work. The ordering is just ignored and the results are returned without ordering

const query = groq`{"BlogPosts": *[_type=='blog_post'] | order($order desc)}`;
const { data, status } = await useSanityQuery(query, {
  'order': 'publishedAt',
});

The same when passing the order field as a string. This does not work:

const query = groq`{"BlogPosts": *[_type=='blog_post'] | order('publishedAt' desc)}`;
const { data, status } = await useSanityQuery(query)

Am I passing the order variable in a wrong format or is this not possible with this module?

[silvio-e]

I haven't tested your query but what jumped at me is that you are not using a template literal for the query like:

const query = groq`{"BlogPosts": *[_type=='blog_post'] | order($order desc)}`;
const { data, status } = await useSanityQuery(query, {
  'order': 'publishedAt',
});```

[ozgurdemir]

I haven't tested your query but what jumped at me is that you are not using a template literal for the query like:

const query = groq{"BlogPosts": *[_type=='blog_post'] | order($order desc)};
const { data, status } = await useSanityQuery(query, {
'order': 'publishedAt',
});```

Thx for the response. However, this was just a copy paste error. I've updated the questions to include the correct backticks.