2 Replies Latest reply: Apr 21, 2014 2:06 PM by 2649942 RSS

    RQLQueryRange not returning orders on jsp

    1019844

      Hi!

       

      The problem is that when i am using 'RQLQueryRange' to list orders from a specific user, besides i can list the orders

      in the database and in the Dynamo interface, in the jsp page they are not listed.

       

      In the database i list with:

       

      select * from dcspp_order where

      profile_id = 'CLIxxx'

      and state != 'INCOMPLETE'

      and siteId = 'mySiteId'

       

      In the Dynamo interface i list with:

       

      <query-items item-descriptor="order">

      profileId = "CLIxxx" and

      state != "INCOMPLETE" and

      siteId = "mySiteId"

      </query-items>

       

      But in the JSP they are not listed, i am  using the droplet /atg/commerce/order/OrderRepository.

      A strange thing i suspect is that besides the  orders are not shown the output 'empty' is not rendered

      either, this takes me to think that the problem may be in the pagination or something near it.

       

      Have anyone any idea?

       

      Thanks,

       

      regards,

       

      Marcos