Hello,
After running a user defined report in eB, and choosing to get all results, the excel file that is downloaded contains an error. The notes field becomes corrupted.
For example, for one record the notes field in the web view says "MM - invetsigate close out" but in the excel download is shows as "TU0gLSBJbnN0aWdhdGUgQ2xvc2UgT3V0".
Can anyone help define the cause and suggest a resolution?
Kind regards,
Catherine
Hello Catherine,
Please share the eQL with us.
Also let us know the version of the system and HF(if installed).
Regards
Swapnil
we are using 15.4 and here is the eQL
START WITH Document
SELECT
Code,
Attributes["Global", "TIF Number"].Value,
Name,
Attributes["Global", "TIF Cost Ceiling"].Value,
CAST( Attributes["Global", "TIF Date Issued"].Value AS STRING, 'dd/MM/yyyy' ),
CAST( Attributes["Global", "TIF Date Replied"].Value AS STRING, 'dd/MM/yyyy' ),
CAST( Attributes["Global", "TIF Date Awarded"].Value AS STRING, 'dd/MM/yyyy' ),
CAST( Attributes["Global", "TIF Date Delivered"].Value AS STRING, 'dd/MM/yyyy' ),
CAST( Attributes["Global", "TIF Date Completed"].Value AS STRING, 'dd/MM/yyyy' ),
CAST( Attributes["Global", "TIF Date Closed"].Value AS STRING, 'dd/MM/yyyy' ),
Attributes["Global", "TIF Status"].Value,
Attributes["Global", "Notes"].Value
WHERE
Class.Code = 'TIF'
AND Code CONTAINS 'N922'
AND Attributes["Global", "TIF Status"].Value <> 'Closed'
ORDER BY
Attributes["Global", "TIF Number"].Value
Catherine,
I tried (a slightly modified version of) your eQL but was not able to replicate the error. If you run the following simplified eQL, does it work?
==============
[Internal use]
tsg-eb1541, DEN1541, Catherine
Hi Catherine,
what is the attribute type of the "Notes" attribute in your system? Is it MEMO or Character ?
thanks,
Address: Bentley | 10052 Mesa Ridge Court Suite100 | San Diego | CA | 92121 | USA
Dennis, Thank you I will check the ammended eQL,and let you know.
Roberto, is a MEMO, does this affect the download?
Thanks,
Yes, there is a known bug in version 15.4.1 when downloading results that include a MEMO attribute and that field being corrupted in the downloaded file. The issue is fixed in version 15.5.1 and higher.
Answer Verified By: Carma De Villiers