Topic: Implementation possibility in IG analog lov and the trigger post-query
At migration of applications from Oracle Forms in APEX environment (18.1 or 5.1.4) there were difficulties with Interactive Grid and a field defined as lov (or select list). Let we have a unit of the tabular form in Oracle Forms. With the help post-query the trigger and lov it is possible to make so that for some field in the unit all values were deduced, and by means of lov it was possible to select (i.e. to change, add) only some set restricted to a condition. Texts sql quer for lov and for the trigger different, on a condition where. It is necessary in certain cases, to describe long (well for example, the dismissed/moved employee, the data on it should it is deduced for last periods (date), but at adding of new lines it should not be in lov).
In APEX with IG so it is impossible, yes, is lov, but the mechanism similar post-query I I do not see or I do not guess as to implement.
Whether there are at someone ideas on creation of the described mechanism in IG?
Thankful in advance for the help.
There is an output to remove grid and to pass on IR + the form. But then users should "spring" often from the report in the form and it is reverse that is not so convenient. Nevertheless, here IG would be much more interesting.