Can we have a sequence depend on another sequence

Question

Hi,
I have two fields which i want to convert theme to sequences
the idea is to make a sequence named "rayon" depend on another sequence named "casier"
this *casier *will take just {1,2,3,4,5,6,7,8} and it will *restart *like a *loop*
but the *rayon* sequence *will not* do the increamentation until the *casier restart from 1 *
The Final result should be like this :

*Record 1 : rayon=1 | casier=1*
*Record 2 : rayon=1 | casier=2*
*....*
*Record 8 : rayon=1 | casier=8*
*Record 9 : rayon=2 | casier

Hardik Prajapati (hpr) · Answer

Hi Medmars,
You have to create one record under "ir.sequence" model.
then use this code in your python file.
a = 1
@api.model
def create(self, vals):
global a
if self.env['ir.sequence'].search([('name', '=', '*Record Name*')]).number_next_actual == 9:
self.env['ir.sequence'].search([('name', '=', '*Record Name*')]).number_next_actual = 1
a+=1
t = self.env['ir.sequence'].next_by_code('*Model name*')
inc =self.env['ir.sequence'].search([('name', '=', '*Record Name*')]).number_next_actual
vals['*fi

لقد تم الإبلاغ عن هذا السؤال

Record 9 : rayon=2 | casier=1

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!