adfemg
  1. adfemg
  2. ADFEMG-14

Input List Of Values, autosuggest behavior

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Incomplete
    • Labels:
      None
    • Environment:

      jdeveloper 11.1.1.2 - 11.1.1.6

      Description

      JDeveloper version : ALL
      WebLogic Server version : n.a.
      impact level : high
      why : annoying to users and performance implications
      summary :
      I would like to post about an issue i am straggling with oracle support since jdeveloper 11.1.1.2.
      It is SR 3-5035735611 and referenced Bug 9316480: LOV AUTOCOMPLETE USES LIKE OPER FOR NUMBER, CAUSING FULL TABLE SCAN

      Description:
      By default when you type a value in an input list of values the query is excecuted always with the LIKE operator.

      SELECT Departments.DEPARTMENT_ID,
      Departments.DEPARTMENT_NAME,
      Departments.MANAGER_ID,
      Departments.LOCATION_ID
      FROM DEPARTMENTS Departments WHERE
      (((Departments.DEPARTMENT_ID LIKE ( :vc_temp_1 || '%'))))

      And even if the value you entered is valid the LOV popup will open showing all values starting with the value you entered.
      so in the attached test cases if you type '10' in the departmentId the LOV will open showing 10, 100, 101 etc.

      Impact:
      This is very annoying for users that do heads-down data entry. They make change requests for us to create custom made popups for LOVs.
      Also if the field is a number (like the departmentId) the executed query force full table scan even though it is the primary key.
      In Large List of values this causes performance issues.
      I understand this functionality is designed for the auto-suggest behavior, yet there is no way to override it.

      Proposal:
      We just need the option to disable auto-suggest behavior (on design time) so that the query is executed with '=' operator and the LOV does not open when the value entered is valid.

        Activity

        mkoniotakis created issue -
        chriscmuir made changes -
        Field Original Value New Value
        Status Open [ 1 ] Closed [ 6 ]
        Resolution Incomplete [ 4 ]

          People

          • Assignee:
            chriscmuir
            Reporter:
            mkoniotakis
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: