Hello,
In my application I need two sort criterias at the same time for my Query.
I can add two QuerySort with different sortSequence. But I recieve exception when I give two sort criterias.

The exception message I get is something like this :

StoreException: query failed: /oc_body[body_site~=‘‘] sortby ( diagnosis descending body_site descending): ?/code>nullcom.softwareag.tamino.db.API.accessor.TAccessFailureVerifier.verifyQueryRe

I tried /oc_body[body_site~=’’] sortby ( diagnosis descending body_site descending) from Interactive interface it did not also work it worked when I put comma between two search criterias which is :

/oc_body[body_site~=‘*’] sortby ( diagnosis descending , body_site descending)

According to these can somebody tell me what to do please?
I need use two sort criterias as soon as possible.

Thanks…


X-Application Version: 3.1.2
Tamino Version : 3.1.1
Platform : Win2k
WebContainer : Tomcat 3.3a
JDK Version : 1.3.0

[This message was edited by Christian Freytag on 26 Jul 2002 at 11:55.]

Hello,

you are right. It’s a bug of X-Application 3.1.2: Entering two search criterias does not work. You analyzed also the problem: the sort criterias are not separated by comma.

To fix it, I changed the code of the file

%XAPP_HOME%\src.…\businessdocument\QueryBuilder.java

I made some basic tests.

It is take from the current version of work. I hope, it will run also with 3.1.2.

Could you check the attached file whether it fixes your problem or has problems within your environment?

Bye,
Christian.
QueryBuilder.java (4.75 KB)

the problem was solved for X-Application 3.1.3