Missing complete definition of the field relations in the standard table Table Relations Metadata. #5512
Description
In our extension we allow the user to input and lookup data across all tables using RecordRef and Fieldrec. In order to do so in a transparent way, we need to be able to validate field relations the same way as it happens in other parts of the solution.
Unfortunately, it is not possible to find the complete definition of the field relations in the standard table Table Relations Metadata.
E.g. if you look at the data regarding Table 37 Sales Line Field 5403 Bin Code, you find this:
However, if you look at the Tablerelation property for field 5403 it looks like this
You will notice that it is only the conditions on the left which are documented in the Table Relations Metadata, whereas the Table Filter on the right is not mentioned.
Hence the documentation in Table Relations Metadata is incomplete, and we have therefore created some logic for extracting the full set of relation data from a text object file containing all tables and place it in a supplementary table (SCB Table Relations Data).
Below is the resulting data related to the Bin Code example. The data which completes the documentation is marked with red:
The same issue exists regarding the calcformula for flowfields; the table filters used when doing drill down to the underlying data, can only be found in the text object files. As example below, the definition for the Net Change field on Item table:
Moving to VS-code and extensions the text-file solution is no longer viable.
• Is there a way to extract the Table Filter data in the current version of BC?
• If not, could you add some method or system table that will expose this data?
This is relevant both for Cloud and On-Prem