Data Mapping

From Lianjapedia
Revision as of 09:53, 3 February 2015 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Under construction

See Also

INDEX, KEYLOOKUP(), SQL SELECT

Example Data Mapping App

example_datamapping

Example Data Mapping app: example_datamapping


Choice list


Attributes


Choices:

select productname from products order by productname


Get data mapping:

keylookup("products", "productid", {}, productname)
KEYLOOKUP(<workarea | alias | table>, <"indextagname">, <keyExpr>, <valueExpr> [, <notfoundExpr>])
Argument Description
"products" The name of the lookup table (in quotes). Alternatively, the alias name (in quotes) or workarea number (no quotes) can be specified if the lookup table is open.
"productid" The name of the index tag (in quotes) for the lookup table to search. Index tags can be created using the index on command.
{} The key value expression to search for in the index. In this case, we are looking for the numeric value of the order_details.productid field in the current row of the Grid Section, so we can use {}. For a character value, quotes are required '{}'.
productname The value expression to return if the key value is found in the index. So, in this case, if the value of the current order_details.productid is found in the products table productid index, the products.productname value will be returned for the corresponding record.
valign="top" An optional 'not found' expression can also be specified. If the key value is not found in the index, this will be returned, e.g. "Product not found".

Set data mapping:

keylookup("products", "productname", "{}", productid)