[Bug]: 'o_id' column not found error when use tags args for listing queries
bender-nvkz opened this issue · 1 comments
bender-nvkz commented
Expected behavior
Get List of Data Objects selected according to the specified tags (as argument) by GraphQL query
Actual behavior
Getting error: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o_id' in 'IN/ALL/ANY subquery'"
Steps to reproduce
When using pimcore > v.11:
Query list of object with "tags" arg
bender-nvkz commented
This error occurs because o_
prefix is removed from data objects system properties in Pimcore v11.
It's nessesary to use \Pimcore\Model\DataObject\Service::getVersionDependentDatabaseColumnName()
method when do queries
I'm fix this at #833