Skip to Content
This question has been flagged
ormsearchandmethod
1 Reply
17122 डेटा देखने का तरीका
अवतार
Vaibhav

Hello,

I have override search method and I wanted to filter out sales Order with following Condition. Condition / search criteria : 

       [ state ='RESERVED' OR (state ='SHIPPED' AND avail='YES') AND invoiced='YES']

How to give above condition in following search method.?

  <obj_name>.search(cr, uid, [])

what are contents of [ ] ?

अवतार
खारिज करें
Andreas Brueckl

What do you mean with avail='YES'? Is this a custom field?

Vaibhav
लेखक

yes avail is custom field having selection type with values YES or NO, but i am confused that how to write OR AND conditions in search method ?

अवतार
Serpent Consulting Services Pvt. Ltd.
Best Answer

Vaibhav,

[ state ='RESERVED' OR (state ='SHIPPED' AND avail='YES') AND invoiced='YES']

should be: [(invoiced =Yes),'|',(state=reserved),(state ='SHIPPED'),(avail='YES')]

Thanks.

अवतार
खारिज करें
Vaibhav
लेखक

Thanks...:)

Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
How to modify default search behaviour - AND by default instead of OR ? Solved
search and
अवतार
अवतार
1
दिस॰ 25
7671
Planned(assigned) quantity , search
search method
अवतार
अवतार
1
जून 19
3897
Retrieving multiply ids of same table
search method
अवतार
अवतार
1
दिस॰ 18
4384
check field in other model in method
search method
अवतार
अवतार
1
अप्रैल 17
6211
Using search count Solved
orm search
अवतार
अवतार
अवतार
2
दिस॰ 23
22073