api.findLookupTableValues()

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

CountryName

Currency

AU

AUD

AT

EUR

BE

EUR

CA

CAD

See Also

Found an issue in documentation? Write to us.