AnsweredAssumed Answered

ExecuteSQL and variables

Question asked by dobunzli on Aug 19, 2015
Latest reply on Aug 20, 2015 by taylorsharpe

Hello,

 

I am trying to use "ExecuteSQL" function to obtain linked records (via foreign key). To do that I wish to use a variable in the "ExecuteSQL" function that will contain the id of the initial record.

 

See attached file as example: i have a table "Artist" and a table "Songs". I want to obtain only the songs for a certain Artist.


I am using SeedCode ExploreSQL to generate the code to obtain these songs. I am able to obtain all the songs present the database (see script/button "Get song 1") but not the songs linked to a certain Artist (see script/button "Get song 2")

 

Can someone help me ?

Thanks in advance.

Attachments

Outcomes