pimcore/data-hub

[Bug]: 'o_id' column not found error when use tags args for listing queries

bender-nvkz opened this issue · 1 comments

Expected behavior

Get List of Data Objects selected according to the specified tags (as argument) by GraphQL query

for ex:
изображение

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

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