When creating a new model with a listing component grid, fulltext search is not working #1315
Description
Describe the bug (*)
When creating a new model with a grid fulltext search is not working. The entity and the grid is created properly but if you try to filter using the fulltext search, it's throwing an exception.
To Reproduce (*)
Steps to reproduce the behavior:
- Create a new entity with grid via the plugin
- Go to the backend listing grid
- Try to use the full search text box
- See error
[2023-03-13 13:36:24] main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause', query was: SELECT COUNT(*) FROM `oem_product` AS `main_table` WHERE ((`fulltext` LIKE '%itunes%')) {"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause', query was: SELECT COUNT(*) FROM `oem_product` AS `main_table` WHERE ((`fulltext` LIKE '%itunes%')) at /var/www/fasttrack/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause' at /var/www/fasttrack/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"}
Expected behavior (*)
Search works correctly
Screenshots
Please complete the following information: (*)
- OS: Ubuntu 20.04 / Windows 11 x 64
- PhpStorm/Intellij version: 2022.3.2
- Plugin Version: 5.0.1
Additional context
It seems at the very least that the plugin is not creating a fulltext search index in the db_schema.xml file (even with placeholder for required attributes) and also it's not creating the DataProvider correctly to add the full text filter in the collection.