A connected field has been deleted. How do I "clear" references to a deleted connected field?

Hi ​@carlos-btc ! I already answered your other post with the same question, but I'll follow up here too.

To better understand what's happening and help you effectively, could you share the following?

1. Screenshot of the card showing the ghost references (like the image you shared)

2. Name of the connector field that was accidentally deleted

3. Name of the pipe where the field existed

4. How many cards are affected is it a specific card or multiple ones?

5. Result of the query below in GraphiQL (replace with the ID of one of the affected cards):

{
  card(id: "AFFECTED_CARD_ID") {
    id
    title
    parent_relations {
      id
      name
      source_type
      cards {
        id
        title
      }
    }
  }
}

With this information we can confirm what's causing the ghost references and point you in the right direction to get it resolved. Thanks!

Olá ​@Alan dOliveira.

The issue affected over a thousand cards in production. To avoid production issues while investigating a solution, I replicated the problem in two test pipes, and the issue occurs in the same way. If I delete a connected field after some cards have been created, the cards that referenced that field retain a "ghost reference" to the deleted field from the other pipe.

Here are the answers:

1.

2. The field name is "Filho" and the ID is "filho".
3. Parent Test
4. In my controlled test, I currently have 3 cards. However, in the pipe where the production issue occurred, over a thousand cards are affected. When I recreated the field and re-established the connections, the references became duplicated—as you can see in the screenshot above: "Pai 2" appears twice.
5. Result:

{
  "data": {
    "card": {
      "id": "1366648788",
      "title": "Filho 2",
      "parent_relations": [
        {
          "id": "430294885",
          "name": "Filho",
          "source_type": "Field",
          "cards": [
            {
              "id": "1366650884",
              "title": "Pai 1"
            }
          ]
        }
      ]
    }
  }
}

Obrigado.