Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello All
I applied query in code for getting values and I received values, but these values came randomly not 'ORDER BY'. So, How to get these values as i defined?
Below is my query and it's o/p:
"""select distinct src, field_description, value from ir_translation, ir_model_fields where module='P2N_Sales' and ir_translation.src = ir_model_fields.field_description and model='sale.mail.wizard' and ir_model_fields.name in ('status','order','customer','pet_name','services', 'amount','msg');"""
you can just add order by in your query.
eg:
select distinct src, field_description, value from ir_translation, ir_model_fields where module='P2N_Sales' and ir_translation.src = ir_model_fields.field_description and model='sale.mail.wizard' and ir_model_fields.name in ('status','order','customer','pet_name','services', 'amount','msg') order by fields_name asc/desc
Hello Hilar, Problem in not fixed yet.
 |
|
Hello Hilar
I want record according to i assign in query ('status','order','customer','pet_name','services', 'amount','msg')
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
