Order not working in useQuery

[ahrorbeksoft]

I am having trouble ordering inside queries

here is my query:

	const { data, isLoading } = db.useQuery({
		leadColumns: {
			$: {
				where: {
					branch: branchId,
				},
				order: {
					order: "asc",
				},
			},
		},
	} satisfies InstaQLParams<AppSchema>);

i have leadColumns namespace with order attribute which is a number type, but when add order inside the query results do not show up at all, when i remove it is fetching data

[olegkorol]

Is your order attribute indexed, @ahrorbeksoft?

i.e.

const schema = {
// ...
  order: i.number().indexed(),
// ...
}

[stopachka]

@ahrorbeksoft

Do you see any errors in the inspector, or does an error message come back from the query?

[ahrorbeksoft]

Is your order attribute indexed, @ahrorbeksoft?

i.e.

const schema = {
// ...
order: i.number().indexed(),
// ...
}

thanks, it started working after i added indexed() for order attributes. thank a lot. so for every attribute that is used inside $ object should be indexed then?