Broken SQL Query when creating an own LabelRenderer

Description

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

Solution:
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.

Environment

None

Assignee

Seb Duggan

Reporter

Michael Hnat

Labels

None

Accepted

Yes

Fix versions

Affects versions

Priority

Highest
Configure