Get all results download

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

Parents
  • Hello Catherine,

    Please share the eQL with us.

    Also let us know the version of the system and HF(if installed).

    Regards

    Swapnil

  • Hello,

    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?

    START WITH Document

    SELECT

      Code,

      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

    ==============

    [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 Suite
    100 | San Diego | CA | 92121 | USA



Reply Children