rubber-blueR
Refine2y ago
5 replies
rubber-blue

Nested update in Hasura

I want to implement below mutation

mutation UpdateHelpCategoryWithMetadata($id: uuid!, $help_category: help_categories_set_input!, $metadata: [help_categories_metadata_insert_input!]!) {
  update_help_categories_by_pk(pk_columns: {id: $id}, _set: $help_category) {
    id
    action
    sort_order
    status
    help_categories_metadata {
      id
      language_id
      name
    }
  }
  insert_help_categories_metadata(objects: $metadata, on_conflict: {constraint: help_categories_metadata_help_category_id_language_id_key, update_columns: [name]}) {
    affected_rows
    returning {
      id
      language_id
      name
    }
  }
}



variables

{
  "id": "e0d975be-3335-443f-962d-cae07ae15832",
  "help_category": {
    "action": "act",
    "sort_order": 3,
    "status": true
  },
  "metadata": [
    {
      "language_id": "d8f82ec6-6881-4299-afcc-3fe859ce3b59",
      "help_category_id": "e0d975be-3335-443f-962d-cae07ae15832",
      "name": "Payment0"
    },
    {
      "language_id": "cdd56b9d-181e-4271-a47f-aa2f62ceddff",
      "help_category_id": "e0d975be-3335-443f-962d-cae07ae15832",
      "name": "قسط D"
    }
  ]
}




Refine's generates

mutation ($pk_columns: help_categories_pk_columns_input!, $_set: help_categories_set_input!) {
      update_help_categories_by_pk (pk_columns: $pk_columns, _set: $_set) {
    id, action, sort_order, status, help_categories_metadata { id, language_id, name }
  }
 }


variables
{
  "pk_columns": {
    "id": "e0d975be-3335-443f-962d-cae07ae15832"
  },
  "_set": {
    "action": "act",
    "sort_order": 3,
    "status": true,
    "help_categories_metadata": {
      "data": [
        {
          "language_id": "d8f82ec6-6881-4299-afcc-3fe859ce3b59",
          "name": "Payment0"
        },
        {
          "language_id": "cdd56b9d-181e-4271-a47f-aa2f62ceddff",
          "name": "قسط D"
        }
      ]
    }
  }
}


error
field 'help_categories_metadata' not found in type: 'help_categories_set_input'
Was this page helpful?