.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

OData and String Comparison Filters In SharePoint

Posted By:Jean Paul       Posted Date: April 30, 2016    Points: 200    Category: SharePoint    URL: http://www.dotnetspark.com  

In this post we will explore String Comparison filters of OData. In the upcoming posts we can test each of them against list items.
 

In this post we can explore the String Comparison Filters of OData using SharePoint 2013 REST API.

String Comparison Filters

Following are the String Comparison Filters in OData.

startswith

This filter returns the field values starting with specified string.

Please note that the method-name is case sensitive & only lower case works.

substringof

This filter returns the field values containing specified string.

Please note that this is case sensitive & only lower case works.

length

This filter returns the values whose length is greater than specified number.

Please note that this is case sensitive & only lower case works.

replace

This is an operational method and replaces the string with given value.

tolower

To convert field values to lower case.

toupper

To convert field values to upper case.

OData stands for Open Data Protocol. OData allows Filtering & Interoperability on REST services. We combine OData along with REST methods.

So REST + OData allows gives more flexibility in querying & filtering items.

References

http://bit.ly/1gixNRv

Summary

In this post we have explored String Comparison filters of OData. In the upcoming posts we can test each of them against list items.


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend