Tim Childs
Posts: 0
Joined: Thu Aug 01, 2013 3:35 am

Show unique items in List UI element

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 Image

Alena Prykhodko
Posts: 0
Joined: Tue Apr 09, 2013 7:36 am

Show unique items in List UI element

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.

Tim Childs
Posts: 0
Joined: Thu Aug 01, 2013 3:35 am

Show unique items in List UI element

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

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Show unique items in List UI element

Please show us what you tried...

Tim Childs
Posts: 0
Joined: Thu Aug 01, 2013 3:35 am

Show unique items in List UI element

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

Igor
Posts: 0
Joined: Tue Apr 02, 2013 12:05 pm

Show unique items in List UI element

Did you look at link which Max posted?

Tim Childs
Posts: 0
Joined: Thu Aug 01, 2013 3:35 am

Show unique items in List UI element

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...=

Kateryna Grynko
Posts: 0
Joined: Thu Nov 15, 2012 9:13 am

Show unique items in List UI element

Hi Tim,

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

Tim Childs
Posts: 0
Joined: Thu Aug 01, 2013 3:35 am

Show unique items in List UI element

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)? Image

Return to “Issues”