Uploaded image for project: 'Magnolia Shop (closed)'
  1. Magnolia Shop (closed)
  2. MSHOP-79

Product List Order displayed in a component is not the same as the one in the JCR

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Neutral
    • 1.1.3
    • 1.1.1

    Description

      Product List Order displayed in a component is not the same as the one in the JCR browser.

      This seems to come from class "ShopProductAccesor". An SQL query is used to retrieve the products:
      String query = "select * from [mgnl:contentNode] as productsSubNode where ISDESCENDANTNODE('" + ShopUtil.getPath("shopProducts", shopName) + "') and contains(productsSubNode.*, '" + productCategory + "')";

      This query does NOT return the list of products in the same order as the one displayed in the JCR browser.

      Note: Not sure if using SQL queries ever works to display get data in the order it is displayed in the JCR. I could not find anything about it.

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

                jsimak Jaroslav Simak
                adrien_be Adrien Berthou
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Checklists

                    Bug DoR
                    Task DoD