首页 > SAP > FIORI > OData Query Options-查询选项汇总
2019
08-27

OData Query Options-查询选项汇总

当READ ODATA时,可以带一些参数进行查询数据,常见的查询选项如下:

Operation Query Option
Filtering and projecting $filter and $select
Sorting $orderby
Client-side paging $top, $skip and $inlinecount
Counting $count
lnlining $expand
Formatting $format

OData specifies a simple yet powerful query language that allows a client
to request arbitrary filtering, sorting, and paging. Via query string
parameters, a client is able to express the amount and order of the data
that an OData service returns.
Query options are essential to reducing or influencing the result set provided
by the SAP Gateway server. In many cases, you don’t wanil: a huge
collection to be returned as is (e.g., the list of all products in the backend
system) if the result set isn’t already filtered based on the user assignment;
for example in an SAP Customer Relationship Management
(CRM) scenario, the service implementation probably only returns the
business partners that are assigned to your user, not all existing business
partners in the entire SAP CRM system.

细节可参看SAP_Press_-_SAP_Gateway_and_OData_(2ed)2016.pdf的88页

最后编辑:
作者:yangsen
本站为个人博客网站,全由我个人维护,我从事SAP开发13年,其它ERP开发7年,基本都是零售行业。本站记录工作学习的过程, 有SAP相关询问专、兼职工作可随时联系我。 有网站相关的问题可直接在文章下方留言,或者联系我。 邮件:yan252@163.com给我。 QQ:415402519

留下一个回复

你的email不会被公开。