Data Mapping
From Lianjapedia
Revision as of 09:53, 3 February 2015 by Yvonne.milne (Talk | contribs)
Under construction
See Also
INDEX, KEYLOOKUP(), SQL SELECT
Example Data Mapping App
example_datamapping
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. |
- | 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)