ORDER BY Clause doesn't work for Date Column in SQL Server Activity of Javelin
search cancel

ORDER BY Clause doesn't work for Date Column in SQL Server Activity of Javelin

book

Article ID: 279567

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Trying to get the results from a SQL query inside SQL Server Activity of a Javelin flow using Order By against a Data column but it does order the result set as expected by the data column.

Environment

TDM 4.10.x

Cause

Identified as product defect.

Resolution

Issue fixed as part of the Javelin build 4.10.34. Can be downloaded from below link:

https://ftp.broadcom.com/user/downloads/pub/TDM/Javelin/Javelin-4.10.34.0.zip

Steps to apply: Javelin section in below KB article -

https://knowledge.broadcom.com/external/article?articleId=10931