Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
search function not working [Closed]
The Question has been closedby
I've got a table, agreement_account_periodical_invoice, which contains records.
when i search this table, using search() like this:
agreement_model = self.pool.get('account.periodical_invoice.agreement') agreement_ids = agreement_model.search(cr,uid,)
agreement_ids should contain ALL ids from that table, right?
My problem is that it returns an EMPTY list?!
And when i use browse i do get a record???
agreement = agreement_model.browse(cr,uid,)
The documentation tells that specifying an empty list in search() returns all records?? Or is my english that bad i don't understand the sentence 'all records'?
if i check the table with an sql-client, the record (1) is really there. Why isn't search() showing that existing id??
Reposted as an answer instead of a comment:
I found the solution:
When a table has a column 'Active:boolean', search() will NOT return the rows with 'Active:false'
This should/could at least be documented in the openerp docs. Now it says search() with an empty condition returns ALL records. This is not true, it returns only the rows with 'Active:true' (if a table has such a column)
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 7/19/13, 9:11 AM|
|Seen: 1472 times|
|Last updated: 3/16/15, 8:10 AM|