This document describes how to register and manage Query and Procedure statements.
Index
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.
Example: SQL syntax with bind parameter(:a, :b, :c)
SELECT * FROM users WHERE login_channel in (:a, :b, :c);
2) Query List
•
When you create a Query, you can check the details created as a list as shown below.
No. | Function |
1 | Query search is a search condition, and if you do not select it, it will not be properly retrieved. |
2 | A property of the Query List that allows you to sort by Query Name and Creation Date. |
3 | Shows information about the BizUnit that is using the query, and clicking the Revision Name takes you to the corresponding BizUnit page.
This is the same as Revision Used on the feature button. |
4 | Edit the query with the function buttons.
Also click Query Name to open the popup. |
Example of using Query in Nblock
•
The Query block is used in conjunction with the Storage block, and is invoked by selecting the desired query from the Query list.
•
If the query contains bind parameters, a parameter block is automatically created for the number of bind parameters.
