Admin Users Count
Hi. I am currently trying to get just the count of admin users. My query looks like the following:
but the response looks like the following although the docs state that the "total" in the meta data is the count after the filters:
Any insight into this would be awesome.
// Admin count query - separate optimized query just for counting
const { data: adminData } = useQuery<UsersResponse>({
queryKey: ["users-admin-count"],
queryFn: async () => {
try {
const data = await client.admin.listUsers(
{
query: {
limit: 1, // We only need the total count, not the actual users
filterField: "role",
filterOperator: "eq",
filterValue: "admin"
}
},
{
throw: true,
},
);
return data as UsersResponse;
} catch (error: any) {
console.error("Failed to fetch admin count:", error);
return { users: [], total: 0 } as UsersResponse;
}
},
// Keep the count cached for longer since it doesn't change as frequently
staleTime: 5 * 60 * 1000, // 5 minutes
});// Admin count query - separate optimized query just for counting
const { data: adminData } = useQuery<UsersResponse>({
queryKey: ["users-admin-count"],
queryFn: async () => {
try {
const data = await client.admin.listUsers(
{
query: {
limit: 1, // We only need the total count, not the actual users
filterField: "role",
filterOperator: "eq",
filterValue: "admin"
}
},
{
throw: true,
},
);
return data as UsersResponse;
} catch (error: any) {
console.error("Failed to fetch admin count:", error);
return { users: [], total: 0 } as UsersResponse;
}
},
// Keep the count cached for longer since it doesn't change as frequently
staleTime: 5 * 60 * 1000, // 5 minutes
});but the response looks like the following although the docs state that the "total" in the meta data is the count after the filters:
{
"users": [
{
"id": "****",
"name": "***",
"email": "***",
"emailVerified": ***,
"image": "***",
"createdAt": "****",
"updatedAt": "****",
"role": "admin",
"banned": null,
"banReason": null,
"banExpires": null
}
],
"total": 6,
"limit": 1
}{
"users": [
{
"id": "****",
"name": "***",
"email": "***",
"emailVerified": ***,
"image": "***",
"createdAt": "****",
"updatedAt": "****",
"role": "admin",
"banned": null,
"banReason": null,
"banExpires": null
}
],
"total": 6,
"limit": 1
}Any insight into this would be awesome.
