How to Define "BLOB" dataType of SQL in Appian CDT

mohammedz

A Score Level 2

over 7 years ago

Guyz,

I have a table in database with three columns
ID - Number
Document - BLOB
Name - VARCHAR

The Document column is of "BLOB" DataType....
Now I need to create a CDT and Map it to the Table
To do so what should be the dataType in my CDT or XSD Definition

Appreciate ur response....!!!!

Discussion posts and replies are publicly visible

Top Replies

ankitb0003 over 7 years ago +1
Certified Lead Developer

I have used the following definition for CLOB, It worked for me. it should be same for BLOB. <xsd:element name="DOCUMENT" nillable="true" type="xsd:string"> <xsd:annotation> <xsd:appinfo source="appian…

Parents

0 mohammedz
A Score Level 2
over 7 years ago

@Ankit

I have published the CDT and DataStore
When i try fetching the table data using a QueryRule I am not getting data
Getting the below Error

There was an error testing the rule:

Expression evaluation error in rule 'blob_getdata' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CABCBLOBCDTDT23013], query: [BLOB_getData], order by: [[]], filters:[(ID = TypedValue[it=1,v=5])])

Any idea how to fetch data ??
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mohammedz
A Score Level 2
over 7 years ago

@Ankit

I have published the CDT and DataStore
When i try fetching the table data using a QueryRule I am not getting data
Getting the below Error

There was an error testing the rule:

Expression evaluation error in rule 'blob_getdata' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [CABCBLOBCDTDT23013], query: [BLOB_getData], order by: [[]], filters:[(ID = TypedValue[it=1,v=5])])

Any idea how to fetch data ??
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data