How to search json column in Sonata?
I have column in my db where data looks like this
"{"cs":"L\u00e9ka\u0159","en":"Doctor","_type":"translated"}"
I need to perform fulltext search like shown in screenshot and I have no idea how to do it.
Is there any way how to extract data from db and then perform search on this? I couldn't find any mention of it in documentation. Maybe there is some simple solution which I can't see, thank you for your help. 
I tried to solve it by raw sql query but sonata for it's filters expects instance of QueryBuilder. I also tried to change column's collation, but it didn't help.
It turned out I'm completely blind. If somebody would run into this problem in the future, there is possibility to create custom filter like it is described here. https://docs.sonata-project.org/projects/SonataDoctrineORMAdminBundle/en/4.x/reference/filter_field_definition/#jsonlistfilter-and-custom-filters
- What Does :!: Mean?
- PHP: Is it possible to create a SplFileObject object from file contents (string)?
- PHP Laravel Check if Array is empty
- PHP / Apache / Node / Puppeteer - Error: Failed to launch the browser process
- WooCommerce how to display "you save X%" on checkout page
- Update custom order item meta in WooCommerce
- Is Laravel-admin 1.8.19 not compatible with laravel 11.8.0? [Your requirements could not be resolved to an installable set of packages.]
- PHP XAMPP Config
- How to import Wikipedia XML dump into MongoDB?
- Possible bug with PHP PDO and with PostgreSQL
- Split string on dots unless the dot is inside double quotes
- How to Dynamically Populate Schema in WordPress Using XPath Variables?
- /pusher/auth endpoint returning 404 in Laravel
- php .env with Docker
- Add 1 to variable inside of an echo expression
- Show values from a MySQL database table inside a HTML table on a webpage
- Get all alphanumeric words with length of either 4 or 12 characters
- Replace the trailing digits of a URI with corresponding slug text
- Wrap <b> tags around substrings matching a regular expression
- Match urls with a specific signature
- UTF-8 all the way through
- Get words delimited by "#$"
- How do you delete one part in the plaintext I scraped from the site?
- PHP Scrape HTML Between <pre> tags
- How to extract content or scrape data sets from website source page
- Create joined string by looping through key value array
- how to re-migrate a laravel migration after deleting the table
- Validate user input string only contains letters, numbers, and underscores
- How escape characters in a variable to be used in a regex pattern?
- How to make preg_match() match more than once?