2 SELECT model, res_id, module FROM ir_model_data
3 WHERE model = 'ir.actions.act_window'
4 AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id);
7 SELECT model, res_id, module FROM ir_model_data
8 WHERE model = 'ir.ui.menu'
9 AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);
11 SELECT model, res_id, module FROM ir_model_data
12 WHERE model = 'ir.ui.view'
13 AND NOT EXISTS (SELECT 1 FROM ir_ui_view WHERE id = ir_model_data.res_id);
15 DONT DELETE FROM ir_model_data
16 WHERE model = 'ir.actions.act_window'
17 AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id);
19 DONT DELETE FROM ir_model_data
20 WHERE model = 'ir.ui.menu'
21 AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);
23 -- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.view' AND NOT EXISTS( SELECT 1 FROM ir_ui_view WHERE ir_ui_view.id = ir_model_data.res_id);
24 -- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.menu' AND NOT EXISTS( SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id);