Forum | Appery.io

Hi,

I have a database with the following columns:

opponent1
opponent2
date
network

I want to populate a List UI element with the dates. I can do this (see attached).

But I only want to add unique dates to the list, i.e. there are several rows with the same date. I only want these repeat dates to appear in the list once.

On click of a Date item I then want to display opponent1 and opponent2 on a different page in another List. There might be numerous opponent 1 and opponent2 for one particular date.

How would I go about doing this?

Cheers,
Tim

Let us know if this helps: http://docs.appery.io/documentation/b...

Tim!

Check if the following helps
https://getsatisfaction.com/apperyio/...
https://getsatisfaction.com/apperyio/...
To display on the other screen use Click Event and Navigate to page Action.

Hi guys - unfortunately neither of those links helped...

Please show us what you tried...

Hi,

I just do not know where to start with the links you provided.

Could you help based on the information I provided?

Cheers,
Tim

Did you look at link which Max posted?

Hi,

Yes but I do not understand where the curl requests go? In the Add JS part of the list?

curl -X GET \
-H "Content-Type: application/json" \
-H "X-Appery-Database-Id: 4ffcf6c8e4b0211629c4ad01" \
https://api.appery.io/rest/1/db/colle...=

Hi Tim,

It's the service settings you set up.
http://docs.appery.io/documentation/r...

Ok so should I be putting something in to the where field?

What do I put in there to make it only pull unique dates (see attached screenshot)?