The method api.findLookupTableValues() has been deprecated in 14.0 version.
Deprecated Usage
Groovy
def countries = api.findLookupTableValues("Country", ["CountryName", "Currency"], "CountryName")
QueryApi Usage
Groovy
def qapi = api.queryApi()
def t1 = qapi.tables().companyParameterRows("Country")
def countries = qapi.source(t1, [t1.CountryName, t1.Currency])
.sortBy { cols -> [qapi.orders().ascNullsFirst(cols.CountryName)] }
.stream { it.collect { it } }
Result
|
CountryName |
Currency |
|---|---|
|
AU |
AUD |
|
AT |
EUR |
|
BE |
EUR |
|
CA |
CAD |
|
… |
… |