Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I have customer reference number like
FKM200,
ABD400,
DEF100,
ABD220,etc...
I want to sort the above reference number like :
DEF100,
FKM 200,
ABD220,
ABD400, ...
I have query = SELECT customer_id FROM res_partner order by CAST(SPLIT_PART(customer_id, '-', 2) AS INTEGER)"
But my function is not working.
Please help me
Hi,
If your pattern is fix like first three character is alphabates and another three character is numbers then you can achieve your objective using below query.
select ref from res_partner order by substr(ref,4,3)
It will return result as you have describe into your question.
I hope it will help you.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
can u post your total code