Answers to: CaseQuery API with clob field

Comment by docvominh on Lukas Lieb's answer

docvominh — Sun, 22 Dec 2019 22:01:59 -0500

Cool, thank you very much :)

Answer by Lukas Lieb

Lukas Lieb — Fri, 20 Dec 2019 06:07:28 -0500

Hi,

Sadly this seems to bee a problem with oracle databases. As I said ordering on a clob is not possible. But we can maybe fix this. I created an issue for this: XIVY-3506

Kind regards

Lukas

Comment by docvominh on docvominh's answer

docvominh — Fri, 20 Dec 2019 04:43:50 -0500

for me is Oracle XE 11g (11.2.0.2.0)

Comment by Lukas Lieb on docvominh's answer

Lukas Lieb — Fri, 20 Dec 2019 03:22:02 -0500

Which version of oracle do you use?

Answer by docvominh

docvominh — Thu, 19 Dec 2019 21:53:07 -0500

Hi Lukas Lieb,

We have Case table to display all case in the system, and Case has a description

Now we want to sort with description, and IVY API allows to do it

But SQL generated is got error

It's easy to do a cast to char in SQL, but for now, I want to user CaseQuery API :(

Answer by Lukas Lieb

Lukas Lieb — Thu, 19 Dec 2019 04:05:58 -0500

First result on google: https://stackoverflow.com/questions/12980038/ora-00932-inconsistent-datatypes-expected-got-clob

You cannot order on a clob. And if you have a look at the db you see that the description is a clob.

What is the usecase to order a lazy case table by the description?