This post is part of the SAP Build Community Challenge (April 2023)
We're going back to SAP Build Apps for this week's challenge.
Probably the most important thing you will do with one of your SAP Build app is to access SAP data, like in S/4HANA or SuccessFactors backends. And you will generally do this using an OData service. So we want to challenge you to use some of the OData features in the tool – for paging, filtering and sorting the data from OData calls.
In the challenge, you will start with an app we will give you, which fetches data from Northwind, and you will have to use the OData settings to bring back a specific subset of the data.
As a bonus, you will also learn about SAP Build Apps eventing, since the project we give you has eventing for retrieving the data.
Since we wanted the fetching of data to occur for a variety of events, we created our own event called GetData on the page’s logic canvas, and tied the fetching to that event. Then, the event could be called from any other logic canvas.
To learn more, see:
Out of the box if you run the app it will look like this:
The Previous and Next buttons will not work. You will have to implement them.
We have already given you a page variable page (Number) to keep track of the current page, and a data variable Customer1 to hold the data fetched from Northwind.
It should look something like this (with your name, of course), but the records will be different. To accomplish the challenge, the correct records must be shown.
And feel free to Kudo this post and all the challenges.
Add in your post the name of the animated movie in which the song "Escape" (often known as the Pina Colada song) is played, and describe in 1 sentence the scene in which it appears.
Add the movie and scene description to your entry, and then go enjoy a Pina Colada (or your favorite drink).
Hi @dan_wroblewski ,
Here is my output over challenge No. 4
i was able to achieve optional tasks as well.
The animated movie in which the song "Escape" (often known as the Pina Colada song) is played is Shrek (2001), and it appears in a scene where Shrek and Donkey enter the castle to rescue Princess Fiona.
That's a great job 😺
You had me all the way until you said the song was when Shrek and Donkey enter the castle ... I don;t remember that scene ... does it really play? The scene I know is when the Lord Farquaad chooses Fioni in the mirror.
Thanks for this challenge that I could manage directly with my OData Know How and in challenge 1 and 2 acquired SAP Build knowledge.
Regarding the movie, I am not familiar with ''Shrek'' and the Pina Colada song (but I like the cocktail) and I do not know the scene “when Lord Farquaad picks Princess Fiona from the Magic Mirror's dating game as part of his plan to marry her and become king“. Thankfully many other knew this.😊
Thanks for the details in challenge steps, it became self-explanatory. I quite enjoyed it, now only one challenge left to conquer.
though I am fan of animation movies however I did not watch Sherk, not sure why 😅
However I cannot understand by only triggering event GetData and setting paging in Get record collection handles the request for next 5 records for each page
In the page logic canvas, I have defined an event (GetData) that will retrieve data by executing Get record collection flow function ... I did this to show you the eventing feature. Show for the Next button all you have to do is trigger GetData and the records are retrieved. Is that what you are asking?