You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@olingo.apache.org by "Tuo, Erming" <er...@sap.com> on 2018/01/10 18:26:06 UTC
How to get $count and pagination on the navigational property
Hi,
Quick question, take the following example
GET /odatav4/school-service/vi1/Teachers(‘jsmith’)/students?$count=true
Students is a navigational property of Teachers. The above link obviously won’t work because $count only applies to the root entity, which is just one because of the PK. So, here are the questions –
1. How to get total count for the list based navigational property Students?
2. Is it possible to paginate on Students with above URL?
Help will be greatly appreciated.
thx
Erming Tuo
LMS software Development Archi
SAP SuccessFactors | 2000 Edmund Halley, Reston, VA
US +1 703-678-0615
[id:E0BBB916-1B85-490F-B852-EA52F290EC0D]
This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.
Re: How to get $count and pagination on the navigational property
Posted by Ramesh Reddy <ra...@redhat.com>.
1) The $count=true as parameter only advises the service includes the total
number of students on the first page of results. It applies to the response
entity collection in this case students not just root entity
2) Yes
Ramesh..
http://teiid.org
On Wed, Jan 10, 2018 at 12:26 PM, Tuo, Erming <er...@sap.com> wrote:
> Hi,
>
>
>
> Quick question, take the following example
>
>
>
> GET /odatav4/school-service/vi1/Teachers(‘jsmith’)/students?$count=true
>
>
>
> Students is a navigational property of Teachers. The above link obviously
> won’t work because $count only applies to the root entity, which is just
> one because of the PK. So, here are the questions –
>
>
>
> 1. How to get total count for the list based navigational property
> Students?
> 2. Is it possible to paginate on Students with above URL?
>
>
>
> Help will be greatly appreciated.
>
>
>
> thx
>
>
>
> *Erming Tuo*
>
> LMS software Development Archi
> SAP SuccessFactors | 2000 Edmund Halley, Reston, VA
> <https://maps.google.com/?q=2000+Edmund+Halley,+Reston,+VA%0D+US+%2B1%C2%A0703&entry=gmail&source=g>
>
> US
> <https://maps.google.com/?q=2000+Edmund+Halley,+Reston,+VA%0D+US+%2B1%C2%A0703&entry=gmail&source=g>
> +1 703-678-0615 <(703)%20678-0615>
>
>
>
> [image: id:E0BBB916-1B85-490F-B852-EA52F290EC0D]
>
>
> This e-mail may contain trade secrets or privileged, undisclosed, or
> otherwise confidential information. If you have received this e-mail in
> error, you are hereby notified that any review, copying, or distribution of
> it is strictly prohibited. Please inform us immediately and destroy the
> original transmittal. Thank you for your cooperation.
>
>
>
>
>
Re: How to get $count and pagination on the navigational property
Posted by Ramesh Reddy <ra...@redhat.com>.
1) The $count=true as parameter only advises the service includes the total
number of students on the first page of results. It applies to the response
entity collection in this case students not just root entity
2) Yes
Ramesh..
http://teiid.org
On Wed, Jan 10, 2018 at 12:26 PM, Tuo, Erming <er...@sap.com> wrote:
> Hi,
>
>
>
> Quick question, take the following example
>
>
>
> GET /odatav4/school-service/vi1/Teachers(‘jsmith’)/students?$count=true
>
>
>
> Students is a navigational property of Teachers. The above link obviously
> won’t work because $count only applies to the root entity, which is just
> one because of the PK. So, here are the questions –
>
>
>
> 1. How to get total count for the list based navigational property
> Students?
> 2. Is it possible to paginate on Students with above URL?
>
>
>
> Help will be greatly appreciated.
>
>
>
> thx
>
>
>
> *Erming Tuo*
>
> LMS software Development Archi
> SAP SuccessFactors | 2000 Edmund Halley, Reston, VA
> <https://maps.google.com/?q=2000+Edmund+Halley,+Reston,+VA%0D+US+%2B1%C2%A0703&entry=gmail&source=g>
>
> US
> <https://maps.google.com/?q=2000+Edmund+Halley,+Reston,+VA%0D+US+%2B1%C2%A0703&entry=gmail&source=g>
> +1 703-678-0615 <(703)%20678-0615>
>
>
>
> [image: id:E0BBB916-1B85-490F-B852-EA52F290EC0D]
>
>
> This e-mail may contain trade secrets or privileged, undisclosed, or
> otherwise confidential information. If you have received this e-mail in
> error, you are hereby notified that any review, copying, or distribution of
> it is strictly prohibited. Please inform us immediately and destroy the
> original transmittal. Thank you for your cooperation.
>
>
>
>
>