IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Double Querysort doesnt work in Xapplication

  • 1.  Double Querysort doesnt work in Xapplication

    Posted Mon July 08, 2002 02:07 PM

    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.]


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Double Querysort doesnt work in Xapplication

    Posted Mon July 08, 2002 03:46 PM

    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)


    #API-Management
    #Tamino
    #webMethods


  • 3.  RE: Double Querysort doesnt work in Xapplication

    Posted Fri July 26, 2002 01:25 PM

    the problem was solved for X-Application 3.1.3


    #Tamino
    #API-Management
    #webMethods