Export Extension to Excel As Text Data Type

[Former Member]

Hi,

I created new extension as TEXT data type, and i would like to export this text to excel from report (query already created).

The issue is I know only the extension field as TEXT Preview meaning :

Extension field : KPI_PROGREPORT_TEXT_PREVIEW

select KPI_PROGREPORT_TEXT_PREVIEW from FCI_DYN_$2147482948

Result of query is limited : KPI_PROGREPORT_TEXT_PREVIEW containing limited characters - 1000 characters (3000 byte)

The extension field value is containing more than 1000 charcters ( = value displaying on the project screen)

My question : How to find the correct field to have the full TEXT (TEXT value displaying on the project screen, and not the Preview one ?

Any other way to get the TEXT from query as displayed on th project screen ?

Thanks in advance for your suggestions.

Kind Regards,

Anacia

[vikram_shanmugasundaram]

The big texts are stored in the DB as BLOBS. I donu2019t believe itu2019s possible to extract the contents of the big text to excel using the query definition.

Regards,

Vikram