⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

column filter doesn't work with setRelationNtoN

Started by Cyn, 27 December 2018 - 15:11 PM

Single Page

Cyn

Member

Posted 27 December 2018 - 15:11 PM

Hi GC people!

I'm working on a function that has 2 fields of type setRelationNtoN, they work fine to add and edit but with column filter, get this error:

ERROR: column "tags_item.id_item" must appear in the GROUP BY clause or be used in an aggregate

[attachment=1339:img1.png]

[attachment=1338:img2.png]

Looks like a bug, but Im not sure.. because on example of the web works fine..

My DB is Postgres, maybe could be a bug only with Postgres?

Any idea?

Thanks!!!