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.