When programming an own label renderer a SQL Query is generated which fails.
The generated query in my case (for website users) was:
The problem is this piece of generated code: where display_name as label like
This should only be: where display_name like
I already found a solution for this:
The /preside/system/services/admin/DataManagerService.cfc, function getRecordsForAjaxSelect() need the following change:
the selectfields already maybe contain a 'as' string. So selecting the first word (which is only the fieldname) is a solution.
PS: I have to apologize, that I still haven't installed my system to do a pull request. And I also don't know if the solution I found is completely valid and I think it can be done much more elegant. But hey, it works.
I'd be happy if someone do a pull request for this. He can have all the kudos.