Timeline filter not working if database is SQL Server

This issue can be reproduced in the 1.7 test environment. 1. Log into the SQL project in the test environment 2. Run a query using the concept of hypertension (make sure Timeline is checked) 3. In the timeline if you look at demo patient 1000000013 you will notice there are the following 3 instances appearing for Unspecified essential hypertension First observation: Start date: 2001-01-02 modifier_cd: 2 instance_num: 1 Second observation: Start date: 2007-09-07 modifier_cd: 2 instance_num: 1 Third observation: Start date: 2007-09-10 modifier_cd: 2 instance_num: 1 4. Click on Create model for Timeline 5. Change the filter to First 6. Click on Render a Timeline 7. Notice the timeline still displays all the observations for patient 1000000013 8. Look at the received xml and you will notice the above three instances are returned from the CRC. The only one that should be returned is the first observation of Unspecified essential hypertension First observation: Start date: 2001-01-02 modifier_cd: 2 instance_num: 1

TEST STATUS: Completed COMPLETION DATE: 07/22/2015 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Test Date: 07/22/2015 Build Number: Clients Tested :      i2b2 Workbench Environments Tested :      Databases: SQL Server and Oracle      Client OS: Windows and Macintosh Test Comments: Tested with the latest server build and it appears to be working correctly. I verified the appropriate observations are returned from the CRC based on the filter that is defined. In addition to testing First and Last I also verified that the Max and Min filters are still working. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Test Date: 07/21/2015 Build Number: 1.7.06.0001 Clients Tested :      i2b2 Workbench Environments Tested :      Databases: SQL Server      Client OS: Windows and Macintosh Test Comments: Tested with the latest workbench build (1.7.06.0001) and it is not working correctly. ISSUE FOUND: An error is returned from the server when you try to render a timeline in which the filter has been defined as one of the following: Max, Min, First, or Last In the XML message received from the server the cause of the error is due to incorrect syntax near the keyword 'with'.