Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-19120

Hibernate exception when performing LiveTable queries on different list parameters

    XMLWordPrintable

Details

    • Unknown
    • N/A
    • N/A

    Description

      When creating a LT query for a dedicated XClass with extra parameters to filter on two fields one of them being a StaticListClass and the other a DBListClass I obtained the following stack:

          Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [select elements(prop.list) from XWikiDocument as doc, BaseObject as tagobject, DBStringListProperty as prop, BaseObject as obj , StringProperty as prop_status, DBStringListProperty as prop_changedDocuments where tagobject.name=doc.fullName and tagobject.className='XWiki.TagClass' and tagobject.id=prop.id.id and prop.id.name='tags' and doc.translation=0 and obj.name=doc.fullName and obj.className = :className and doc.fullName not in (:classTemplate1, :classTemplate2) and obj.id = prop_status.id.id and prop_status.id.name = :prop_status_id_name and (prop_status.value in (:prop_status_value_1, :prop_status_value_2, :prop_status_value_3)) and obj.id = prop_changedDocuments.id.id and prop_changedDocuments.id.name = :prop_changedDocuments_id_name and (:prop_changedDocuments_list_4 in elements(prop_changedDocuments.list)) ]
      
      Caused by: java.lang.IllegalArgumentException: Could not locate named parameter [prop_changedDocuments_list_1], expecting one of [prop_status_value_2, prop_status_value_1, classTemplate2, prop_status_value_3, prop_status_id_name, prop_changedDocuments_id_name, classTemplate1, className, prop_changedDocuments_list_4]
      

      Attachments

        Issue Links

          Activity

            People

              surli Simon Urli
              surli Simon Urli
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: