users_aggregate Query
fetch aggregated fields from the table: "users"
Arguments
#
Response
#
Returns users_aggregate !.
Example
#
query (
$distinct_on: [users_select_column!]
$limit: Int
$offset: Int
$order_by: [users_order_by!]
$where: users_bool_exp
$columns: [users_select_column!]
$distinct: Boolean
) {
users_aggregate(
distinct_on: $distinct_on
limit: $limit
offset: $offset
order_by: $order_by
where: $where
) {
aggregate {
count(columns: $columns, distinct: $distinct)
}
nodes {
id
name
rocket
timestamp
twitter
}
}
}
3
{
"distinct_on": [
"column"
],
"limit": 42,
"offset": 42,
"order_by": [
{
"id": "asc",
"name": "asc",
"rocket": "asc",
"timestamp": "asc",
"twitter": "asc"
}
],
"where": {
"_and": null,
"_not": null,
"_or": null,
"id": {
"_eq": "<an-example-of-scalar-value>",
"_gt": "<an-example-of-scalar-value>",
"_gte": "<an-example-of-scalar-value>",
"_in": [
"<an-example-of-scalar-value>"
],
"_is_null": true,
"_lt": "<an-example-of-scalar-value>",
"_lte": "<an-example-of-scalar-value>",
"_neq": "<an-example-of-scalar-value>",
"_nin": [
"<an-example-of-scalar-value>"
]
},
"name": {
"_eq": "_eq",
"_gt": "_gt",
"_gte": "_gte",
"_ilike": "_ilike",
"_in": [
"_in"
],
"_is_null": true,
"_like": "_like",
"_lt": "_lt",
"_lte": "_lte",
"_neq": "_neq",
"_nilike": "_nilike",
"_nin": [
"_nin"
],
"_nlike": "_nlike",
"_nsimilar": "_nsimilar",
"_similar": "_similar"
},
"rocket": {
"_eq": "_eq",
"_gt": "_gt",
"_gte": "_gte",
"_ilike": "_ilike",
"_in": [
"_in"
],
"_is_null": true,
"_like": "_like",
"_lt": "_lt",
"_lte": "_lte",
"_neq": "_neq",
"_nilike": "_nilike",
"_nin": [
"_nin"
],
"_nlike": "_nlike",
"_nsimilar": "_nsimilar",
"_similar": "_similar"
},
"timestamp": {
"_eq": "2022-03-06T08:23:45.000Z",
"_gt": "2022-03-06T08:23:45.000Z",
"_gte": "2022-03-06T08:23:45.000Z",
"_in": [
"2022-03-06T08:23:45.000Z"
],
"_is_null": true,
"_lt": "2022-03-06T08:23:45.000Z",
"_lte": "2022-03-06T08:23:45.000Z",
"_neq": "2022-03-06T08:23:45.000Z",
"_nin": [
"2022-03-06T08:23:45.000Z"
]
},
"twitter": {
"_eq": "_eq",
"_gt": "_gt",
"_gte": "_gte",
"_ilike": "_ilike",
"_in": [
"_in"
],
"_is_null": true,
"_like": "_like",
"_lt": "_lt",
"_lte": "_lte",
"_neq": "_neq",
"_nilike": "_nilike",
"_nin": [
"_nin"
],
"_nlike": "_nlike",
"_nsimilar": "_nsimilar",
"_similar": "_similar"
}
},
"columns": [
"column"
],
"distinct": true
}
3
{
"users_aggregate": {
"aggregate": {
"count": 42
},
"nodes": [
{
"id": "<an-example-of-scalar-value>",
"name": "A name",
"rocket": "rocket",
"timestamp": "2022-03-06T08:23:45.000Z",
"twitter": "twitter"
}
]
}
}
3
Previous
users
Next
users_by_pk