Is it possible to create filters for a report dynamically, but what I mean is this, my database has the following row in a table:Yes, this is possible using the <tt>apex_item</tt> API, specifically the <tt>select_list_from_query*</tt> methods. These methods could be used in a report or dynamic PL/SQL region to generate items whose values are used as filters in other reports. The values of <tt>apex_item</tt>-generated items are returned and processed using arrays<tt>apex_application.g_fxx</tt> arrays.
FILTER_ID FILTER_NAME FILTER_TYPE FILTER_QUERY
1 MyList SELECT LIST SELECT * FROM table1
I know it sounds strange but is it possible that in any way I could load this information and create html filters from this.
For instance, I load the first row and it says I need t create a select list called MyList that it will load values with the specific query from the filter_query column.
I just want to know if it is possible, if it is maybe have some info of where to start researching, if it is not possible just to know to ensure it is not possible.