Database.where()

Gets a Set of Database collection documents that match a provided predicate.

Signature

Database.where(predicate: () => Boolean)) => Set<Database>

Database.where(predicate: (val: DatabaseDef) => Boolean)) => Set<Database>

Description

The Database.firstWhere() method gets a Set of Database collection documents that match a provided predicate.

If the predicate is true for a Database document, the document is included in the Set. Otherwise, the document is excluded.

Scope

The Database collection only contains documents for the direct child databases of the database scoped to your authentication secret. You can’t use the Database collection to access parent, peer, or other descendant databases.

Using FQL to create or manage top-level databases is not supported.

Parameters

Parameter Type Required Description

predicate

Function

Yes

Anonymous function that compares values in each child database document and returns true for matches or false if there is no match.

predicate parameters:

Parameter Type Required Description

val

DatabaseDef

Database singleton to compare. If omitted, use dot notation to access database properties.

Return value

Type Description

Set<Database>

Set representing the databases that match the predicate function. The method returns the empty Set if there are no matching databases.

Examples

Database.where(.name.includes("child"))
{
  data: [
    {
      name: "childDB",
      coll: Database,
      ts: Time("2099-06-24T21:54:38.890Z"),
      global_id: "ysjpykbahyyr1",
      priority: 10,
      typechecked: true
    },
    ...
  ]
}
Database.where(childDB => childDB.priority == 10)
{
  data: [
    {
      name: "childDB",
      coll: Database,
      ts: Time("2099-06-24T21:54:38.890Z"),
      typechecked: true,
      global_id: "ysjpykbahyyr1",
      priority: 10
    },
    ...
  ]
}

Is this article helpful? 

Tell Fauna how the article can be improved:
 Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!