CaseQuery API with clob field

docvominh — Wed, 18 Dec 2019 06:06:38 -0500

Hi Team, I try to use CaseQuery API to lazy Case table - ORACLE,

but stuck with description field (CLOB)

query.orderBy().description().ascending();

SQL generated: ORDER BY IWA_CASEQUERY.DESCRIPTION ASC

but I got exception : ORA-00932: inconsistent datatypes: expected - got CLOB

Seem it not allow to ORDER BY CLOB field

Do we have any solution to fix it with CaseQuery API? like this

query.orderBy().description().toString().ascending();

[UPDATE] IVY version : 7.0.13

Questions Tagged With case-query