2 Replies Latest reply: Jul 30, 2012 1:19 PM by Jan Vervecken RSS

    dynamically filter model-driven LOV : search-values visible

    Jan Vervecken
      hi

      Please consider the blog post by Frank Nimphius, "How-to dynamically filter model-driven LOV "
      at https://blogs.oracle.com/jdevotnharvest/entry/how_to_dynamically_filter_model
      (also part of http://www.oracle.com/technetwork/developer-tools/adf/learnmore/june2012-otn-harvest-1683085.pdf )

      Using JDeveloper 11.1.1.6.0 I created an example application that tries to use the code suggested in the blog post
      at http://www.consideringred.com/files/oracle/2012/DynamicallyFilterMDLOVApp-v0.01.zip

      For the following scenario (sc1) I see (somewhat) expected behaviour:
      - (sc1-a) run the "index" view on adfc-config.xml in JDeveloper
      - (sc1-b) click the "do goFirstTryFilter" link
      - (sc1-c) on the firstTryFilter page click the LOV search icon for DepartmentId
      - (sc1-d) notice the "Search and Select: DepartmentId" LOV dialog shows up with one record with DepartmentId 60 in the table
      - (sc1-e) click the Search button, resulting in the same one record with DepartmentId 60 in the table

      Note that after step (sc1-e) one could expect to see "all" departments because no search-values are shown in the LOV search-fields (at steps (sc1-d) and (sc1-e)).

      - (q1) What would be the options to make "dynamic filter" search-values visible in the LOV search-fields (to avoid end-user confusion when searching)?

      many thanks
      Jan Vervecken
        • 1. Re: dynamically filter model-driven LOV : search-values visible
          Jan Vervecken
          fyi

          Find a related scenario (sc2) and questions (q2) and (q3) in JIRA issue ADFEMG-37, "calling toString() on a ViewCriteriaRow causes SQLException ",
          at http://java.net/jira/browse/ADFEMG-37

          Also related to JIRA issue ADFEMG-38, "oracle.jbo.ViewCriteria.addRow() : For internal use only. ",
          at http://java.net/jira/browse/ADFEMG-38

          regards
          Jan
          • 2. Re: dynamically filter model-driven LOV : search-values visible
            Jan Vervecken
            fyi

            - about http://java.net/jira/browse/ADFEMG-37

            -- (q2) Should (implicity) calling the toString() method on a ViewCriteriaRow instance change the state of the ViewCriteriaRow instance?
            --- A known bug. (I have asked for the bug number.)

            -- (q3) Why is there no message "Missing IN or OUT parameter at index:: 1" when the LOV search icon is clicked (after step (sc2-c)), as it seems to be eaten by the framework, while there is such a message when the Search button is clicked (at step (sc2-e))?
            --- a greyed out Error dialog is visible behind (so after moving) the LOV dialog
            see http://www.consideringred.com/files/oracle/img/2012/ADFEMG-37-move-LOV-shows-Error.png

            -- I have added a related/rephrased question:
            --- (q4) Why is the Error dialog for message "Missing IN or OUT parameter at index:: 1" invisible behind the LOV dialog (after step (sc2-c))?

            But, the main question in this forum thread is (q1), and still remains.

            regards
            Jan