api.findLookupTableValues()
The method api.findLookupTableValues()
has been deprecated in 14.0 version.
Deprecated Usage
def countries = api.findLookupTableValues("Country", ["CountryName", "Currency"], "CountryName")
QueryApi Usage
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 |
… | … |
See Also
Found an issue in documentation? Write to us.