Hi Thamizh You can add a field to the index that acts as a "sortable flag" with e.g. 0 for alpha, 1 for numerical, and 2 for other first character. Then you can sort on both fields, listing the "flag" field first.
Thomas Op zo 29 aug. 2021 20:09 schreef <post.ta...@gmail.com>: > Hi, > > > > We need to sort the results based on alphabetic followed by numeric. > Something like below > > > > Current results order: > > 1test > > 2test > > 3test > > Abctext > > Bbctext > > Cbctext > > > > Expected results order: > > Abctext > > Bbctext > > Cbctext > > 1test > > 2test > > 3test > > > > Please help me to achieve the result ordering as above. > > > > Thanks, > > Thamizh > > > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus >