IEE -App9/App10
Anybody is having idea how to change view name dynamically in tbw or tbl window.
This topic has been closed for comments
Hi
You can do it using the variable ‘p_sViewName’. But I hope you know how to handle this since it will need to consider other things like security, column, loading, package Etc.
It will be easy if you search for the variable ‘p_sViewName’ in PAYLED module. You will find many examples there, so you can get an idea about how to do it.
Userlevel 7
+18
You might consider making a union view to achieve this on the database.
SELECT * FROM view_one WHERE condition = TRUE
UNION ALL
SELECT * FROM view_two WHERE condition = FALSE
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.