Skip to Content
This question has been flagged
searchcomputed-fieldsv14
1 Reply
5171 डेटा देखने का तरीका
अवतार
SmithJohn45

hi all,

I want to search string like using postgresql substr and position, how i can do this in odoo

a  = fields.Char(default='ABCD-XYZ-MNOP')

if i want to search XYZ (it can be anything else like 'Smith' or 'John' etc.), search between 2 '-' characters, the '-' characters are here for the formatting which will used by default. how i can do it with  onchange function using a compute field.

here is screenshot what i did in Oracle using simple SQL:


regards

अवतार
खारिज करें
अवतार
SmithJohn45
लेखक Best Answer

ok, got help from @SDBot (thanks to him) on stackoverflow as below, its working fine.

class UserInfo(models.Model):
    _name = 'tests.userinfo'
    _description = "Test User Information"
    userid = fields.Many2one('res.partner', string='Select User')
    cnic = fields.Char(string='CNIC', store=True)
    cnic_ess = fields.Char(compute='_compute_cnic', store=True)
    @api.onchange('cnic')
    def _compute_cnic(self):
        for rec in self:
            split_str = (rec.cnic or '').split('-')
            rec.cnic_ess = split_str[1] if len(split_str) > 1 else ''
अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Compute Field Value dos't get updated after adding Store = True
computed-fields v14
अवतार
अवतार
अवतार
4
मार्च 25
12303
compute function not called on create
computed-fields v14
अवतार
अवतार
अवतार
अवतार
4
मार्च 25
12829
Search Loop Infinite On Customer Page
search Community v14
अवतार
0
जुल॰ 22
2622
ver.14: how to add Category filter to show products in website /shop Solved
search category v14
अवतार
अवतार
2
फ़र॰ 21
8316
Strange error while computing fields with odoo Studio: Module <module 'time' (built-in)> can not be used in evaluation contexts
bug computed-fields v14
अवतार
अवतार
4
अक्तू॰ 20
11708