#5 Extended lookup() function - support xrefs

[drrwebber]

The lookup() function works well - but often values in a subsequent lookup are controlled by the value and category of a previous lookup().

So simple example - two lookups - country and then currency code. So a value of UK means currency of GBP is allowed.

To achieve this - the lookup_list already have a category column - so this gives the ability to relate values in one list - to allowed values in another - by filtering on category.

The lookup() function itself could therefore be extended:

lookup('[listname]','xref:[XPath]')

where the xref:[XPath] points to the prior lookup and item to use to select the filtering from.

[Martin Roberts]

Logged In: YES
user_id=936504
Originator: NO

provided in the combined release of JCAM 0.9.16.10 and CAMed 0.5.6