Hi-
For a read data action in my form, I have where settings that includes {data:Y} as a value to filter on. I am getting an "Unknown 'Array' in 'where clause'" error. When I change to value to a number, say 2020, I get no error.
The following is provided by Joomla when the error occurs:
1054 Unknown column 'Array' in 'where clause'
/home4/venmusic/public_html/test/libraries/joomla/database/driver/mysqli.php:665
Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465
3 JDatabaseDriver->loadAssoc() JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:80
4 G3\L\Joomla\DatabaseAdapter->loadAssoc() JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:996
5 G3\L\Model->select() JROOT/administrator/components/com_chronoforms7/chronoforms/libs/models.php:462
6 G3\A\E\Chronoforms\L\Models->read() JROOT/administrator/components/com_chronoforms7/chronoforms/functions/read_data/read_data_output.php:6
7 include() JROOT/plugins/system/chronog3_plg/chronog3/libs/traits/load_file.php:21
8 G3\L\Component->load_file() JROOT/administrator/components/com_chronoforms7/chronoforms/libs/page.php:44
9 G3\A\E\Chronoforms\L\Page->fn() JROOT/administrator/components/com_chronoforms7/chronoforms/libs/page.php:326
10 G3\A\E\Chronoforms\L\Page->event() JROOT/administrator/components/com_chronoforms7/chronoforms/controllers/manager.php:104
11 G3\A\E\Chronoforms\C\Manager->index() JROOT/plugins/system/chronog3_plg/chronog3/libs/app.php:304
12 G3\L\App->processAction() JROOT/plugins/system/chronog3_plg/chronog3/libs/app.php:243
13 G3\L\App->dispatch() JROOT/plugins/system/chronog3_plg/chronog3/libs/app.php:78
14 G3\L\App::call() JROOT/plugins/system/chronog3_plg/chronog3/libs/app_loader.php:61
15 G3\L\AppLoader->__construct() JROOT/administrator/components/com_chronoforms7/chronoforms7.php:20
16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
19 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
20 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51