How can we give dynamic runtime where clause in formspider? In Oracle forms, I can store my where clause in a table column and set it as default_where clause at runtime. Some examples are as follows:
How this functionality can be used in formspider? Can you kindly explain with example? I tried the second example above but it did not work.
asked 10 Mar '13, 15:45
Have a look at api_datasource.setDefaultQuery This api will allow you to do what you want to.
answered 11 Mar '13, 04:14
You can use
In your case, you can use the following procedure to set the default where clause:
Hope this helps,
answered 11 Mar '13, 04:43
Ibrahim Sand... ♦♦