Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Q Analyzer - Parameterized Scripts |
| Version | 10.0 |
Aqua Data Studio allows you to enter substitution variables (with &, e.g. &engineer_id), that’s fine.
Would be nice however if it would remember the values filled out last time.
select * from ActionLog where ActionTaken = '\&Name2=Ivan'
select * from ActionLog where ActionTaken = '\&Name3=IvanGron'
GO
How to get there:
1. enable Parameterized Script (button next to Max Results:)
2. enter a query with parameter (see examples)
3. execute
Additional requirements:
- There is a way to add a default value. This default value will be overriden by the last value entered by the user. Add "Default Values" button to reset the values to default values, or clear if no default values have been set.
- these previously entered parameter values will be remembered per query analyzer window, and will be discarded on the application exit.
How to get there:
1. enable Parameterized Script (button next to Max Results:)
2. enter a query with parameter (see examples)
3. execute
Additional requirements:
- There is a way to add a default value. This default value will be overriden by the last value entered by the user. Add "Default Values" button to reset the values to default values, or clear if no default values have been set.
- these previously entered parameter values will be remembered per query analyzer window, and will be discarded on the application exit.
Issue #5802 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
breaks #12541
Issue #12541Parameter substitution does not work in Query Analyzer when parameter name continas single quote |
select * from ActionLog where ActionTaken = '\&Name2=Ivan'
select * from ActionLog where ActionTaken = '\&Name3=IvanGron'
GO