inline parameters method
- svitlana (Deactivated)
Owned by svitlana (Deactivated)
Inline parameters replace the query.parameters properties
The inline parameters method is an alternative for the gd.query.parameters - deprecated and col.xyz.query.parameters - deprecated approach to inject values into queries.
Now you can construct a query by specifying the issue values and/or customfield value inline as in
...
gd.query = select a, b, c, d
from myTable
where e = {currentuser:id}
...
Â
...
col.mylist.type = list
col.mylist.query = select a, b, c from myTable where e = {customfield:10401}
...instead of the more complexÂ
...
gd.query = select a, b, c, d
from myTable
where e = {0}
gd.query.parameters = currentuser:id
......
col.mylist.type = list
col.mylist.query = select a, b, c from myTable where e = {0}col.mylist.query.parameters = customfield:10401
...
How to cascade selections
If you want to cascade a selected value from one column to a subsequent column you can construct your grid configuration as follows
...
col.country = Country
col.country.type = list
col.country.query = select country, countrycode from citytable
col.country.query.ds = erp
...
Â
#
# Cascade the selected country to the city dropdown
#
...
col.city = City
col.city.type = list
col.city.query = select city, zipcode from citytable where countrycode = {country.value}
...
Â