"WHERE" in RPC Web module request (6.1)

Question

Hi,
I'm trying to make a RPC request. I want to select records where name="Smith".
I'm using OpenERP 6.1, and I'm building a web module. This code is in a custom widget :
this.rpc('/web/dataset/search_read', {
model: 'people',
fields: field || false,
domain: this.view.domain,
context: { 'name' : 'Smith'},
offset: 0,
limit: false
}).pipe(function (result) {
self.ids = result.ids;
self._length = result.length;
console.log(result.records);
})
I tried to use Context parameters, but it doesn't work,

IBS Group · Accepted Answer

You have to add a filter to the domain, like this:

this.rpc('/web/dataset/search_read', {
model: 'people',
fields: field || false,
domain: [ ['name', '=', 'Smith'] ],
offset: 0,
limit: false
}).pipe(function (result) {
self.ids = result.ids;
self._length = result.length;
console.log(result.records);
})

xiaolong97427 · Answer

How can I find the description of all these RPC method ? The below links didn't give all option of the search_read

method, nor the url to call: /web/dataset/search_read

https://www.odoo.com/documentation/9.0/api_integration.html
http://odoo-new-api-guide-line.readthedocs.org/en/latest/environment.html#search-read

saad · Answer

I think you should remove { 'name' : 'Smith'} to the fields parameters

this.rpc('/web/dataset/search_read', {
model: 'people',
fields: { 'name' : 'Smith'},
}).pipe(function (result) {
self.ids = result.ids;
self._length = result.length;
console.log(result.records);
})

IBS Group · Answer

Try it this way:

this.rpc('/web/dataset/search_read', {
model: 'people',
fields: field || false,
domain: this.view.domain,
name: 'Smith',
offset: 0,
limit: false
}).pipe(function (result) {
self.ids = result.ids;
self._length = result.length;
console.log(result.records); })

Related Posts	ตอบกลับ	มุมมอง
How to find the view_id using rpc call from JavaScript javascript rpc	2 ม.ค. 23	5967
Catch is not a function javascript rpc	0 ก.พ. 21	3842
rpc.query doesn't work javascript rpc odoo	1 ส.ค. 23	411
How to use RPC query in JavaScript with search method in Odoo 11 / 12? javascript rpc odoov11	1 ก.ย. 21	21034
rpc.query function in js not working when I am not logged in แก้ไขแล้ว javascript rpc v14	2 เม.ย. 21	4950

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!