Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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 ''
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
4
maalisk. 25
|
10805 | ||
|
4
maalisk. 25
|
11086 | ||
|
0
heinäk. 22
|
1915 | ||
|
2
helmik. 21
|
7374 | ||
|
4
lokak. 20
|
10447 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
