Support Topics Documentation Slack YouTube Blog

Is it possible to fetch data from multiple tables using codeless?

(Rohan P) #1

Suppose i have 2 tables Person & Country
Person table has name, age, & countryCode
Country table has name & countryCode

how can i fetch name, age & country using codeless?
Can I do it under single Load Table Objects block?

(Stanislaw Grin) #2

If this data is not bundled with relationship, then the only way is to make two different calls to load objects from two tables. But if you define a relation from Person to Country (using countryCode) then you’ll be able to load Person with it’s Country via single call.

(Rohan P) #3

Could you please help me with the blocks, How to add multiple table names and fetch it?

(Stanislaw Grin) #4

You don’t need to add multiple table names, just make two different calls in same way as you do it once. In one variable write result of first call, in second - of another. That’s the logic you should implement.

(Rohan P) #5

Is it not possible to Join two tables and get the data?

(Mark Piller) #6

For the Backendless database or external?

(Rohan P) #7

For external mysql database.

(Mark Piller) #8

You need to create a view with whatever SQL you need and then invoke the view

(Rohan P) #9

Okay, Thank you Mark.