Smartstaff, administrator
4,478
edits
Changes
no edit summary
# Enable the Internet Enabled checkbox '''if you wish the data to be public
'''
==Syntax==
1. Search syntax i.e. criteria on report using “???”: the URL below returns OData records with firstname equal ‘steve’ only
<pre>http://localhost/OData/V4/pub/113/Service.svc/report_Neo_records?$search=steve</pre>
2. Filter for dynamical search: the URL below returns OData records with firstname equal ‘steve’ only (eq stands for equal in OData protocol)
<pre>http://localhost/OData/V4/pub/113/Service.svc/report_Neo_records?$filter=first_name +eq+steve </pre>
3. Ordering: the URL below orders by first name
<pre>
http://localhost/OData/V4/pub/113/Service.svc/report_Neo_records?$orderby=first_name+asc
or
http://localhost/OData/V4/pub/113/Service.svc/report_Neo_records?$orderby=first_name
</pre>
4. $top and $skip, used mainly for pagination: The syntax below skips 3 records and return 2 records only (i.e. only 4th and 5th will return)
<pre> ?$top=2&$skip=3</pre>
=See Also=
* [[Reports]]