SQL Database Connector: parameterizing a list

[joeyg]

Here’s a thread that should help:

SQL query with List parameter

I am using the Bubble SQL API Plugin and have successfully done so for many queries. My current query has a list of numbers as one of the parameters. Select top 100 tbl1.AppointmentID, tbl1.ClientID, tbl2.AppType, tbl1.Date, tbl3.UserName as Bookedby, tbl4.UserName as Clinician, tbl5.LocName from Appointments tbl1 inner join AppTypes tbl2 on tbl1.Apptypeid = tbl2.AppTypeId inner join Users tbl3 on tbl1.CreatedByID=tbl3.UserId Inner join users tbl4 on tbl1.UserId=tbl4.UserID Inner join l…

For future SQL Database Connector questions, I’ve found searching the forum for “SQL” can return a lot of valuable information.