[πKR](<https://synctree-guide.notion.site/Query-eb16a23c840e411d9914214714368763>)
This document describes how to register and manage Query and Procedure statements.
βΆ Plan Control
- The Revision Used feature is controlled by your subscribe Plan.
- The automatic generation feature of Bind variable blocks is controlled by your subcribe plan.
|
Free |
Starter |
Plus |
Pro |
Enterprise |
| Revision Used displayed |
Text |
Text |
Text |
Link |
Link |
| Bind variable blocks automatic generation |
- |
- |
- |
β |
β |
βΆ Query management
- Registers Query and Procedure statements that control the DB connected through Query.
1) Create Query
- Create a Query object by clicking the + Create Query button at the top right of Query and creating a name and description for the query, and query (Procedure).
- Depending on your development stage (Dev /Stage / Production / Feature / Hotfix), register a query for each.
- Specify a bind parameter in the form of
:varname.
<aside>
π‘ Example: SQL syntax with bind parameter(:a, :b, :c)
SELECT * FROM users WHERE login_channel in (:a, :b, :c);
</aside>
2) Query List
- When you create a Query, you can check the details created as a list as shown below.