I'm facing a problem with the SOQL ORDER BY
. I'm quering on a custom object with this query
SELECT completeTreeSequence__c
FROM CPQ_Line__c
WHERE CPQ_Header_RU__r.Id = 'a043E000005PfD7QAK'
ORDER BY completeTreeSequence__c ASC
LIMIT 10
where completeTreeSequence__c
is a text formula field
this is the result:
Results are wrong beacuse the item 5--> "1.1.2.1.10" should be after the item 6 -->"1.1.2.1.1.1".
I think the "10" is interpreted as "1" and this is why it comes with the wrong order.
Does anyone has faced this error and solved it?