Hi everybody,

There are fields defined in blob data type in my model that I created by Framework Manager.

I want to show these fields in my list. But even though I cast this field, I get a query service error.

Note: Blob type fields are defined in JSON format.

Version used: Cognos Analytics 11.1 R4

Anyone have any idea about this topic? I would be glad if you help

Thanks in advance.

Best regards,
Erdem YAZAN

------------------------------
Erdem YAZAN
------------------------------

#CognosAnalyticswithWatson

If you are storing JSON (or BSON) in a LOB type in your database, recommend you use their SQL-JSON features to project the required objects as types that would be supported.

Data types

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/c_ca_data_types.html

------------------------------
NIGEL CAMPBELL
------------------------------

Original Message:
Sent: Fri February 12, 2021 12:03 AM
From: Erdem YAZAN
Subject: How can I show a field with data type blob?

Hi everybody,

There are fields defined in blob data type in my model that I created by Framework Manager.

I want to show these fields in my list. But even though I cast this field, I get a query service error.

Note: Blob type fields are defined in JSON format.

Version used: Cognos Analytics 11.1 R4

Anyone have any idea about this topic? I would be glad if you help

Thanks in advance.

Best regards,
Erdem YAZAN

------------------------------
Erdem YAZAN
------------------------------

#CognosAnalyticswithWatson