Stored procedures on free hosted version

Hi,
is it possible to create stored procedures on the hosted edition?

Or alternatively is it possible to filter by two db fields via API?

Regards,

Robert

Robert,

Hey - unfortunately, you’re not able to create stored procedures through the hosted edition. This is because access to phpmyadmin is not granted through the hosted system. You are able to call a stored procedure through the hosted DSP using GET and POST.

Thanks man,

  • Mark

Hey Robert,

Regarding the second part of your question, you can filter with the API on multiple fields with AND / OR clauses and operators, same as you do with regular SQL filters. You can try it out in the API docs by entering your query string in the filter field e.g., age > 5 AND state = “MA”

1 Like

Hi,
thanks for your reply. The filtering works great!

Regards,

Robert

1 Like

cool, glad that helped :slight_smile: