Inputs Object Types
This reference doc is generated based on thisexample schema.
Input Object types define structured inputs that can be used as arguments in a GraphQL schema.
Data Connect generates input types to work with built in scalars and developer defined@table types.
Data Connect Defined
input Any_Filter
Query filter criteria forAny scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | Any | Match if field is exactly equal to provided value. |
eq_expr | Any_Expr | Match if field is exactly equal to the result of the provided server value expression. |
ne | Any | Match if field is not equal to provided value. |
ne_expr | Any_Expr | Match if field is not equal to the result of the provided server value expression. |
in | [Any!] | Match if field value is among the provided list of values. |
nin | [Any!] | Match if field value is not among the provided list of values. |
input Any_ListFilter
Query filter criteria for[Any!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | Any | Match if list field contains the provided value as a member. |
excludes | Any | Match if list field does not contain the provided value as a member. |
includesAll | [Any!] | Match if list field contains all of the provided values as members. |
excludesAll | [Any!] | Match if list field does not contain any of the provided values as members. |
input Any_ListUpdate
Update input of anAny list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Any!] | Append the provided list of values to the existing list. |
prepend | [Any!] | Prepend the provided list of values to the existing list. |
add | [Any!] | Append values that do not already exist to the list. |
remove | [Any!] | Remove all occurrences of each value from the list. |
input Boolean_Filter
Query filter criteria forBoolean scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | Boolean | Match if field is exactly equal to provided value. |
eq_expr | Boolean_Expr | Match if field is equal to the result of the provided expression. |
ne | Boolean | Match if field is not equal to provided value. |
ne_expr | Boolean_Expr | Match if field does not match the result of the provided expression. |
in | [Boolean!] | Match if field value is among the provided list of values. |
nin | [Boolean!] | Match if field value is not among the provided list of values. |
input Boolean_ListFilter
Query filter criteria for[Boolean!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | Boolean | Match if list field contains the provided value as a member. |
excludes | Boolean | Match if list field does not contain the provided value as a member. |
includesAll | [Boolean!] | Match if list field contains all of the provided values as members. |
excludesAll | [Boolean!] | Match if list field does not contain any of the provided values as members. |
input Boolean_ListUpdate
Update input of aBoolean list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Boolean!] | Append the provided list of values to the existing list. |
prepend | [Boolean!] | Prepend the provided list of values to the existing list. |
add | [Boolean!] | Append values that do not already exist to the list. |
remove | [Boolean!] | Remove all occurrences of each value from the list. |
input Date_Duration
| Field | Type | Description |
|---|---|---|
days | Int! | The number of days for the duration. |
weeks | Int! | The number of weeks for the duration. |
months | Int! | The number of months for the duration. |
years | Int! | The number of years for the duration. |
input Date_Filter
Conditions on aDate value.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | Match if the fieldIS NULL. |
eq | Date | Match if the field is exactly equal to the provided value. |
eq_expr | Date_Expr | Match if the field equals the provided CEL expression. |
eq_date | Date_Relative | Match if the field equals the provided relative date. |
ne | Date | Match if the field is not equal to the provided value. |
ne_expr | Date_Expr | Match if the field is not equal to the provided CEL expression. |
ne_date | Date_Relative | Match if the field is not equal to the provided relative date. |
in | [Date!] | Match if the field value is among the provided list of values. |
nin | [Date!] | Match if the field value is not among the provided list of values. |
gt | Date | Match if the field value is greater than the provided value. |
gt_expr | Date_Expr | Match if the field value is greater than the provided CEL expression. |
gt_date | Date_Relative | Match if the field value is greater than the provided relative date. |
ge | Date | Match if the field value is greater than or equal to the provided value. |
ge_expr | Date_Expr | Match if the field value is greater than or equal to the provided CEL expression. |
ge_date | Date_Relative | Match if the field value is greater than or equal to the provided relative date. |
lt | Date | Match if the field value is less than the provided value. |
lt_expr | Date_Expr | Match if the field value is less than the provided CEL expression. |
lt_date | Date_Relative | Match if the field value is less than the provided relative date. |
le | Date | Match if the field value is less than or equal to the provided value. |
le_expr | Date_Expr | Match if the field value is less than or equal to the provided CEL expression. |
le_date | Date_Relative | Match if the field value is less than or equal to the provided relative date. |
input Date_ListFilter
Conditions on aDate list.
| Field | Type | Description |
|---|---|---|
includes | Date | Match if the list contains the provided date. |
includes_expr | Date_Expr | Match if the list contains the provided date CEL expression. |
includes_date | Date_Relative | Match if the list contains the provided relative date. |
excludes | Date | Match if the list does not contain the provided date. |
excludes_expr | Date_Expr | Match if the list does not contain the provided date CEL expression. |
excludes_date | Date_Relative | Match if the list does not contain the provided relative date. |
includesAll | [Date!] | Match if the list contains all the provided dates. |
excludesAll | [Date!] | Match if the list contains none of the provided dates. |
input Date_ListUpdate
Update input of aDate list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Date!] | Append the providedDate values to the existing list. |
prepend | [Date!] | Prepend the providedDate values to the existing list. |
add | [Date!] | Append anyDate values that do not already exist to the list. |
remove | [Date!] | Remove all occurrences of eachDate from the list. |
input Date_Relative
A runtime-calculated Date value relative totoday oron.
| Field | Type | Description |
|---|---|---|
today | True | Match for today’s date. |
on | Date | A specific date for matching. |
add | Date_Duration | Add the provided duration to the base date. |
sub | Date_Duration | Subtract the provided duration from the base date. |
truncateTo | Date_Interval | Truncate the date to the provided interval. |
input Date_Update
Update input of aDate value. Only one ofinc ordec may be specified.
| Field | Type | Description |
|---|---|---|
inc | Date_Duration | Increment the field by a provided duration. |
dec | Date_Duration | Decrement the field by a provided duration. |
input Float_Filter
Query filter criteria forFloat scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | Float | Match if field is exactly equal to provided value. |
eq_expr | Float_Expr | Match if field is exactly equal to the result of the provided server value expression. |
ne | Float | Match if field is not equal to provided value. |
ne_expr | Float_Expr | Match if field is not equal to the result of the provided server value expression. |
in | [Float!] | Match if field value is among the provided list of values. |
nin | [Float!] | Match if field value is not among the provided list of values. |
gt | Float | Match if field value is greater than the provided value. |
gt_expr | Float_Expr | Match if field value is greater than the result of the provided server value expression. |
ge | Float | Match if field value is greater than or equal to the provided value. |
ge_expr | Float_Expr | Match if field value is greater than or equal to the result of the provided server value expression. |
lt | Float | Match if field value is less than the provided value. |
lt_expr | Float_Expr | Match if field value is less than the result of the provided server value expression. |
le | Float | Match if field value is less than or equal to the provided value. |
le_expr | Float_Expr | Match if field value is less than or equal to the result of the provided server value expression. |
input Float_ListFilter
Query filter criteria for[Float!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | Float | Match if list field contains the provided value as a member. |
excludes | Float | Match if list field does not contain the provided value as a member. |
includesAll | [Float!] | Match if list field contains all of the provided values as members. |
excludesAll | [Float!] | Match if list field does not contain any of the provided values as members. |
input Float_ListUpdate
Update input of aFloat list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Float!] | Append the provided list of values to the existing list. |
prepend | [Float!] | Prepend the provided list of values to the existing list. |
add | [Float!] | Append values that do not already exist to the list. |
remove | [Float!] | Remove all occurrences of each value from the list. |
input Float_Update
Update input of aFloat value. Only one ofinc ordec may be specified.
| Field | Type | Description |
|---|---|---|
inc | Float | Increment the field by a provided value. |
dec | Float | Decrement the field by a provided value. |
input Int64_Filter
Query filter criteria forInt64 scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | Int64 | Match if field is exactly equal to provided value. |
eq_expr | Int64_Expr | Match if field is exactly equal to the result of the provided server value expression. |
ne | Int64 | Match if field is not equal to provided value. |
ne_expr | Int64_Expr | Match if field is not equal to the result of the provided server value expression. |
in | [Int64!] | Match if field value is among the provided list of values. |
nin | [Int64!] | Match if field value is not among the provided list of values. |
gt | Int64 | Match if field value is greater than the provided value. |
gt_expr | Int64_Expr | Match if field value is greater than the result of the provided server value expression. |
ge | Int64 | Match if field value is greater than or equal to the provided value. |
ge_expr | Int64_Expr | Match if field value is greater than or equal to the result of the provided server value expression. |
lt | Int64 | Match if field value is less than the provided value. |
lt_expr | Int64_Expr | Match if field value is less than the result of the provided server value expression. |
le | Int64 | Match if field value is less than or equal to the provided value. |
le_expr | Int64_Expr | Match if field value is less than or equal to the result of the provided server value expression. |
input Int64_ListFilter
Query filter criteria for[Int64!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | Int64 | Match if list field contains the provided value as a member. |
excludes | Int64 | Match if list field does not contain the provided value as a member. |
includesAll | [Int64!] | Match if list field contains all of the provided values as members. |
excludesAll | [Int64!] | Match if list field does not contain any of the provided values as members. |
input Int64_ListUpdate
Update input of anInt64 list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Int64!] | Append the provided list of values to the existing list. |
prepend | [Int64!] | Prepend the provided list of values to the existing list. |
add | [Int64!] | Append values that do not already exist to the list. |
remove | [Int64!] | Remove all occurrences of each value from the list. |
input Int64_Update
Update input of anInt64 value. Only one ofinc ordec may be specified.
| Field | Type | Description |
|---|---|---|
inc | Int64 | Increment the field by a provided value. |
dec | Int64 | Decrement the field by a provided value. |
input Int_Filter
Query filter criteria forInt scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | Int | Match if field is exactly equal to provided value. |
eq_expr | Int_Expr | Match if field is exactly equal to the result of the provided server value expression. |
ne | Int | Match if field is not equal to provided value. |
ne_expr | Int_Expr | Match if field is not equal to the result of the provided server value expression. |
in | [Int!] | Match if field value is among the provided list of values. |
nin | [Int!] | Match if field value is not among the provided list of values. |
gt | Int | Match if field value is greater than the provided value. |
gt_expr | Int_Expr | Match if field value is greater than the result of the provided server value expression. |
ge | Int | Match if field value is greater than or equal to the provided value. |
ge_expr | Int_Expr | Match if field value is greater than or equal to the result of the provided server value expression. |
lt | Int | Match if field value is less than the provided value. |
lt_expr | Int_Expr | Match if field value is less than the result of the provided server value expression. |
le | Int | Match if field value is less than or equal to the provided value. |
le_expr | Int_Expr | Match if field value is less than or equal to the result of the provided server value expression. |
input Int_ListFilter
Query filter criteris for[Int!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | Int | Match if list field contains the provided value as a member. |
excludes | Int | Match if list field does not contain the provided value as a member. |
includesAll | [Int!] | Match if list field contains all of the provided values as members. |
excludesAll | [Int!] | Match if list field does not contain any of the provided values as members. |
input Int_ListUpdate
Update input of anInt list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Int!] | Append the provided list of values to the existing list. |
prepend | [Int!] | Prepend the provided list of values to the existing list. |
add | [Int!] | Append values that do not already exist to the list. |
remove | [Int!] | Remove all occurrences of each value from the list. |
input Int_Update
Update input of anInt value. Only one ofinc ordec may be specified.
| Field | Type | Description |
|---|---|---|
inc | Int | Increment the field by a provided value. |
dec | Int | Decrement the field by a provided value. |
input String_Filter
Query filter criteria forString scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | String | Match if field is exactly equal to provided value. |
eq_expr | String_Expr | Match if field is exactly equal to the result of the provided server value expression. Currently onlyauth.uid is supported as an expression. |
ne | String | Match if field is not equal to provided value. |
ne_expr | String_Expr | Match if field is not equal to the result of the provided server value expression. Currently onlyauth.uid is supported as an expression. |
in | [String!] | Match if field value is among the provided list of values. |
nin | [String!] | Match if field value is not among the provided list of values. |
gt | String | Match if field value is greater than the provided value. |
ge | String | Match if field value is greater than or equal to the provided value. |
lt | String | Match if field value is less than the provided value. |
le | String | Match if field value is less than or equal to the provided value. |
contains | String | Match if field value contains the provided value as a substring. Equivalent toLIKE '%value%' |
startsWith | String | Match if field value starts with the provided value. Equivalent toLIKE 'value%' |
endsWith | String | Match if field value ends with the provided value. Equivalent toLIKE '%value' |
pattern | String_Pattern | Match based on the provided pattern. |
input String_ListFilter
Query filter criteris for[String!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | String | Match if list field contains the provided value as a member. |
excludes | String | Match if list field does not contain the provided value as a member. |
includesAll | [String!] | Match if list field contains all of the provided values as members. |
excludesAll | [String!] | Match if list field does not contain any of the provided values as members. |
input String_ListUpdate
Update input of aString list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [String!] | Append the provided values to the existing list. |
prepend | [String!] | Prepend the provided values to the existing list. |
add | [String!] | Append values that do not already exist to the list. |
remove | [String!] | Remove all occurrences of each value from the list. |
input String_Pattern
| Field | Type | Description |
|---|---|---|
like | String | Match using LIKE semantics (https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE) |
regex | String | Match against a POSIX regular expression. |
ignoreCase | Boolean | If true, match patterns case-insensitively. |
input Timestamp_Duration
| Field | Type | Description |
|---|---|---|
milliseconds | Int! | The number of milliseconds for the duration. |
seconds | Int! | The number of seconds for the duration. |
minutes | Int! | The number of minutes for the duration. |
hours | Int! | The number of hours for the duration. |
days | Int! | The number of days for the duration. |
weeks | Int! | The number of weeks for the duration. |
months | Int! | The number of months for the duration. |
years | Int! | The number of years for the duration. |
input Timestamp_Filter
Conditions on aTimestamp value.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | Match if the fieldIS NULL. |
eq | Timestamp | Match if the field is exactly equal to the provided value. |
eq_expr | Timestamp_Expr | Match if the field equals the provided CEL expression. |
eq_time | Timestamp_Relative | Match if the field equals the provided relative time. |
ne | Timestamp | Match if the field is not equal to the provided value. |
ne_expr | Timestamp_Expr | Match if the field is not equal to the provided CEL expression. |
ne_time | Timestamp_Relative | Match if the field is not equal to the provided relative time. |
in | [Timestamp!] | Match if the field value is among the provided list of values. |
nin | [Timestamp!] | Match if the field value is not among the provided list of values. |
gt | Timestamp | Match if the field value is greater than the provided value. |
gt_expr | Timestamp_Expr | Match if the field value is greater than the provided CEL expression. |
gt_time | Timestamp_Relative | Match if the field value is greater than the provided relative time. |
ge | Timestamp | Match if the field value is greater than or equal to the provided value. |
ge_expr | Timestamp_Expr | Match if the field value is greater than or equal to the provided CEL expression. |
ge_time | Timestamp_Relative | Match if the field value is greater than or equal to the provided relative time. |
lt | Timestamp | Match if the field value is less than the provided value. |
lt_expr | Timestamp_Expr | Match if the field value is less than the provided CEL expression. |
lt_time | Timestamp_Relative | Match if the field value is less than the provided relative time. |
le | Timestamp | Match if the field value is less than or equal to the provided value. |
le_expr | Timestamp_Expr | Match if the field value is less than or equal to the provided CEL expression. |
le_time | Timestamp_Relative | Match if the field value is less than or equal to the provided relative time. |
input Timestamp_ListFilter
Conditions on aTimestamp list.
| Field | Type | Description |
|---|---|---|
includes | Timestamp | Match if the list contains the provided timestamp. |
includes_expr | Timestamp_Expr | Match if the list contains the provided timestamp CEL expression. |
includes_time | Timestamp_Relative | Match if the list contains the provided relative timestamp. |
excludes | Timestamp | Match if the list does not contain the provided timestamp. |
excludes_expr | Timestamp_Expr | Match if the list does not contain the provided timestamp CEL expression. |
excludes_time | Timestamp_Relative | Match if the list does not contain the provided relative timestamp. |
includesAll | [Timestamp!] | Match if the list contains all the provided timestamps. |
excludesAll | [Timestamp!] | Match if the list contains none of the provided timestamps. |
input Timestamp_ListUpdate
Update input of anTimestamp list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [Timestamp!] | Append the providedTimestamp values to the existing list. |
prepend | [Timestamp!] | Prepend the providedTimestamp values to the existing list. |
add | [Timestamp!] | Append anyTimestamp values that do not already exist to the list. |
remove | [Timestamp!] | Remove all occurrences of eachTimestamp from the list. |
input Timestamp_Relative
A runtime-calculatedTimestamp value relative tonow orat.
| Field | Type | Description |
|---|---|---|
now | True | Match for the current time. |
at | Timestamp | A specific timestamp for matching. |
add | Timestamp_Duration | Add the provided duration to the base timestamp. |
sub | Timestamp_Duration | Subtract the provided duration from the base timestamp. |
truncateTo | Timestamp_Interval | Truncate the timestamp to the provided interval. |
input Timestamp_Update
Update input of aTimestamp value. Only one ofinc ordec may be specified.
| Field | Type | Description |
|---|---|---|
inc | Timestamp_Duration | Increment the field by a provided duration. |
dec | Timestamp_Duration | Decrement the field by a provided duration. |
input UUID_Filter
Query filter criteria forUUID scalar fields.
| Field | Type | Description |
|---|---|---|
isNull | Boolean | When true, match if fieldIS NULL. When false, match if field isNOT NULL. |
eq | UUID | Match if field is exactly equal to provided value. |
eq_expr | UUID_Expr | Match if field is exactly equal to the result of the provided server value expression. |
ne | UUID | Match if field is not equal to provided value. |
ne_expr | UUID_Expr | Match if field is not equal to the result of the provided server value expression. |
in | [UUID!] | Match if field value is among the provided list of values. |
nin | [UUID!] | Match if field value is not among the provided list of values. |
input UUID_ListFilter
Query filter criteris for[UUID!] scalar fields.
| Field | Type | Description |
|---|---|---|
includes | UUID | Match if list field contains the provided value as a member. |
excludes | UUID | Match if list field does not contain the provided value as a member. |
includesAll | [UUID!] | Match if list field contains all of the provided values as members. |
excludesAll | [UUID!] | Match if list field does not contain any of the provided values as members. |
input UUID_ListUpdate
Update input of anID list value. Only one ofappend,prepend,add, orremove may be specified.
| Field | Type | Description |
|---|---|---|
append | [UUID!] | Append the provided UUIDs to the existing list. |
prepend | [UUID!] | Prepend the provided UUIDs to the existing list. |
add | [UUID!] | Append values that do not already exist to the list. |
remove | [UUID!] | Remove all occurrences of each value from the list. |
input Vector_Embed
Create a vector embedding of text using the given model on Vertex AI.
Cloud SQL for Postgresql natively integrates withVertex AI Text embeddings APIto effectively generate text embeddings.
If you usesVector in your schema, Firebase Data Connect automatically installspgvector andgoogle_ml_integrationPostgres extensions in your Cloud SQL database.
Given a Post table with aVector embedding field.
typePost@table{content:String!contentEmbedding:Vector@col(size:768)}NOTE: All natively supportedVector_Embed_Model generates vector of length768.
Example: Insert embedding
mutationCreatePost($content:String!){post_insert(data:{content:$content,contentEmbedding_embed:{model:"textembedding-gecko@003",text:$content},})}Example: Vector similarity Search
querySearchPost($query:String!){posts_contentEmbedding_similarity(compare_embed:{model:"textembedding-gecko@003",text:$query}){idcontent}}| Field | Type | Description |
|---|---|---|
model | Vector_Embed_Model! | The model to use for vector embedding. Recommend the latest stable model:textembedding-gecko@003. |
text | String! | The text to generate the vector embedding from. |
input Vector_Filter
Conditions on a Vector value.
| Field | Type | Description |
|---|---|---|
eq | Vector | Match if the field is exactly equal to the provided vector. |
ne | Vector | Match if the field is not equal to the provided vector. |
in | [Vector!] | Match if the field value is among the provided list of vectors. |
nin | [Vector!] | Match if the field value is not among the provided list of vectors. |
isNull | Boolean | Match if the field isNULL. |
input Vector_ListFilter
| Field | Type | Description |
|---|---|---|
includes | Vector | Match if the list includes the supplied vector. |
excludes | Vector | Match if the list does not include the supplied vector. |
includesAll | [Vector!] | Match if the list contains all the provided vectors. |
excludesAll | [Vector!] | Match if the list contains none of the provided vectors. |
Data Connect Generated
input MainTable_Data
✨ Generated data input type for table 'MainTable'. It includes all necessary fields for creating or upserting rows into table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldMainTable.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldMainTable.id of typeUUID!) |
anyArray | [Any!] | ✨ Generated from FieldMainTable.anyArray of type[Any] |
anyArray_update | [Any_ListUpdate!] | ✨_update server value variant ofanyArray (✨ Generated from FieldMainTable.anyArray of type[Any]) |
anyField | Any | ✨ Generated from FieldMainTable.anyField of typeAny |
anyField_expr | Any_Expr | ✨_expr server value variant ofanyField (✨ Generated from FieldMainTable.anyField of typeAny) |
booleanArray | [Boolean!] | ✨ Generated from FieldMainTable.booleanArray of type[Boolean] |
booleanArray_update | [Boolean_ListUpdate!] | ✨_update server value variant ofbooleanArray (✨ Generated from FieldMainTable.booleanArray of type[Boolean]) |
booleanField | Boolean | ✨ Generated from FieldMainTable.booleanField of typeBoolean |
booleanField_expr | Boolean_Expr | ✨_expr server value variant ofbooleanField (✨ Generated from FieldMainTable.booleanField of typeBoolean) |
dateArray | [Date!] | ✨ Generated from FieldMainTable.dateArray of type[Date] |
dateArray_update | [Date_ListUpdate!] | ✨_update server value variant ofdateArray (✨ Generated from FieldMainTable.dateArray of type[Date]) |
dateField | Date | ✨ Generated from FieldMainTable.dateField of typeDate |
dateField_expr | Date_Expr | ✨_expr server value variant ofdateField (✨ Generated from FieldMainTable.dateField of typeDate) |
dateField_date | Date_Relative | ✨_date server value variant ofdateField (✨ Generated from FieldMainTable.dateField of typeDate) |
dateField_update | [Date_Update!] | ✨_update server value variant ofdateField (✨ Generated from FieldMainTable.dateField of typeDate) |
floatArray | [Float!] | ✨ Generated from FieldMainTable.floatArray of type[Float] |
floatArray_update | [Float_ListUpdate!] | ✨_update server value variant offloatArray (✨ Generated from FieldMainTable.floatArray of type[Float]) |
floatField | Float | ✨ Generated from FieldMainTable.floatField of typeFloat |
floatField_expr | Float_Expr | ✨_expr server value variant offloatField (✨ Generated from FieldMainTable.floatField of typeFloat) |
floatField_update | [Float_Update!] | ✨_update server value variant offloatField (✨ Generated from FieldMainTable.floatField of typeFloat) |
int64Array | [Int64!] | ✨ Generated from FieldMainTable.int64Array of type[Int64] |
int64Array_update | [Int64_ListUpdate!] | ✨_update server value variant ofint64Array (✨ Generated from FieldMainTable.int64Array of type[Int64]) |
int64Field | Int64 | ✨ Generated from FieldMainTable.int64Field of typeInt64 |
int64Field_expr | Int64_Expr | ✨_expr server value variant ofint64Field (✨ Generated from FieldMainTable.int64Field of typeInt64) |
int64Field_update | [Int64_Update!] | ✨_update server value variant ofint64Field (✨ Generated from FieldMainTable.int64Field of typeInt64) |
intArray | [Int!] | ✨ Generated from FieldMainTable.intArray of type[Int] |
intArray_update | [Int_ListUpdate!] | ✨_update server value variant ofintArray (✨ Generated from FieldMainTable.intArray of type[Int]) |
intField | Int | ✨ Generated from FieldMainTable.intField of typeInt |
intField_expr | Int_Expr | ✨_expr server value variant ofintField (✨ Generated from FieldMainTable.intField of typeInt) |
intField_update | [Int_Update!] | ✨_update server value variant ofintField (✨ Generated from FieldMainTable.intField of typeInt) |
stringArray | [String!] | ✨ Generated from FieldMainTable.stringArray of type[String] |
stringArray_update | [String_ListUpdate!] | ✨_update server value variant ofstringArray (✨ Generated from FieldMainTable.stringArray of type[String]) |
stringField | String | ✨ Generated from FieldMainTable.stringField of typeString |
stringField_expr | String_Expr | ✨_expr server value variant ofstringField (✨ Generated from FieldMainTable.stringField of typeString) |
timestampArray | [Timestamp!] | ✨ Generated from FieldMainTable.timestampArray of type[Timestamp] |
timestampArray_update | [Timestamp_ListUpdate!] | ✨_update server value variant oftimestampArray (✨ Generated from FieldMainTable.timestampArray of type[Timestamp]) |
timestampField | Timestamp | ✨ Generated from FieldMainTable.timestampField of typeTimestamp |
timestampField_expr | Timestamp_Expr | ✨_expr server value variant oftimestampField (✨ Generated from FieldMainTable.timestampField of typeTimestamp) |
timestampField_time | Timestamp_Relative | ✨_time server value variant oftimestampField (✨ Generated from FieldMainTable.timestampField of typeTimestamp) |
timestampField_update | [Timestamp_Update!] | ✨_update server value variant oftimestampField (✨ Generated from FieldMainTable.timestampField of typeTimestamp) |
uuidArray | [UUID!] | ✨ Generated from FieldMainTable.uuidArray of type[UUID] |
uuidArray_update | [UUID_ListUpdate!] | ✨_update server value variant ofuuidArray (✨ Generated from FieldMainTable.uuidArray of type[UUID]) |
uuidField | UUID | ✨ Generated from FieldMainTable.uuidField of typeUUID |
uuidField_expr | UUID_Expr | ✨_expr server value variant ofuuidField (✨ Generated from FieldMainTable.uuidField of typeUUID) |
vectorField | Vector | ✨ Generated from FieldMainTable.vectorField of typeVector |
vectorField_embed | Vector_Embed | ✨_embed server value variant ofvectorField (✨ Generated from FieldMainTable.vectorField of typeVector) |
input MainTable_Filter
✨ Generated filter input type for table 'MainTable'. This input allows filtering objects using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [MainTable_Filter!] | Apply multiple filter conditions usingAND logic. |
_or | [MainTable_Filter!] | Apply multiple filter conditions usingOR logic. |
_not | MainTable_Filter | Negate the result of the provided filter condition. |
id | UUID_Filter | ✨ Generated from FieldMainTable.id of typeUUID! |
anyArray | Any_ListFilter | ✨ Generated from FieldMainTable.anyArray of type[Any] |
anyField | Any_Filter | ✨ Generated from FieldMainTable.anyField of typeAny |
booleanArray | Boolean_ListFilter | ✨ Generated from FieldMainTable.booleanArray of type[Boolean] |
booleanField | Boolean_Filter | ✨ Generated from FieldMainTable.booleanField of typeBoolean |
dateArray | Date_ListFilter | ✨ Generated from FieldMainTable.dateArray of type[Date] |
dateField | Date_Filter | ✨ Generated from FieldMainTable.dateField of typeDate |
floatArray | Float_ListFilter | ✨ Generated from FieldMainTable.floatArray of type[Float] |
floatField | Float_Filter | ✨ Generated from FieldMainTable.floatField of typeFloat |
int64Array | Int64_ListFilter | ✨ Generated from FieldMainTable.int64Array of type[Int64] |
int64Field | Int64_Filter | ✨ Generated from FieldMainTable.int64Field of typeInt64 |
intArray | Int_ListFilter | ✨ Generated from FieldMainTable.intArray of type[Int] |
intField | Int_Filter | ✨ Generated from FieldMainTable.intField of typeInt |
stringArray | String_ListFilter | ✨ Generated from FieldMainTable.stringArray of type[String] |
stringField | String_Filter | ✨ Generated from FieldMainTable.stringField of typeString |
timestampArray | Timestamp_ListFilter | ✨ Generated from FieldMainTable.timestampArray of type[Timestamp] |
timestampField | Timestamp_Filter | ✨ Generated from FieldMainTable.timestampField of typeTimestamp |
uuidArray | UUID_ListFilter | ✨ Generated from FieldMainTable.uuidArray of type[UUID] |
uuidField | UUID_Filter | ✨ Generated from FieldMainTable.uuidField of typeUUID |
vectorField | Vector_Filter | ✨ Generated from FieldMainTable.vectorField of typeVector |
manyToManyJoinTables_on_left | ManyToManyJoinTable_ListFilter | ✨ Generated from FieldMainTable.manyToManyJoinTables_on_left of type[ManyToManyJoinTable!]! |
manyToManyJoinTables_on_right | ManyToManyJoinTable_ListFilter | ✨ Generated from FieldMainTable.manyToManyJoinTables_on_right of type[ManyToManyJoinTable!]! |
manyToOneExamples_on_main | ManyToOneExample_ListFilter | ✨ Generated from FieldMainTable.manyToOneExamples_on_main of type[ManyToOneExample!]! |
oneToOneExample_on_main | OneToOneExample_Filter | ✨ Generated from FieldMainTable.oneToOneExample_on_main of typeOneToOneExample |
mainTables_via_ManyToManyJoinTable_on_left | MainTable_ListFilter | ✨ Generated from FieldMainTable.mainTables_via_ManyToManyJoinTable_on_left of type[MainTable!]! |
mainTables_via_ManyToManyJoinTable_on_right | MainTable_ListFilter | ✨ Generated from FieldMainTable.mainTables_via_ManyToManyJoinTable_on_right of type[MainTable!]! |
input MainTable_FirstRow
✨ Generated first-row input type for table 'MainTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.
| Field | Type | Description |
|---|---|---|
where | MainTable_Filter | Filters rows based on the specified conditions. |
orderBy | [MainTable_Order!] | Order the result by the specified fields. |
input MainTable_Having
✨ Generated having input type for table 'MainTable'. This input allows you to filter groups during aggregate queries using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [MainTable_Having!] | Apply multiple Having conditions usingAND logic. |
_or | [MainTable_Having!] | Apply multiple Having conditions usingOR logic. |
_not | MainTable_Having | Negate the result of the provided Having condition. |
_distinct | Boolean | Whether to apply DISTINCT to the aggregate function. |
_count | Int_Filter | ✨ Generated from FieldMainTable._count of typeInt! |
anyField_count | Int_Filter | ✨ Generated from FieldMainTable.anyField_count of typeInt! |
booleanField_count | Int_Filter | ✨ Generated from FieldMainTable.booleanField_count of typeInt! |
dateField_count | Int_Filter | ✨ Generated from FieldMainTable.dateField_count of typeInt! |
floatField_count | Int_Filter | ✨ Generated from FieldMainTable.floatField_count of typeInt! |
id_count | Int_Filter | ✨ Generated from FieldMainTable.id_count of typeInt! |
int64Field_count | Int_Filter | ✨ Generated from FieldMainTable.int64Field_count of typeInt! |
intField_count | Int_Filter | ✨ Generated from FieldMainTable.intField_count of typeInt! |
stringField_count | Int_Filter | ✨ Generated from FieldMainTable.stringField_count of typeInt! |
timestampField_count | Int_Filter | ✨ Generated from FieldMainTable.timestampField_count of typeInt! |
uuidField_count | Int_Filter | ✨ Generated from FieldMainTable.uuidField_count of typeInt! |
vectorField_count | Int_Filter | ✨ Generated from FieldMainTable.vectorField_count of typeInt! |
floatField_sum | Float_Filter | ✨ Generated from FieldMainTable.floatField_sum of typeFloat |
int64Field_sum | Int64_Filter | ✨ Generated from FieldMainTable.int64Field_sum of typeInt64 |
intField_sum | Int_Filter | ✨ Generated from FieldMainTable.intField_sum of typeInt |
floatField_avg | Float_Filter | ✨ Generated from FieldMainTable.floatField_avg of typeFloat |
int64Field_avg | Float_Filter | ✨ Generated from FieldMainTable.int64Field_avg of typeFloat |
intField_avg | Float_Filter | ✨ Generated from FieldMainTable.intField_avg of typeFloat |
anyField_min | Any_Filter | ✨ Generated from FieldMainTable.anyField_min of typeAny |
dateField_min | Date_Filter | ✨ Generated from FieldMainTable.dateField_min of typeDate |
floatField_min | Float_Filter | ✨ Generated from FieldMainTable.floatField_min of typeFloat |
int64Field_min | Int64_Filter | ✨ Generated from FieldMainTable.int64Field_min of typeInt64 |
intField_min | Int_Filter | ✨ Generated from FieldMainTable.intField_min of typeInt |
timestampField_min | Timestamp_Filter | ✨ Generated from FieldMainTable.timestampField_min of typeTimestamp |
anyField_max | Any_Filter | ✨ Generated from FieldMainTable.anyField_max of typeAny |
dateField_max | Date_Filter | ✨ Generated from FieldMainTable.dateField_max of typeDate |
floatField_max | Float_Filter | ✨ Generated from FieldMainTable.floatField_max of typeFloat |
int64Field_max | Int64_Filter | ✨ Generated from FieldMainTable.int64Field_max of typeInt64 |
intField_max | Int_Filter | ✨ Generated from FieldMainTable.intField_max of typeInt |
timestampField_max | Timestamp_Filter | ✨ Generated from FieldMainTable.timestampField_max of typeTimestamp |
input MainTable_Key
✨ Generated key input type for table 'MainTable'. It represents the primary key fields used to uniquely identify a row in the table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldMainTable.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldMainTable.id of typeUUID!) |
input MainTable_ListFilter
✨ Generated list filter input type for table 'MainTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.
| Field | Type | Description |
|---|---|---|
count | Int_Filter | The desired number of objects that match the condition (defaults to at least one). |
exist | MainTable_Filter | Condition of the related objects to filter for. |
input MainTable_Order
✨ Generated order input type for table 'MainTable'. This input defines the sorting order of rows in query results based on one or more fields.
| Field | Type | Description |
|---|---|---|
id | OrderDirection | ✨ Generated from FieldMainTable.id of typeUUID! |
anyField | OrderDirection | ✨ Generated from FieldMainTable.anyField of typeAny |
booleanField | OrderDirection | ✨ Generated from FieldMainTable.booleanField of typeBoolean |
dateField | OrderDirection | ✨ Generated from FieldMainTable.dateField of typeDate |
floatField | OrderDirection | ✨ Generated from FieldMainTable.floatField of typeFloat |
int64Field | OrderDirection | ✨ Generated from FieldMainTable.int64Field of typeInt64 |
intField | OrderDirection | ✨ Generated from FieldMainTable.intField of typeInt |
stringField | OrderDirection | ✨ Generated from FieldMainTable.stringField of typeString |
timestampField | OrderDirection | ✨ Generated from FieldMainTable.timestampField of typeTimestamp |
uuidField | OrderDirection | ✨ Generated from FieldMainTable.uuidField of typeUUID |
vectorField | OrderDirection | ✨ Generated from FieldMainTable.vectorField of typeVector |
_count | OrderDirection | ✨ Generated from FieldMainTable._count of typeInt! |
anyField_count | OrderDirection | ✨ Generated from FieldMainTable.anyField_count of typeInt! |
booleanField_count | OrderDirection | ✨ Generated from FieldMainTable.booleanField_count of typeInt! |
dateField_count | OrderDirection | ✨ Generated from FieldMainTable.dateField_count of typeInt! |
floatField_count | OrderDirection | ✨ Generated from FieldMainTable.floatField_count of typeInt! |
id_count | OrderDirection | ✨ Generated from FieldMainTable.id_count of typeInt! |
int64Field_count | OrderDirection | ✨ Generated from FieldMainTable.int64Field_count of typeInt! |
intField_count | OrderDirection | ✨ Generated from FieldMainTable.intField_count of typeInt! |
stringField_count | OrderDirection | ✨ Generated from FieldMainTable.stringField_count of typeInt! |
timestampField_count | OrderDirection | ✨ Generated from FieldMainTable.timestampField_count of typeInt! |
uuidField_count | OrderDirection | ✨ Generated from FieldMainTable.uuidField_count of typeInt! |
vectorField_count | OrderDirection | ✨ Generated from FieldMainTable.vectorField_count of typeInt! |
floatField_sum | OrderDirection | ✨ Generated from FieldMainTable.floatField_sum of typeFloat |
int64Field_sum | OrderDirection | ✨ Generated from FieldMainTable.int64Field_sum of typeInt64 |
intField_sum | OrderDirection | ✨ Generated from FieldMainTable.intField_sum of typeInt |
floatField_avg | OrderDirection | ✨ Generated from FieldMainTable.floatField_avg of typeFloat |
int64Field_avg | OrderDirection | ✨ Generated from FieldMainTable.int64Field_avg of typeFloat |
intField_avg | OrderDirection | ✨ Generated from FieldMainTable.intField_avg of typeFloat |
anyField_min | OrderDirection | ✨ Generated from FieldMainTable.anyField_min of typeAny |
dateField_min | OrderDirection | ✨ Generated from FieldMainTable.dateField_min of typeDate |
floatField_min | OrderDirection | ✨ Generated from FieldMainTable.floatField_min of typeFloat |
int64Field_min | OrderDirection | ✨ Generated from FieldMainTable.int64Field_min of typeInt64 |
intField_min | OrderDirection | ✨ Generated from FieldMainTable.intField_min of typeInt |
timestampField_min | OrderDirection | ✨ Generated from FieldMainTable.timestampField_min of typeTimestamp |
anyField_max | OrderDirection | ✨ Generated from FieldMainTable.anyField_max of typeAny |
dateField_max | OrderDirection | ✨ Generated from FieldMainTable.dateField_max of typeDate |
floatField_max | OrderDirection | ✨ Generated from FieldMainTable.floatField_max of typeFloat |
int64Field_max | OrderDirection | ✨ Generated from FieldMainTable.int64Field_max of typeInt64 |
intField_max | OrderDirection | ✨ Generated from FieldMainTable.intField_max of typeInt |
timestampField_max | OrderDirection | ✨ Generated from FieldMainTable.timestampField_max of typeTimestamp |
input ManyToManyJoinTable_Data
✨ Generated data input type for table 'ManyToManyJoinTable'. It includes all necessary fields for creating or upserting rows into table.
| Field | Type | Description |
|---|---|---|
leftId | UUID | ✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID! |
leftId_expr | UUID_Expr | ✨_expr server value variant ofleftId (✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID!) |
rightId | UUID | ✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID! |
rightId_expr | UUID_Expr | ✨_expr server value variant ofrightId (✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID!) |
left | MainTable_Key | ✨ Generated from FieldManyToManyJoinTable.left of typeMainTable! |
right | MainTable_Key | ✨ Generated from FieldManyToManyJoinTable.right of typeMainTable! |
input ManyToManyJoinTable_Filter
✨ Generated filter input type for table 'ManyToManyJoinTable'. This input allows filtering objects using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [ManyToManyJoinTable_Filter!] | Apply multiple filter conditions usingAND logic. |
_or | [ManyToManyJoinTable_Filter!] | Apply multiple filter conditions usingOR logic. |
_not | ManyToManyJoinTable_Filter | Negate the result of the provided filter condition. |
leftId | UUID_Filter | ✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID! |
rightId | UUID_Filter | ✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID! |
left | MainTable_Filter | ✨ Generated from FieldManyToManyJoinTable.left of typeMainTable! |
right | MainTable_Filter | ✨ Generated from FieldManyToManyJoinTable.right of typeMainTable! |
input ManyToManyJoinTable_FirstRow
✨ Generated first-row input type for table 'ManyToManyJoinTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.
| Field | Type | Description |
|---|---|---|
where | ManyToManyJoinTable_Filter | Filters rows based on the specified conditions. |
orderBy | [ManyToManyJoinTable_Order!] | Order the result by the specified fields. |
input ManyToManyJoinTable_Having
✨ Generated having input type for table 'ManyToManyJoinTable'. This input allows you to filter groups during aggregate queries using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [ManyToManyJoinTable_Having!] | Apply multiple Having conditions usingAND logic. |
_or | [ManyToManyJoinTable_Having!] | Apply multiple Having conditions usingOR logic. |
_not | ManyToManyJoinTable_Having | Negate the result of the provided Having condition. |
_distinct | Boolean | Whether to apply DISTINCT to the aggregate function. |
_count | Int_Filter | ✨ Generated from FieldManyToManyJoinTable._count of typeInt! |
leftId_count | Int_Filter | ✨ Generated from FieldManyToManyJoinTable.leftId_count of typeInt! |
rightId_count | Int_Filter | ✨ Generated from FieldManyToManyJoinTable.rightId_count of typeInt! |
input ManyToManyJoinTable_Key
✨ Generated key input type for table 'ManyToManyJoinTable'. It represents the primary key fields used to uniquely identify a row in the table.
| Field | Type | Description |
|---|---|---|
leftId | UUID | ✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID! |
leftId_expr | UUID_Expr | ✨_expr server value variant ofleftId (✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID!) |
rightId | UUID | ✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID! |
rightId_expr | UUID_Expr | ✨_expr server value variant ofrightId (✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID!) |
input ManyToManyJoinTable_ListFilter
✨ Generated list filter input type for table 'ManyToManyJoinTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.
| Field | Type | Description |
|---|---|---|
count | Int_Filter | The desired number of objects that match the condition (defaults to at least one). |
exist | ManyToManyJoinTable_Filter | Condition of the related objects to filter for. |
input ManyToManyJoinTable_Order
✨ Generated order input type for table 'ManyToManyJoinTable'. This input defines the sorting order of rows in query results based on one or more fields.
| Field | Type | Description |
|---|---|---|
leftId | OrderDirection | ✨ Generated from FieldManyToManyJoinTable.leftId of typeUUID! |
rightId | OrderDirection | ✨ Generated from FieldManyToManyJoinTable.rightId of typeUUID! |
left | MainTable_Order | ✨ Generated from FieldManyToManyJoinTable.left of typeMainTable! |
right | MainTable_Order | ✨ Generated from FieldManyToManyJoinTable.right of typeMainTable! |
_count | OrderDirection | ✨ Generated from FieldManyToManyJoinTable._count of typeInt! |
leftId_count | OrderDirection | ✨ Generated from FieldManyToManyJoinTable.leftId_count of typeInt! |
rightId_count | OrderDirection | ✨ Generated from FieldManyToManyJoinTable.rightId_count of typeInt! |
input ManyToOneExample_Data
✨ Generated data input type for table 'ManyToOneExample'. It includes all necessary fields for creating or upserting rows into table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldManyToOneExample.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldManyToOneExample.id of typeUUID!) |
mainId | UUID | ✨ Generated from FieldManyToOneExample.mainId of typeUUID! |
mainId_expr | UUID_Expr | ✨_expr server value variant ofmainId (✨ Generated from FieldManyToOneExample.mainId of typeUUID!) |
main | MainTable_Key | ✨ Generated from FieldManyToOneExample.main of typeMainTable! |
someField | Any | ✨ Generated from FieldManyToOneExample.someField of typeAny |
someField_expr | Any_Expr | ✨_expr server value variant ofsomeField (✨ Generated from FieldManyToOneExample.someField of typeAny) |
input ManyToOneExample_Filter
✨ Generated filter input type for table 'ManyToOneExample'. This input allows filtering objects using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [ManyToOneExample_Filter!] | Apply multiple filter conditions usingAND logic. |
_or | [ManyToOneExample_Filter!] | Apply multiple filter conditions usingOR logic. |
_not | ManyToOneExample_Filter | Negate the result of the provided filter condition. |
id | UUID_Filter | ✨ Generated from FieldManyToOneExample.id of typeUUID! |
mainId | UUID_Filter | ✨ Generated from FieldManyToOneExample.mainId of typeUUID! |
main | MainTable_Filter | ✨ Generated from FieldManyToOneExample.main of typeMainTable! |
someField | Any_Filter | ✨ Generated from FieldManyToOneExample.someField of typeAny |
input ManyToOneExample_FirstRow
✨ Generated first-row input type for table 'ManyToOneExample'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.
| Field | Type | Description |
|---|---|---|
where | ManyToOneExample_Filter | Filters rows based on the specified conditions. |
orderBy | [ManyToOneExample_Order!] | Order the result by the specified fields. |
input ManyToOneExample_Having
✨ Generated having input type for table 'ManyToOneExample'. This input allows you to filter groups during aggregate queries using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [ManyToOneExample_Having!] | Apply multiple Having conditions usingAND logic. |
_or | [ManyToOneExample_Having!] | Apply multiple Having conditions usingOR logic. |
_not | ManyToOneExample_Having | Negate the result of the provided Having condition. |
_distinct | Boolean | Whether to apply DISTINCT to the aggregate function. |
_count | Int_Filter | ✨ Generated from FieldManyToOneExample._count of typeInt! |
id_count | Int_Filter | ✨ Generated from FieldManyToOneExample.id_count of typeInt! |
mainId_count | Int_Filter | ✨ Generated from FieldManyToOneExample.mainId_count of typeInt! |
someField_count | Int_Filter | ✨ Generated from FieldManyToOneExample.someField_count of typeInt! |
someField_min | Any_Filter | ✨ Generated from FieldManyToOneExample.someField_min of typeAny |
someField_max | Any_Filter | ✨ Generated from FieldManyToOneExample.someField_max of typeAny |
input ManyToOneExample_Key
✨ Generated key input type for table 'ManyToOneExample'. It represents the primary key fields used to uniquely identify a row in the table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldManyToOneExample.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldManyToOneExample.id of typeUUID!) |
input ManyToOneExample_ListFilter
✨ Generated list filter input type for table 'ManyToOneExample'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.
| Field | Type | Description |
|---|---|---|
count | Int_Filter | The desired number of objects that match the condition (defaults to at least one). |
exist | ManyToOneExample_Filter | Condition of the related objects to filter for. |
input ManyToOneExample_Order
✨ Generated order input type for table 'ManyToOneExample'. This input defines the sorting order of rows in query results based on one or more fields.
| Field | Type | Description |
|---|---|---|
id | OrderDirection | ✨ Generated from FieldManyToOneExample.id of typeUUID! |
mainId | OrderDirection | ✨ Generated from FieldManyToOneExample.mainId of typeUUID! |
main | MainTable_Order | ✨ Generated from FieldManyToOneExample.main of typeMainTable! |
someField | OrderDirection | ✨ Generated from FieldManyToOneExample.someField of typeAny |
_count | OrderDirection | ✨ Generated from FieldManyToOneExample._count of typeInt! |
id_count | OrderDirection | ✨ Generated from FieldManyToOneExample.id_count of typeInt! |
mainId_count | OrderDirection | ✨ Generated from FieldManyToOneExample.mainId_count of typeInt! |
someField_count | OrderDirection | ✨ Generated from FieldManyToOneExample.someField_count of typeInt! |
someField_min | OrderDirection | ✨ Generated from FieldManyToOneExample.someField_min of typeAny |
someField_max | OrderDirection | ✨ Generated from FieldManyToOneExample.someField_max of typeAny |
input OneToOneExample_Data
✨ Generated data input type for table 'OneToOneExample'. It includes all necessary fields for creating or upserting rows into table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldOneToOneExample.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldOneToOneExample.id of typeUUID!) |
mainId | UUID | ✨ Generated from FieldOneToOneExample.mainId of typeUUID! |
mainId_expr | UUID_Expr | ✨_expr server value variant ofmainId (✨ Generated from FieldOneToOneExample.mainId of typeUUID!) |
main | MainTable_Key | ✨ Generated from FieldOneToOneExample.main of typeMainTable! |
someField | Any | ✨ Generated from FieldOneToOneExample.someField of typeAny |
someField_expr | Any_Expr | ✨_expr server value variant ofsomeField (✨ Generated from FieldOneToOneExample.someField of typeAny) |
input OneToOneExample_Filter
✨ Generated filter input type for table 'OneToOneExample'. This input allows filtering objects using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [OneToOneExample_Filter!] | Apply multiple filter conditions usingAND logic. |
_or | [OneToOneExample_Filter!] | Apply multiple filter conditions usingOR logic. |
_not | OneToOneExample_Filter | Negate the result of the provided filter condition. |
id | UUID_Filter | ✨ Generated from FieldOneToOneExample.id of typeUUID! |
mainId | UUID_Filter | ✨ Generated from FieldOneToOneExample.mainId of typeUUID! |
main | MainTable_Filter | ✨ Generated from FieldOneToOneExample.main of typeMainTable! |
someField | Any_Filter | ✨ Generated from FieldOneToOneExample.someField of typeAny |
input OneToOneExample_FirstRow
✨ Generated first-row input type for table 'OneToOneExample'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.
| Field | Type | Description |
|---|---|---|
where | OneToOneExample_Filter | Filters rows based on the specified conditions. |
orderBy | [OneToOneExample_Order!] | Order the result by the specified fields. |
input OneToOneExample_Having
✨ Generated having input type for table 'OneToOneExample'. This input allows you to filter groups during aggregate queries using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [OneToOneExample_Having!] | Apply multiple Having conditions usingAND logic. |
_or | [OneToOneExample_Having!] | Apply multiple Having conditions usingOR logic. |
_not | OneToOneExample_Having | Negate the result of the provided Having condition. |
_distinct | Boolean | Whether to apply DISTINCT to the aggregate function. |
_count | Int_Filter | ✨ Generated from FieldOneToOneExample._count of typeInt! |
id_count | Int_Filter | ✨ Generated from FieldOneToOneExample.id_count of typeInt! |
mainId_count | Int_Filter | ✨ Generated from FieldOneToOneExample.mainId_count of typeInt! |
someField_count | Int_Filter | ✨ Generated from FieldOneToOneExample.someField_count of typeInt! |
someField_min | Any_Filter | ✨ Generated from FieldOneToOneExample.someField_min of typeAny |
someField_max | Any_Filter | ✨ Generated from FieldOneToOneExample.someField_max of typeAny |
input OneToOneExample_Key
✨ Generated key input type for table 'OneToOneExample'. It represents the primary key fields used to uniquely identify a row in the table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldOneToOneExample.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldOneToOneExample.id of typeUUID!) |
input OneToOneExample_ListFilter
✨ Generated list filter input type for table 'OneToOneExample'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.
| Field | Type | Description |
|---|---|---|
count | Int_Filter | The desired number of objects that match the condition (defaults to at least one). |
exist | OneToOneExample_Filter | Condition of the related objects to filter for. |
input OneToOneExample_Order
✨ Generated order input type for table 'OneToOneExample'. This input defines the sorting order of rows in query results based on one or more fields.
| Field | Type | Description |
|---|---|---|
id | OrderDirection | ✨ Generated from FieldOneToOneExample.id of typeUUID! |
mainId | OrderDirection | ✨ Generated from FieldOneToOneExample.mainId of typeUUID! |
main | MainTable_Order | ✨ Generated from FieldOneToOneExample.main of typeMainTable! |
someField | OrderDirection | ✨ Generated from FieldOneToOneExample.someField of typeAny |
_count | OrderDirection | ✨ Generated from FieldOneToOneExample._count of typeInt! |
id_count | OrderDirection | ✨ Generated from FieldOneToOneExample.id_count of typeInt! |
mainId_count | OrderDirection | ✨ Generated from FieldOneToOneExample.mainId_count of typeInt! |
someField_count | OrderDirection | ✨ Generated from FieldOneToOneExample.someField_count of typeInt! |
someField_min | OrderDirection | ✨ Generated from FieldOneToOneExample.someField_min of typeAny |
someField_max | OrderDirection | ✨ Generated from FieldOneToOneExample.someField_max of typeAny |
input StringTable_Data
✨ Generated data input type for table 'StringTable'. It includes all necessary fields for creating or upserting rows into table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldStringTable.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldStringTable.id of typeUUID!) |
nonNullStringArray | [String!] | ✨ Generated from FieldStringTable.nonNullStringArray of type[String!] |
nonNullStringArray_update | [String_ListUpdate!] | ✨_update server value variant ofnonNullStringArray (✨ Generated from FieldStringTable.nonNullStringArray of type[String!]) |
nonNullStringField | String | ✨ Generated from FieldStringTable.nonNullStringField of typeString! |
nonNullStringField_expr | String_Expr | ✨_expr server value variant ofnonNullStringField (✨ Generated from FieldStringTable.nonNullStringField of typeString!) |
nonNullStringNonnullArray | [String!] | ✨ Generated from FieldStringTable.nonNullStringNonnullArray of type[String!]! |
nonNullStringNonnullArray_update | [String_ListUpdate!] | ✨_update server value variant ofnonNullStringNonnullArray (✨ Generated from FieldStringTable.nonNullStringNonnullArray of type[String!]!) |
stringArray | [String!] | ✨ Generated from FieldStringTable.stringArray of type[String] |
stringArray_update | [String_ListUpdate!] | ✨_update server value variant ofstringArray (✨ Generated from FieldStringTable.stringArray of type[String]) |
stringField | String | ✨ Generated from FieldStringTable.stringField of typeString |
stringField_expr | String_Expr | ✨_expr server value variant ofstringField (✨ Generated from FieldStringTable.stringField of typeString) |
stringNonnullArray | [String!] | ✨ Generated from FieldStringTable.stringNonnullArray of type[String]! |
stringNonnullArray_update | [String_ListUpdate!] | ✨_update server value variant ofstringNonnullArray (✨ Generated from FieldStringTable.stringNonnullArray of type[String]!) |
input StringTable_Filter
✨ Generated filter input type for table 'StringTable'. This input allows filtering objects using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [StringTable_Filter!] | Apply multiple filter conditions usingAND logic. |
_or | [StringTable_Filter!] | Apply multiple filter conditions usingOR logic. |
_not | StringTable_Filter | Negate the result of the provided filter condition. |
id | UUID_Filter | ✨ Generated from FieldStringTable.id of typeUUID! |
nonNullStringArray | String_ListFilter | ✨ Generated from FieldStringTable.nonNullStringArray of type[String!] |
nonNullStringField | String_Filter | ✨ Generated from FieldStringTable.nonNullStringField of typeString! |
nonNullStringNonnullArray | String_ListFilter | ✨ Generated from FieldStringTable.nonNullStringNonnullArray of type[String!]! |
stringArray | String_ListFilter | ✨ Generated from FieldStringTable.stringArray of type[String] |
stringField | String_Filter | ✨ Generated from FieldStringTable.stringField of typeString |
stringNonnullArray | String_ListFilter | ✨ Generated from FieldStringTable.stringNonnullArray of type[String]! |
input StringTable_FirstRow
✨ Generated first-row input type for table 'StringTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.
| Field | Type | Description |
|---|---|---|
where | StringTable_Filter | Filters rows based on the specified conditions. |
orderBy | [StringTable_Order!] | Order the result by the specified fields. |
input StringTable_Having
✨ Generated having input type for table 'StringTable'. This input allows you to filter groups during aggregate queries using various conditions. Use_or,_and, and_not to compose complex filters.
| Field | Type | Description |
|---|---|---|
_and | [StringTable_Having!] | Apply multiple Having conditions usingAND logic. |
_or | [StringTable_Having!] | Apply multiple Having conditions usingOR logic. |
_not | StringTable_Having | Negate the result of the provided Having condition. |
_distinct | Boolean | Whether to apply DISTINCT to the aggregate function. |
_count | Int_Filter | ✨ Generated from FieldStringTable._count of typeInt! |
id_count | Int_Filter | ✨ Generated from FieldStringTable.id_count of typeInt! |
nonNullStringField_count | Int_Filter | ✨ Generated from FieldStringTable.nonNullStringField_count of typeInt! |
stringField_count | Int_Filter | ✨ Generated from FieldStringTable.stringField_count of typeInt! |
input StringTable_Key
✨ Generated key input type for table 'StringTable'. It represents the primary key fields used to uniquely identify a row in the table.
| Field | Type | Description |
|---|---|---|
id | UUID | ✨ Generated from FieldStringTable.id of typeUUID! |
id_expr | UUID_Expr | ✨_expr server value variant ofid (✨ Generated from FieldStringTable.id of typeUUID!) |
input StringTable_ListFilter
✨ Generated list filter input type for table 'StringTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.
| Field | Type | Description |
|---|---|---|
count | Int_Filter | The desired number of objects that match the condition (defaults to at least one). |
exist | StringTable_Filter | Condition of the related objects to filter for. |
input StringTable_Order
✨ Generated order input type for table 'StringTable'. This input defines the sorting order of rows in query results based on one or more fields.
| Field | Type | Description |
|---|---|---|
id | OrderDirection | ✨ Generated from FieldStringTable.id of typeUUID! |
nonNullStringField | OrderDirection | ✨ Generated from FieldStringTable.nonNullStringField of typeString! |
stringField | OrderDirection | ✨ Generated from FieldStringTable.stringField of typeString |
_count | OrderDirection | ✨ Generated from FieldStringTable._count of typeInt! |
id_count | OrderDirection | ✨ Generated from FieldStringTable.id_count of typeInt! |
nonNullStringField_count | OrderDirection | ✨ Generated from FieldStringTable.nonNullStringField_count of typeInt! |
stringField_count | OrderDirection | ✨ Generated from FieldStringTable.stringField_count of typeInt! |
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-01-21 UTC.