list of records not showing when we put condition Less than

[chanikya]

Hi ,

we have score field(Type Decimal). 
Score field would be editable to Admins, and to all others it would be read-only..
we have list of incidents with different scores 0 to 4 ( example : 0.2,0.3,.....1, 2,3 .....3.4,3.7,.......4.1,4.6,4)

I impersonated with one of group member who is not admin and  put condition "active=true^u_score=4" in list view . he can able to see list of records.

but when change condition to "active=true^u_score<4" (less than) list of records not showing . why less than condition is not working for him ?

it worked when we put score|is|4, but it didn't work when we put score|less then|4.

Kindly let me know what might be the issue.

[Voona Rohila]

Hi @chanikya 

What is the field type of 'Score' field?

If decimals are acceptable then please make sure the field type is 'Floating point number' or 'Decimal'.

[chanikya]

Hi @Voona Rohila , thanks for your reply.

so now do I need to change field type to "floating point number" ?
But Decimal type also fine right ?
for admins it is working when we put score|less then|4
for non-admins not working when we put score|less then|4

we have huge records in system, based out of that field we have scripts in PROD also. I believe we can't change field type now.

[Voona Rohila]

Decimal type also works and yes I would also not recommend to change the type if data is already present.

[James Chun]

Hi @chanikya,

It sounds like you need to create a 'query_range' ACL to allow the non-admin to do a query on the 'score' field.

The following article provides a good explanation of what it is - Query ACLs - ServiceNow Community

Hope that helps, cheers