Importing query library into resource query

Queries and Resources
#1

Let's say I have created a query in the query library called query1. Now, I wanted to call that query onto the resource query like
SELECT * FROM query1

Is there any alternative to achieve this? Import a query1 while creating the apps and then calling this query into another?

#2

Hi neeharika_kusampudi,

By default we block dynamic mappings into the SQL query for security reasons (SQL injection) and convert them to prepared statements. If you accept the risks that come with this you can disable this setting by checking the box "Disable converting queries to prepared statements" on the resource settings page.

Please see the following post for a bit more detail:
https://community.retool.com/t/how-do-i-write-a-sql-update-with-dynamic-columns/2049

1992×764 46.8 KB

Did that answer your question? Let me know if not.

Thanks!
Grace

#3

Thank you Grace. I wouldn't want to mess with it includes risk. Thanks for letting me know.