Skip to Content
This question has been flagged
index
1 Reply
13866 Views
Avatar
Deepa Venkatesh

I  would like to know, how to create SQL indexes on the custom module using Python/ORM methods....

Avatar
Discard
Avatar
Ivan
Best Answer

If you want to create complex indexes, you need to inherit _auto_init method of the model and execute a CREATE INDEX (using cr.execute) statement after you call the super.

If you just want to create per column index - PostgreSQL is capable to combine index, just add select=1 in the column definition, like so:

'name' ; fields.char('Name', size=64, select=1)

If you are interested on how a table and it's related objects, read the _auto_init method of BaseModel.

Avatar
Discard
Deepa Venkatesh
Author

Thanks Ivan , Yes I too found the same by referring "account_move_line" object... However I came over across 2 kinds of select parameters, i.e "select=1" means Basic Search, "select="2" means Advance Search... Any idea what exactly is the difference... In database level I see no difference between these two indexes..

Ivan

I think that has something to do with whether the field will be displayed as search criteria by default in a search view. If select=1, a default search view will have the field added. At least that is what I've experienced with v6. I'm not sure whether it is still valid for v7 and v8.

Deepa Venkatesh
Author

Ya ok, even I feel the same.. thanks anyway :)

Related Posts Replies Views Activity
How to integrate Microsoft Bing IndexNow on Odoo Website?
index indexing
Avatar
Avatar
2
Jun 25
1412
Odoo not index via google
index seo
Avatar
Avatar
1
Mar 25
4715
Does OpenERP indexes documents?
index v7
Avatar
Avatar
Avatar
3
Mar 15
6721
Is adding Indexes to core fields using modules a good idea? Solved
postgresql index override
Avatar
Avatar
1
Jun 23
8554
How to decide when to use select=True
database index odooV8
Avatar
0
Apr 16
3828