Zachary p
Posts: 0
Joined: Sun Jul 20, 2014 11:40 am

How to.. Creating a clickable list from Database?

I am trying to create a clickable list app, not unlike the HTML5/Local storag tutorial, but I'd like to be able to use a DB collection for the values.

To explain further:

Start page- Clickable list item( dynamically displayed from DB collection)
Details page- When clicking on any of the list items, certain values from the DB are displayed.

Is there a tutorial, or can someone point me in the right direction?

Thanks in advance.

Illya Stepanov
Posts: 0
Joined: Mon Mar 18, 2013 8:48 am

How to.. Creating a clickable list from Database?

Hello -

Have you checked our tutorials about how to work with database?
:: http://devcenter.appery.io/tutorials/...
:: http://devcenter.appery.io/tutorials/...

Zachary p
Posts: 0
Joined: Sun Jul 20, 2014 11:40 am

How to.. Creating a clickable list from Database?

I have looked at that tutorial, but it isnt exactly what i am trying to accomplish.

I apologize for leaving this out, but as in the html5/local storage tutorial; When clicking on one of the list items i want to navigate to another page which displays only information for the clicked list item. I understand how the tutorial shows it using routes and tagID, but in the tutorial theyre using an imported xml sheet, and not a database.

I've created hidden labels, tagid, and the id from the database is mapped to it, but Im unsure as to how i can use that to navigate "on click"..

In total scope, I'm trying to create a way to list "stores" on my start page. When clicking on an individual store, navigate to a "store details" page. The "Store details" page displays the database information pertaining to selected store, and also some CRUD functions for selected store.

again, thanks in advance for your help!

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

How to.. Creating a clickable list from Database?

Hello Zachary,

Please look at this link, it should help:
http://devcenter.appery.io/documentat...

Donald
Posts: 0
Joined: Thu Dec 18, 2014 3:04 am

How to.. Creating a clickable list from Database?

I have read all the tutorials and still cannot understand how to get my data from a database rather than XML feed (as in the tutorial). Is there more detailed instruction on how to present a list from a database, pass the value selected from the list, display details about the selected menu item on a new page?

Yurii Orishchuk
Posts: 0
Joined: Fri Feb 14, 2014 8:20 am

How to.. Creating a clickable list from Database?

Hi Donald,

You can make the same as in HTML5/clicked list tutorial.

But with following differences:

  1. Use "list" service to populate list component.

  2. Use "read" service to get needed item and populate with this item details page.

    Regards.

Donald
Posts: 0
Joined: Thu Dec 18, 2014 3:04 am

How to.. Creating a clickable list from Database?

Thank you. I have all these settings in place but do not understand where to create the local variable to hold the id when passed from my startScreen.

Donald
Posts: 0
Joined: Thu Dec 18, 2014 3:04 am

How to.. Creating a clickable list from Database?

Not really but thank you. I created a local variable. I set my click upon success to assign the itemID to the variable. I cannot figure how to get the detail page to use the variable to display the details from my selection.

Donald
Posts: 0
Joined: Thu Dec 18, 2014 3:04 am

How to.. Creating a clickable list from Database?

I have it working now. Thank you for the suggestions.

Return to “Issues”