Allows to make the query, which initializes the grid, dependent on custom field values of the containing issue.
Class | init |
|---|
Property | gd.query.parameters |
|---|
Formal specification | gd.query.parameters=issuevalue [, issuevalue] |
|---|
Required | no |
|---|
Default |
|
|---|
Version | 1.0 |
|---|
Comment | * the gd.query can contain parameters that are marked {0}, {1}, {2}..., - each value {n} will be replaced with parameter value from gd.query.parameters, where the first parameter is labelled {0}.
- an issuevalue is a value of the containing issue
- when you need to quote the parameter (as it is a string), use single quotes ('), as this is accepted by all databases.
Check the issue values page for an overview of all the issue values which can be used.
Check the grid refresh page which details how the grid will be refreshed when the dependent parameters change.
|
|---|
Example | Following query selects all customers from a specific state, as selected in the customfield. ...
gd.columns=name, city, revenue
gd.query = select name, city, revenue from customers where state = '{0}'
gd.query.parameters = customfield:10010 ...
|
|---|
Reference | Grid reload
issue values
gd.query
gd.query.ds
gd.query.columns
gd.query.keepOnRefresh |
|---|