Naveen MC
Naveen MC
PostsComments
PPrisma
Created by Naveen MC on 11/18/2024 in #help-and-questions
Best way to look for text in a deeply nested JSON?
I have a JSON field in a table. Which holds the metadata for the row. So what will be in the JSON is kind of unpredictable. Because it'll store tiptap editor json, other json etc., Here are the few examples Example 1: 
{
  "content": [
    {
      "children": [],
      "content": [
        {
          "styles": {},
          "text": "Rocket Man",
          "type": "text"
        }
      ],
      "id": "c1ef50f8-5cbd-431f-bdd5-0b3a346a850f",
      "props": {
        "backgroundColor": "default",
        "level": 1,
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "heading"
    },
    {
      "children": [],
      "content": [
        {
          "styles": {},
          "text": "Rocket man is good person",
          "type": "text"
        }
      ],
      "id": "2d62b7cf-f945-47e0-b5ea-00e23499bde0",
      "props": {
        "backgroundColor": "default",
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "paragraph"
    },
    {
      "children": [],
      "content": [],
      "id": "8993a2c6-4ff3-4c82-a50a-724b3d07ed82",
      "props": {
        "backgroundColor": "default",
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "paragraph"
    }
  ]
}
{
  "content": [
    {
      "children": [],
      "content": [
        {
          "styles": {},
          "text": "Rocket Man",
          "type": "text"
        }
      ],
      "id": "c1ef50f8-5cbd-431f-bdd5-0b3a346a850f",
      "props": {
        "backgroundColor": "default",
        "level": 1,
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "heading"
    },
    {
      "children": [],
      "content": [
        {
          "styles": {},
          "text": "Rocket man is good person",
          "type": "text"
        }
      ],
      "id": "2d62b7cf-f945-47e0-b5ea-00e23499bde0",
      "props": {
        "backgroundColor": "default",
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "paragraph"
    },
    {
      "children": [],
      "content": [],
      "id": "8993a2c6-4ff3-4c82-a50a-724b3d07ed82",
      "props": {
        "backgroundColor": "default",
        "textAlignment": "left",
        "textColor": "default"
      },
      "type": "paragraph"
    }
  ]
}
Example 2: 
{
  "attending": [
    "cm38i9jrt000014pcg0lw2t29"
  ],
  "date": "0003-08-09",
  "description": "Rocket Launch",
  "invited": [],
  "location": "Rocket Spot",
  "organizer": "cm38i9jrt000014pcg0lw2t29",
  "rsvp": [],
  "title": "Rocket Man"
}
{
  "attending": [
    "cm38i9jrt000014pcg0lw2t29"
  ],
  "date": "0003-08-09",
  "description": "Rocket Launch",
  "invited": [],
  "location": "Rocket Spot",
  "organizer": "cm38i9jrt000014pcg0lw2t29",
  "rsvp": [],
  "title": "Rocket Man"
}
Example 3: 
{
  "type": "POLL",
  "body": "What's your favorite rocket color?",
  "meta": {
    "pollOptions": [
      {
        "text": "Option 1 Rocket",
        "userId": []
      },
      {
        "text": "Option 2 Rocket", 
        "userId": []
      }
    ],
    "pollEndTime": "2024-02-01T00:00:00.000Z"
  }
}
{
  "type": "POLL",
  "body": "What's your favorite rocket color?",
  "meta": {
    "pollOptions": [
      {
        "text": "Option 1 Rocket",
        "userId": []
      },
      {
        "text": "Option 2 Rocket", 
        "userId": []
      }
    ],
    "pollEndTime": "2024-02-01T00:00:00.000Z"
  }
}
What's the efficient way to handle the search? Example search term is "Rocket"
9 replies