Hi,
I am new to Appery, and I am having some issues with grouping results from the database.
I am using a Collapsible with a list in the content area. Let us say I have a database with two columns, name and city, and with several people in each city. I want to show Collapsibles of all cities (no duplicates) and when I expand it a list with the people in the city should appear.
My problem is that I get the same city several times.
Hi Gøran,
Unfortunatly Apperyio REST api don't allows you to group items.
I can suggest you following way to do it:
1 Create DB:
1.1. Cities: (name:string)
1.2. People: (name: string, city: pointer_toThe_Cieties.)
Create "server code" that will:
2.1. Get all cities.
2.2. Iterate through all received cities and make separate requests (with filter by each city) to People collection.
2.3. Combine this in nested arrays response like:
precode
[
{name: "Boston", peoples: [{name: "user1"}, {name: "user2"}] }
];
/code/pre
User this server code as service in Appery.io application.
Create two-level mapping like on screen shot: http://prntscr.com/4ggek8/direct
Regards.
Hi Yurii,
thanks! Is it also possible to get the distinct Cities from the People collection and then run separate requests for each distinct City?
And on point 2.3; this is an example of a response I get back from the requests, right? So the number of people in each city can be entirely dynamic with this solution?
BR
Gøran
Hi Gøran,
Yes you can do it with Appery,io REST api.
But in suggested DB you don't have not distinct values is not it? I specifically suggested normalized DB structure to prevent data duplicating.
Yes - peoples - in this example is array and could have number of items from 0 to infinity.
Regards.
Can this be done by mapping it out to local storage first?
Hello Sebastian,
Could you please specify the approach you want to try with more details?