Mutating Multiple Records Using Filters

You can update multiple table records using 8base's auto-generated GraphQL mutation operations.

In the following examples, we have a table called Posts, which contains fields and relations like title, body, author.

note

Some examples might use aliases to show side by side the use of data.id versus filter. All examples work without aliases.

Updating all post's titles published before a given day

Prefix the title of every post published before a specific date with the string "LEGACY: ".

mutation {
  postUpdateByFilter(
  data: {
    title: {
      prefix: "LEGACY: "
    }
  },
  filter: {
    publishingDate: {
      lt: "2020-06-05"
    }
  }) {
    count
    items {
      title
    }
  }
}

{
  "data": {
    "postUpdateByFilter": {
      "count": 3,
      "items": [
        {
          "title": "LEGACY: My Post"
        },
        {
          "title": "LEGACY: My Other Post"
        },
        {
          "title": "LEGACY: My Other Awesome Post"
        }
      ]
    }
  }
}

Field Type Predicates

When using the tableNameUpdateByFilter operation, different field types have different functions that can be used.

note

When running the updateByFilter operation, only one coercive method can be used at a time per field.

String

• prefix: String - Prepends a supplied string to the field's existing value.
• postfix: String - Appends a supplied string to the field's existing value.
• set: String - Sets a supplied string as the field's new value.

Example

mutation {
  postUpdateByFilter(data: { aTextTypeField: { postfix: " - ADD ME AFTER" } }) {
    items {
      aTextTypeField
    }
  }
}

Number

• add: Int - Adds a supplied Int to the field's existing value.
• sub: Int - Subtracts a supplied Int from the field's existing value.
• mult: Int - Multiply a supplied Int by the field's existing value.
• dev: Int - Divide the field's existing value by a supplied Int.
• mod: Int - Modulo the field's existing value by a supplied Int.
• set: Int - Sets a supplied Int as the field's new value.
• pow: Int - Raise the field's existing value to the exponent of a supplied Int.
• sqrt: Boolean - Set the field's existing value to its square root (use true or false)

Example

mutation {
  postUpdateByFilter(data: { aNumberTypeField: { pow: 10 } }) {
    items {
      aNumberTypeField
    }
  }
}

Date

• set: String - Sets a supplied Date as the field's new value.
• add: UpdateByFilterDatePartsInput - Adds a given number of Days, Months, Years, Hours, Minutes, Seconds, and Microseconds to the field's existing value.
• sub: UpdateByFilterDatePartsInput - Subtracts a given number of Days, Months, Years, Hours, Minutes, Seconds, and Microseconds from the field's existing value.

Example

mutation {
  postUpdateByFilter(
    data: {
      aDateTypeField: {
        add: {
          years: 1
          months: 3
          days: 20
          hours: 13
          seconds: 22
          microseconds: 980
        }
      }
    }
  ) {
    items {
      aDateTypeField
    }
  }
}

Switch

• set: Boolean|String - Set the field's existing value to a supplied Boolean or String value.
• invert: Boolean - Switches the field's existing value to its Boolean opposite (true -> false, false -> true)

Example

mutation {
  postUpdateByFilter(data: { aSwitchTypeField: { set: "CUSTOM_OPTION" } }) {
    items {
      aSwitchTypeField
    }
  }
}

JSON

• set: JSON - Set the field's existing value to a supplied JSON object.

Example

mutation {
  postUpdateByFilter(
    data: { aJsonTypeField: { set: { hey: "HO!", lets: "GO!" } } }
  ) {
    items {
      aJsonTypeField
    }
  }
}