SharePoint / SharePoint/sp-dev-docs
ODATA filtering based on substringof()
Open
@Ashlesha-MSFT is already working on this.
Since May 26, 2025.
feature-request
Needs: Triage :mag:
sharepoint-developer-support
- Dominant language
- PowerShell
- Stars
- 1.4k
- Forks
- 1.1k
- Avg merge
- 4d 12h
- Merged PRs (30d)
- 12
Description
Hi all,
I tried a lot of ways how to create ODATA filter based on substringof function. But I need the oposite function as I need to filter out all item include 'archive' in FileDirRef property, so kind of 'not substringof('archive',FileDirRef). But it isn't a correct syntax of filter query.
I see on this page you can use 'ne' operator, but this also doesn't work for me. Or at least I can't use it.
Any help on that?
BR,
K.Z.
Document Details
⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.
- ID: 916d6284-9149-5d95-48d8-40c60ba9f3c7
- Version Independent ID: 9c41a103-56d6-c186-26aa-ccd098a61f7e
- Content: Use OData query operations in SharePoint REST requests
- Content Source: docs/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests.md
- Service: sharepoint
- GitHub Login: @VesaJuvonen
- Microsoft Alias: vesaj
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.