Hi. I am working on creating a database view from the sys_audit_delete table showing only data where the tablename is sys_user_grmember or cmdb_rel_ci.
I had the following conditions attempted in the where clause and they both does not apply the filter when trying out the view. I also tried the business rule route and that did not work as well. I am hoping to get some guidance as custom table and report solutions are out of the question. Thank you for your help.
1. where clause field "viewprefix_tablename='sys_user_grmember'^ORviewprefix_tablename='cmdb_rel_ci'"
@tangcov
2. where clause field "viewprefix.tablename='sys_user_grmember'^ORviewprefix.tablename='cmdb_rel_ci'"
