Issue with number (string field) sorting and filtering

Rylie Markle
Tera Contributor

‎08-30-2023 11:13 AM

I am trying to filter out HR Profiles by one specific field we have called "TOP Available" I only want to see profiles with less than or equal to "80.00" in this field. However, when I make the filter, it is not filtering correctly. Please see screenshot below. It it showing me tons of people who have over 80 in this field. 

I also noticed when I was trying to sort by ascending or descending order on this field, that wasn't correct either. This is just a regular string field. Any suggestions?

 

 

RylieMarkle_0-1693419110800.png

 

0 Helpfuls
  • 1,474 Views
3 REPLIES 3

Bert_c1
Kilo Patron

‎08-30-2023 11:58 AM

Convert the field to a 'Floating Point Number' field.

0 Helpfuls

GTSNOW
Giga Guru

‎08-30-2023 12:26 PM

In my view, This is due to string field. Less than will only work for Integer, Floating , dates etc type of field properly not with string. It does filter however you filter has two digit value then 3 value will always be visible as it wont be able to compare.Try to put 100 in your filter and see if it shows right results.

 

If you found my response helpful or relevant to your query, please consider clicking the "Helpful" button or giving it a "Like". This not only helps others identify useful replies but also encourages contributors like me to continue assisting the community. Thank you for your support!

Bert_c1
Kilo Patron

‎08-30-2023 01:04 PM

https://www.servicenow.com/community/developer-articles/for-beginners-why-do-data-types-matter/ta-p/...

is a good place to review. (Found on this page)

0 Helpfuls