Hairulnizam
Posts: 0
Joined: Tue Dec 30, 2014 7:31 am

Creating query from the list

So this is my problem.

Image

each column is derived from separate table. My problem is that, whenever i tried to mapped the list of products, the price of the products (retrieved from query) isn't appear, unless i remove the $ mapped to the gridlist.

Image

is it possible to do query inside list?

Hairulnizam
Posts: 0
Joined: Tue Dec 30, 2014 7:31 am

Creating query from the list

Image

here's the mapping for the price of one of the item

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

Creating query from the list

Hi Hairulnizam,

If you have needed data for this list in several collections you should combine items from several collections into single response and then use this response to populate the list:

So brief plan is:

  1. Create generic service. Details are here: http://devcenter.appery.io/documentat...

  2. In this generic service - you can invoke as much other services as you need.

  3. Get all results from all needed services and combine them into one response.

  4. Return this response in success/complete events.

  5. Use generic service to populate your list.

    Also here is one more way - to use server code. In this case solution is:

  6. Create server code. Details: http://devcenter.appery.io/documentat...

  7. In this server code - get all needed data from different collections, combine this data on single response and then return it.

  8. Create server code service and use this service to populate your list.

    Regards.

Return to “Issues”