RecordsFilterInput

Conditions records must match. All given conditions are combined with AND; use
or for alternatives. Soft deleted records are excluded unless deleted_at is used

type RecordsFilterInput {
  created_at: DateFilter
  deleted_at: DateFilter
  external_id: StringFilter
  fulltext: Query
  id: UniqIdFilter
  or: [RecordsFilterInput!]
  properties: [PropertyFilterInput!]
  related_records: [RelatedRecordsFilterInput!]
  related_users: [RelatedUsersFilterInput!]
  table: StringFilter
  table_id: UniqIdFilter
  updated_at: DateFilter
  user_id: UniqIdFilter
}

Fields

created_at (DateFilter)

Condition on the creation time

deleted_at (DateFilter)

Condition on the soft deletion time. Using it makes soft deleted records
eligible, e.g. deleted_at: { exists: true } returns only deleted records

external_id (StringFilter)

Condition on the external id

fulltext (Query)

Full-text search using the search index. Matching records are ordered by
relevance after any given sort, and only the best matching 10,000 are
considered. Only used at the top level of the filter (ignored inside or and
related_records)

id (UniqIdFilter)

Condition on the record id

or (RecordsFilterInput)

Alternative sets of conditions: matches records meeting at least one of them,
in addition to the other conditions of this filter

properties (PropertyFilterInput)

Conditions on properties; every entry must match

related_records (RelatedRecordsFilterInput)

Matches records related to records meeting the given conditions; when several entries are given, all must match

related_users (RelatedUsersFilterInput)

Matches records related to users meeting the given conditions; when several entries are given, all must match

table (StringFilter)

Condition on the name of the table the records belong to. Name comparisons are
case sensitive. Giving the table also lets property conditions detect property types

table_id (UniqIdFilter)

Condition on the id of the table the records belong to

updated_at (DateFilter)

Condition on the last update time

user_id (UniqIdFilter)

Condition on the id of the user who owns the record