Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | App - FluidShell |
| Version | 18.0 |
1. Create a table containing a DATE column and insert a record.
2. Launch FluidShell.
3. Query the table. The DATE value doesn't have a time value.
4. Use "sqlexport" to export the table data to an Excel file.
Results: The DATE value in the Excel output file contains a time value. Refer to attachment sqlexport_issue.png.
"sqlexport" code was using Timestamp format for both Date and Timestamp values. Fixed the code to use Date format for Date values and Timestamp format for Timestamp values.
Thank you for addressing this so quickly. Can you elaborate more on the Fixed build (ADS 18.0.11-2, 19.0.0-alpha-3 )? I see it is not in the 18.0.11 update. Can we expect to see a second update made public soon? Sorry if this email is premature.
Thanks
Gregg
Thank you for addressing this so quickly. Can you elaborate more on the Fixed build (ADS 18.0.11-2, 19.0.0-alpha-3 )? I see it is not in the 18.0.11 update. Can we expect to see a second update made public soon? Sorry if this email is premature.
Thanks
Gregg
Hi Gregg,
We're currently testing this fix. Once it is tested & verified, we'll post another update w/ the link to download & apply the patch.
Hi Gregg,
We're currently testing this fix. Once it is tested & verified, we'll post another update w/ the link to download & apply the patch.
Verified in ADS v18.0.11-2. Issue is fixed in FluidShell and time part is now not included in sqlexport for date datatype
Verified in ADS v18.0.11-2. Issue is fixed in FluidShell and time part is now not included in sqlexport for date datatype
Thanks again for the quick turnaround. The patch fixed the issue. :)
Thanks again for the quick turnaround. The patch fixed the issue. :)
I'm having an issue with the sql export in fluidshell with the latest version of ADS. Version 18.0.11-2 exports the date correctly as m/dd/yyyy. I loaded ADS on my new pc today with Version 18.0.18 and it exports the date as Mon dd, yyyy. Can someone confirm that this is an issue or is there a place to adjust this in the setting now?
Using command \sqlexport -f excel2007
Thanks
Gregg
I'm having an issue with the sql export in fluidshell with the latest version of ADS. Version 18.0.11-2 exports the date correctly as m/dd/yyyy. I loaded ADS on my new pc today with Version 18.0.18 and it exports the date as Mon dd, yyyy. Can someone confirm that this is an issue or is there a place to adjust this in the setting now?
Using command \sqlexport -f excel2007
Thanks
Gregg
The fix for issue #15284 in ADS 18.0.13-8 caused this breakage.
I've fixed the problem in 18.0.18-5. I've also backported the fix for issue #15354 to v18.
Notes to QA: In addition to verifying this issue, do regression testing for #15284 and #15354.
The fix for issue #15284 in ADS 18.0.13-8 caused this breakage.
I've fixed the problem in 18.0.18-5. I've also backported the fix for issue #15354 to v18.
Notes to QA: In addition to verifying this issue, do regression testing for #15284 and #15354.
Verified all 3 scenarios in ADS v18.0.18-5. Tested #15284 and #15354
Verified all 3 scenarios in ADS v18.0.18-5. Tested #15284 and #15354
Patch uploaded:
Confirming the patch fixed the issue. Thank you for the quick turnaround.
-Gregg
Confirming the patch fixed the issue. Thank you for the quick turnaround.
-Gregg
Issue #15211 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 18.0.18-5, 19.0.0-beta-40 |
| No time estimate |
1 issue link |
breaks #15315
Issue #15315"View as spreadsheet" gives exception -> Result format "$#,##0.00;($#,##0.00)" for (Datetime/timestamp) |
"sqlexport" code was using Timestamp format for both Date and Timestamp values. Fixed the code to use Date format for Date values and Timestamp format for Timestamp values.