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.

[chanikya]

Hi @James Chun , thanks for your reply.

Ok.. Let me create query_range aCL and test it once please.

[syedhanan19]

It sounds like a permissions issue. Since the field is read-only for non-admins, the “less than” filter may not work properly for them, even though exact matches do. You might need to check the ACLs on the score field for that user role.

[kaushal_snow]

@chanikya ,

The reason your list condition of u_score < 4 isn’t returning records likely comes down to one of these two things: either the user list filter context isn’t evaluating decimals properly (for example the field is Decimal type but the condition value is treated as string or integer) or there is a security/acl or domain restriction that hides records for non admins when using less than operators........ In your case, since the filter u_score = 4 works but u_score < 4 doesn’t, check these things: confirm the field is indeed Decimal (not string), check whether there are hidden decimals (e.g., values like 3.9999 that are technically less than 4 but display as 4) and ensure the filter value is typed appropriately (e.g., 4 vs 4.0) and finally review whether there’s a domain or ACL blocking non admins from seeing records when operator less than is used.......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.