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
completeTreeSequence__c is a text formula field
this is the result:
Results are wrong beacuse the item 5--> "22.214.171.124.10" should be after the item 6 -->"126.96.36.199.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?