We have an af:query search form and its associated Search results table on a page. One of the columns of this search results table has an LOV dropdown in its filter. We would like to restrict the values displayed in this LOV based on the search results.
Take for example, an employee search page with search results table displaying employee data. One of the columns is, say, department name and this column has a drop down filter. We would like for this filter to show only the department names of the employee rows that are in the search results table. In other ways, if there are a total of 10 departments, however, the search performed resulted in employees belonging to only 3 distinct departments then we want the filter's drop down to only show these 3 distinct departments instead of all the 10 departments. This is similar to the filter behavior on tables in SQL Developer. Can this be achieved in ADF? We are using JDeveloper 12.2.1.3.0.