ORDER BY suggestions do not include SELECT aliases

MikeyC

SQL Prompt 4.0.4.11 doesn't suggest aliases defined in the SELECT portion of a query in the ORDER BY portion.

SELECT
	'Test' AS Field1
ORDER BY
	<cursor>

With the above query "Field1" should be listed as a suggestion.

Same applies when coming from a table:

SELECT
	backup_set_id AS Alias1
FROM msdb.dbo.backupfile
ORDER BY
	<cursor>

With the above query "Alias1" should be listed as a suggestion.

Anu D

Apologies for inconvenience caused.

I have logged this in our internal tracking system whose id is SP-1911.

It will be reviewed for a future release of SQL Prompt although we have not timescales for this at present.

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.

MikeyC

Can I assume by the SP number that this issue has been logged for a very long time and hasn't been added through a number of versions of SQL Prompt?