Skip to main content
Tony Lein 님이 #Integration에 질문했습니다
We have been sorting an SOQL query from SOAP for about a year.  We are using an Autonumber feild for descending sorting, this number recently passed 10,000.  Our sorting now looks like:

9000

8000

...

...

10000

Any thoughts on how to fix this?

Thanks,

Tony
답변 5개
  1. 2017년 3월 9일 오후 4:14
    Hi Tony,

    As your auto number field if of 4 digit like {0000}, Hence it's taking first four digit of 10000 So please try to change it to more that 4 digit or go with the below solution.

     

    As a Workaround, you can create a formula field of type number with VALUE(your_autonumber_field) and then sort using this formula field.

    let me know if you have any question.

    Thanks !