inline parameters method

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}
...

Table Grid Editor (legacy) Documentation

inline parameters method

How to cascade selections

Related information

Related content