Field alias does not work in ORDER BY

[sean@…]

My Objects and Persistence wiki fails because ORDER BY does not seem to convert field aliases to field names.

Given a gateway gw, do gw.getAll("someAlias") and the order node has only fieldAlias in it and the generated SQL ends up with the alias instead of the actual field name.

If you fix line 632 of abstractGateway.cfc so that it refers to arguments.node.fieldName instead of fieldAlias (which solves some other aliasing bugs), then gw.getAll("someAlias") causes an exception at line 632 because arguments.node.fieldName does not exist (it exists for other get*() operations).

[sean@…]

Christopher Bradford posted this fix for the issue:

Thanks for pointing this out, Joe. I did run into one problem that this
solution creates: the appendNode method of the order object does not use the
fieldName key; rather, it uses the field key. Changing "fieldAlias" to
"fieldName" in the abstractGateway causes getFieldExpression to break when
it is called for an order field. I had to change the appendNode method of
the order object, line 38, from:

<cfset node.field =
getQuery().findObject(node.objectAlias).getObjectMetadata().getField(node.fieldAlias).name
/>

to:

<cfset node.fieldName =
getQuery().findObject(node.objectAlias).getObjectMetadata().getField(node.fieldAlias).name
/>

It seems to be working, but since I'm not intimately familiar with the code,
this could have unintended consequences.

Christopher Bradford

[dhughes]

This was fixed in changeset 282. Infact, the order object wasn't using the correct variable name which is why this fix initally caused problems with ordering.