Direct SQL in a GridView.

[djbodya]

Hello.
I was using previous version of pimcore but when i migrated to 11.0.5 i can not find "Direct SQL in a GridView". It is problem on my side or this feature does not available any more?

[NiklasBr]

It was removed for security reasons: #13395

[NiklasBr]

There is #15315 on the way, but I suspect it is not fully solving your use case?

Though you can filter by empty/none in the relations filter in Pimcore 11 today, applying this filter shows only the objects with empty Category.

[j-ts]

Yes, it's a good feature, but not solving a problem if you need to select objects when a specific attribute is NOT empty. In image filter, you can't add them all to get the desired result, you know what I mean?

[NiklasBr]

Yes, looks like missing functionality.

[johanlindgren]

Maybe the SearchTerm field in advanced object search could be used (even if it's not exactly SQL)

[SamyMP]

Also might be related to #14666, where my need was to be able to filter on text values that are empty. I also used the SQL filter to achieve this but not possible anymore in Pimcore 11

[trnqeu]

I was using this feature a lot to search inside the grid for objects with or without a specific tag (or more than one tag). Is there any option to achieve the same result inside the grid? It's extremely important for us to edit objects based on a search by tag, and that SQL search seemed to be the only way to achieve it.