Page 1 of 1

Join 2 datasets

Posted: Sat Jul 30, 2016 10:08 am
by Deon

Hi

How do you join 2 different datasets?
One dataset contains info of a product. The other dataset contains the image of the product. The product info dataset contains the id of the image residing in the image dataset.

I need to display the image and some of the product info in a list. it is like creating a select join

How would i create a join in appery mappings?
Thank you


Join 2 datasets

Posted: Sat Jul 30, 2016 11:05 pm
by Evgene Karachevtsev

Join 2 datasets

Posted: Sun Aug 07, 2016 1:01 pm
by Deon

Thanks Evgene
The data resides in an external rest database. I am using an API to pull the data. I cannot define pointer fields in this external database.


Join 2 datasets

Posted: Sun Aug 07, 2016 1:43 pm
by Serhii Kulibaba

Hello,

Please clarify, do you want to connect two separated databases with a pointer value? It is impossible to do. It is possible to use pointers only in the one database.


Join 2 datasets

Posted: Fri Aug 12, 2016 8:41 am
by Deon

Hi Sergiy
It is one database. Different collections/tables.
Thank you


Join 2 datasets

Posted: Fri Aug 12, 2016 1:09 pm
by Serhii Kulibaba

Please look at this documentation how to include related objects in the request: https://docs.appery.io/reference#data...