UDT handler: order by columnname desc doesn't work anymore
Ina Colman
Hi,
I upgraded recently coresuite to the latest version.
coresuite customize: 4.119956
In my UDT handler I added at "Order (Order by clause)" columnName desc
On previous versions it worked perfectly, after update it doesn't work anymore. When I open the UDT handler coresuite throws an error.
The resulting query (traced by sql profiler) I see that the brackets [] are placed wrong. See the red part in the sql statement.
It should be [columnName] desc.
declare @p1 int
set @p1=NULL
exec sp_prepexec @p1 output,NULL,N'SELECT T0.[code=auto:0], T0.[U_DS_DocNum], T0.[U_DS_DocType], T0.[U_DS_Bron], T0.[U_DS_Cardcode], T0.[U_DS_Agent], T0.[U_DS_Exposition], T0.[U_DS_TaxDate], T0.[U_DS_Aant_Retour], T0.[U_DS_Tot_Pieces], T0.[U_DS_FreeText]
FROM [@DS_LOGFILE] AS T0
WHERE ISNULL(T0.[U_DeletedF],'''') != ''Y''
AND u_ds_cardcode = ''K04508''
ORDER BY [u_Ds_taxdate desc] FOR BROWSE '
select @p1
Is there a workaround?
Thanks in advance,
Ina
Paolo Manfrin
Hi Ina,
this seems to be a bug.
Please could you report this via our helpdesk so someone can follow up with you this case immediately?
Thanks
paolo
Anders Olsson
Hello Ina,
I confirm this bug. At the moment it is not possible to use ASC or DESC. I have scheduled a fix for the 4.20 release (end of January).
Refer to CSC-749 in the changelog.
Regards,
Anders
Ina Colman
thanks! :)
Anders Olsson
Correction: This will be included in the 4.15 release.
Please sign in to leave a comment.
Comments
0 comments