Accessing data from a Related Table using Appery

[Shailvi Tyagi Wakhlu]

Hello,

I had a question regarding access to data from a related table. I am using an external database, and connecting using a rest api service, which is working fine in all other cases. Assume there are 2 tables:

1) "User_Test": This contains a test_id for the test conducted for a user.
2) "Test_List": This contains a list of all tests. The primary key here (id) is the same as test_id in the "User_Test" table. There is a one to many relation between "Test_List" and "User_Test"

Goal : I would like to display the LIST of all corresponding "test_list" names for all "user_test" records, and not just the ID which is stored in "user_test" table.

While it is easy to get and display the related table data in a web application, its not entirely obvious how to do that here.

Can you suggest how this can be accomplished? Thanks!

[Bad Addy]

If you are using any type of relational table (SQL etc), perhaps a 'view' would be better. I cannot think how REST could manage your goal? Also need to consider the load it would carry.

Just an idea

[Kateryna Grynko]

Hello,

You should do this on your side (Database server) and return a ready JSON/XML to Appery.io. Everything depends on your Database structure.