Skip to Content
This question has been flagged
python3v15
2 Replies
4231 डेटा देखने का तरीका
अवतार
Corentin MAUDET

Hi everyone,

For my studies, i need to retrive information from odoo to display them on a web server. To do that i'm using python 3

My issue is the following:

I can't get the article information of a fabrication order

i can get basic informations like the number, name, quantity, date... 

With this python code:


fields=['id','name','move_raw_ids','state','product_qty','qty_producing','date_planned_start'] 
mo_list=self.mModels.execute_kw(self.mErpDB,self.mUserId,self.mErpPwd,
    'mrp.production','search_read',
    [[('id','=',mo_dicoIDF)]],
    {'fields':fields})

I have this result:

[13, 'WH/MO/00013', [38, 39], 'confirmed', 1.0, 0.0, '2022-11-15 22:01:39']

But i can't get the article information on the "components" tab


Finally i want to have that: [13, 'WH/MO/00013', Palette1 1140x1140, 0.00, 1.00, Cartons2 35x31x25, 0.00, 35.00, 1.0, 0.0, '2022-11-15 22:01:39']

 

Does anyone know how to help me please?

 

I am not English so sorry if I made mistakes

Thank you for your suggestions

Corentin

अवतार
खारिज करें
अवतार
Kothiya Rajesh, Kothiya Rajesh
Best Answer

Hi Corentin MAUDET

You can get the article information on the "components" tab like this.

for mo in mo_list:
move_raw_ids = mo.get('move_raw_ids',[])
move_raw = models.execute_kw(self.mErpDB,self.mUserId,self.mErpPwd,'stock.move','search_read',[[('id','in',move_raw_ids)]],{'fields':['product_id']})
print('\n move_raw',move_raw)

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

Hello

It works, thanks a lot!!

I have another question, now i get that:

move_raw=====> [{'id': 26, 'product_id': [6, 'Palette3 1200x800']}, {'id': 27, 'product_id': [7, 'Cartons4 57x45x45']}]


I use this code:

for mo_dico2 in move_raw:
    self.mListArticles.clear()
    for X in mo_dico2.keys():
        print(f'mo_dico2====>{mo_dico2}')
        self.mListOFArticle.append(mo_dico2[X])
self.mListArticles.append(self.mListOFArticle.copy())

And i get thas:
mo_dico2====>{'id': 26, 'product_id': [6, 'Palette3 1200x800']}

How can i just get 'Palette3 1200x800' ?

 

Thanks


अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
How can I insert a list of values as the title of an excel sheet? Solved
python3 v15
अवतार
1
दिस॰ 22
4788
How to reset a existing cookie in odoo using python
python3 v15
अवतार
अवतार
1
मार्च 22
5410
How to transfer data in invoice to register payment in odo v15 ?
python3 v15
अवतार
अवतार
2
मार्च 22
4916
Odoo 15 Navbar Customization
python3 v15 UI
अवतार
0
जन॰ 24
3097
How to get image from field.Image in Odoo15 from python Solved
image python3 v15
अवतार
अवतार
1
जन॰ 23
10310