Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-6038

Auto-complete feature of Text Box is not working as expected when using a query to limit the results returned.

    XMLWordPrintable

    Details

    • Story Points:
      13
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      1. Upload the report to 8.1 BA Server
      2. Follow the steps as shown in the screencast autofill_textbox.mp4 attached.

      That is,

      • Open the attached report in User Console
      • Enter the value as "sa". Nothing happens
      • Click outside the parameter and your browser refreshes/flashes once and the parameter is empty.
      • Now enter "sa" again and you can see the parameter showing the matching results
      • Now change the value to "aa", nothing happens. Click outside the parameter and again browser flashes
      • Enter "aa" again you won't see the result.
      • Delete one character and now you see the result for "aa"
      Show
      Steps to replicate the issue: Upload the report to 8.1 BA Server Follow the steps as shown in the screencast autofill_textbox.mp4 attached. That is, Open the attached report in User Console Enter the value as "sa". Nothing happens Click outside the parameter and your browser refreshes/flashes once and the parameter is empty. Now enter "sa" again and you can see the parameter showing the matching results Now change the value to "aa", nothing happens. Click outside the parameter and again browser flashes Enter "aa" again you won't see the result. Delete one character and now you see the result for "aa"

      Description

      We are creating a prpt report with Text box auto-complete parameter with the below SQL query as source.

      SELECT SUBSTR(CustomerName, 1, LEN(${ParamCustomerName}) + 2) As CustName 
         FROM Customers 
         WHERE CustomerName LIKE CONCAT(${ParamCustomerName}, "%")
      UNION 
         SELECT CustomerName As CustName WHERE CustomerName = ${ParamCustomerName}
      

      We are using such a query in order to limit the number of results returned and shown on the browser. When the number of results returned is more then we are seeing the issue of browser getting frozen for few seconds.

      But when we use the SQL approach to limit the results returned then we are seeing incorrect behavior of Text Box's auto-complete feature.

      I am also attaching the sample report 86865SampleReport_updated.prpt.zip

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mleite Margarida Leite
              Reporter:
              gdev Gurudev
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: