René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"PG LIKE search within isArray columns","articleBody":"Hey there!\n\nI have one issue that i have solved but seems like I didn't get to the cause of it.\nSo when I'm using `isArray` for field and `substringSearch: true` it sets additional `\"` into value\nSee `063` in the query.\n\n```\n🪲📜 PG Q: SELECT \"id\", \"plate\", \"name\", \"phones\", \"status\", \"type\", \"building\", \"flat\", \"created_at\", \"updated_at\", \"expire_at\", \"comments\", \"is_us_plate\" FROM \"vehicle\" WHERE \"phones\" ILIKE $1 AND \"status\" IS DISTINCT FROM $2 AND \"building\" = $3 ORDER BY \"id\" DESC LIMIT $4 OFFSET $5 params: [ '%\"063\"%', 2, 'b4', 50, 0 ]\n\n🪲📜 PG Q: SELECT COUNT(*) FROM \"vehicle\" WHERE \"phones\" ILIKE $1 AND \"status\" IS DISTINCT FROM $2 AND \"building\" = $3 values: [ '%\"\\\\\"063\\\\\"\"%', 2, 'b4' ]\n```\nso seems like those quotes are ambigious for `like` query.\nI found only one way is to replace it. In file postgres data connector. But i think that might have a better way to solve it.\n```js\nif (filter.operator == AdminForthFilterOperators.LIKE || filter.operator == AdminForthFilterOperators.ILIKE) {\n    let value = filter.value.replaceAll('\"','');\n    value = value.replaceAll('\\\\','');\n    return [`%${value}%`];\n}\n```\n\nHere's my column setup\n```\n{\n    name: 'phones',\n    type: AdminForthDataTypes.JSON,\n    isArray: {\n        enabled: true,\n        itemType: AdminForthDataTypes.STRING,\n    },\n    minLength: 12,\n    filterOptions: {\n        debounceTimeMs: 800,\n        substringSearch: true,\n    },\n}\n```\n\nPlease let me know if that can be fixed somehow...\nThanks!","author":{"url":"https://github.com/TrilipuT","@type":"Person","name":"TrilipuT"},"datePublished":"2025-09-25T17:37:01.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/368/adminforth/issues/368"}