Hi, It is because field is string and numbers are getting sorted lexicographically.It has nothing to do with number of digits.
Thanks Saurabh On Thu, Jul 23, 2020, 11:24 AM Srinivas Kashyap <srini...@bamboorose.com.invalid> wrote: > Hello, > > I have schema and field definition as shown below: > > <fieldType name="string" class="solr.StrField" sortMissingLast="true" > omitNorms="true"/> > > > <field name="TRACK_ID" type="string" indexed="true" docValues="true" > /> > > TRACK_ID field contains "NUMERIC VALUE". > > When I use sort on track_id (TRACK_ID desc) it is not working properly. > > ->I have below values in Track_ID > > Doc1: "84806" > Doc2: "124561" > > Ideally, when I use sort command, query result should be > > Doc2: "124561" > Doc1: "84806" > > But I'm getting: > > Doc1: "84806" > Doc2: "124561" > > Is this because, field type is string and doc1 has 5 digits and doc2 has 6 > digits? > > Please provide solution for this. > > Thanks, > Srinivas > > > ________________________________ > DISCLAIMER: > E-mails and attachments from Bamboo Rose, LLC are confidential. > If you are not the intended recipient, please notify the sender > immediately by replying to the e-mail, and then delete it without making > copies or using it in any way. > No representation is made that this email or any attachments are free of > viruses. Virus scanning is recommended and is the responsibility of the > recipient. > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and others > authorized to receive it. If you are not the recipient, you are hereby > notified that any disclosure, copying, distribution or taking action in > relation of the contents of this information is strictly prohibited and may > be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place for > your human generated data. Specializing in; Security, archiving and > compliance. To find out more visit the Mimecast website. >
