Odoo Help


How to get the tables names that updated after a certain date

Tarek Mohamed Ibrahim
on 4/30/15, 8:05 AM 586 views


I needed to get all the tables names from the database that have records added or updated after a specific date, I wrote this sql statement but it didn't work :

select * from ir_model where (SELECT count(*) FROM replace(model,'.','_') WHERE create_date>'2015-04-01')>0

Could you pls help me find why this didn't work



| 6 5 7
Lodz, Poland

On 4/30/15, 10:10 AM

You must divide your query into two separate.  SQL doesn't support queries where the tables are not predetermined. The query planner would have a terrible time since it would not be able to estimate costs prior to execution.

The correct syntax should look something like this:

select * from ir_model where (SELECT count(*) FROM replace(model,'.','_') as xx WHERE xx.create_date>'2015-04-01')>0

because field create_date exist in ir_model, too.

Of course, and so it will not work.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 4/30/15, 8:05 AM
Seen: 586 times
Last updated: 4/30/15, 1:19 PM