Forum Discussion

Copper Contributor

Mar 27, 2025

How to use operators in URL filters?

Hi! I'm trying to use the Contains filter operator in my modern SharePoint list, and it's ignoring that parameter. I've tried using a greater-than operator with a numeric field, and it also ignores ...

JoyceBeatty

Iron Contributor

Mar 27, 2025

1. Practical application examples
Multi-criteria filtering
url
https://yourdomain.sharepoint.com/_api/web/lists/getbytitle('items')/items?
$filter=Status eq 'In Progress' and DueDate lt datetime '2023-12-31T23:59:59'
2: Fuzzy Matching
url
https://yourdomain.sharepoint.com/_api/web/lists/getbytitle('document')/items?
$filter=substringof('Budget',Title)
3: date range query
url
https://yourdomain.sharepoint.com/_api/web/lists/getbytitle('Meeting')/items?
$filter=EventDate ge datetime'2023-11-01T00:00:00' and EventDate le datetime'2023-11-30T23:59:59'
4. Special Tips
Nested queries:
url
$filter=Department/Title eq 'Finance Department' &$expand=Department
5. Null value checking:
url
$filter=Description ne null
6. sort combination:
url
$filter=Status eq 'Active' &$orderby=Created desc