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
|Asked: 7/19/13, 9:11 AM|
|Seen: 1307 times|
|Last updated: 3/16/15, 8:10 AM|