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

Suggestion not working on Database List fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 11.10.4, 11.10.12
    • Fix Version/s: 12.10.4, 13.1-rc-1
    • Component/s: Old Core
    • Labels:
      None
    • Difficulty:
      Easy
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      I have 2 AWMs App1 and App2 described by the XWiki classes : App1Class and App2Class:

      • App1Class has a DBList property called field
        Display type : input
        Hibernate Query : 
        SELECT DISTINCT doc.fullName, prop.value 
        FROM XWikiDocument AS doc, BaseObject AS obj, StringProperty AS prop
        WHERE obj.name=doc.fullName AND obj.className='App2.Code.App2Class' AND doc.fullName != 'App2.Code.App2Template' AND obj.id=prop.id.id AND prop.id.name='name'
        
      • App2Class has a String property called name

      Note that, the application App2 has more than 10 entries.

      When I try to create a new entry on the application App1, the suggestion of the property (field) is not correctly working. What happen is that the suggestion is not looking on all entries of the App2 application but only on the 10 first entries. See screenshots :

      Note that, when I modify the DBList of the App1Class and use the XWiki Class Name instead of the Hibernate query, the suggestion works as expected.

      XWiki Class Name : App2.Code.App2Class
      Id Field Name : doc.fullName
      Value Field Name: name
      

      See screenshot :

        Attachments

        1. App1-new-entry.png
          App1-new-entry.png
          190 kB
        2. App2-home-page.png
          App2-home-page.png
          268 kB
        3. suggestion-issue.png
          suggestion-issue.png
          195 kB
        4. suggestion-working.png
          suggestion-working.png
          186 kB

          Activity

            People

            Assignee:
            mflorea Marius Dumitru Florea
            Reporter:
            mouhb Mohamed Boussaa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: