We have tabular data that we want to be able to "look up" within Code Files. We essentially want the "Reference Advanced List" functionality that is available in Rule Sets to be ported to Code Files.
The reason we need this functionality in a Code File is because we are dynamically calculating the lookup keys according to our business logic. The business logic is too complex to encapsulate in a simple Rule Set, hence our need for the functionality to be available in Code Files. Our current solution is to re-write our tabular data into a JSON string, and then load this into a datagrid, which we then can then access using the various datagrid functions. This is a very inelegant solution. Maintaining the datagrid JSON string with hundreds of rows and columns within a code File is a painful exercise. It seems strangely inconsistent that Advanced Lists can only be accessed through Rule Sets.
Please consider adding a function to Code Files to lookup Advanced Lists.
P.S. The same functionality for Lookup Tables would be great too.
