Hi,
I hope APEX team will consider to implement the following suggestions in Oracle APEX 20.2:
Interactive Grid and Popup LOV
1. Options (or documented JavaScript API for JavaScript Initialization Code) in APEX Builder design time to change the column width to automatically fit the contents (auto fit) and make the content automatically to wrap in cells. Currently, particularly with Popup LOV, when I need to display 10-25 additional columns in the Popup LOV page item, I need to manually override the following classes so that the columns will not automatically shrink to the width of the Popup LOV. However, the width of columns must be defined in a fixed pixel.
.a-PopupLOV-results .a-GV-header {
width: 150px;
}
.a-PopupLOV-results .a-GV-cell {
white-space: normal;
}
2. No automatically reset after redirecting to different page and coming back to the interactive grid. When I define a link column in interactive report (IR), after I click on the column link to go to a different page and come back to the interactive report page, the previous search result and pagination are not changed. Currently, the IG is automatically reset when navigating to other page from it.
3. For IG, horizontal overflow (scrollbar) automatically sticks above pagination controls.
4. Currently for Popup LOV, I cannot set its value in PL/SQL dynamic action. I hope this feature can be considered.
Faceted Search
1. A new dedicated facet for date range...to allow user to enter start date and/or end date. Currently, there is only limited support for date columns with the range facet.
2. The magnifier icon is not displayed correctly in Internet Explorer 11. I think this can be fixed easily if APEX team will add a supplemental media query in APEX CSS file(s) for this for IE 11 users.
3. A single faceted Search region that controls a dashboard: reports, charts, etc. at the same time.
New Report Region Type
1. A new report region that looks similar to interactive grid (with IG-styled pagination controls) but with all the basic features as in classic reports and can be used with faced search.
2. Report Column width auto-fit content and option to wrap text.
3. Horizontal overflow (scrollbar) automatically sticks above pagination controls.
Interactive Report
1. IR pagination that looks consistent with pagination controls in interactive grid.
2. Horizontal overflow (scrollbar) automatically sticks above pagination controls.
Region Template
1. Currently, there are 3 options in Item Padding in a region Template: default, slim padding, and remove padding. Ideally, there will be a "compact" template option so that page items are displayed closer (and smaller) in the region. This is particularly useful when we create a form with a lot of page items.
Thank you!