Category: How do I do X?
Updated

This solution is summarized from an archived support forum post. This information may have changed. If you notice an error, please let us know in Discord.

How to create query builder?

Issue

I am trying to create a query builder and encountered an error where the additional quotes added by Appsmith break the SQL. I asked for a solution and was advised to turn off Use Prepared Statement which solved the issue. I also suggested that having a reference in the docs for query builders would be helpful.

Resolution

The user wanted to create a query builder in Appsmith, but encountered errors where extra quotes were added to the SQL code. The solution was to turn off the "Use Prepared Statement" option. This resolved the issue, allowing the query builder to work properly. The user also suggested that having a reference or documentation for creating a query builder in Appsmith would be helpful.