JOIN tables (DOM sourced)

Denis.David@dqs.de

I would like to use a simple JOIN for realizing a lookup table (scenario: order->customer), so I can use a select field for selecting the customer by name and afterwards being able to show customer specific customer related columns (e.g. ID, name, country) in the order DataTable.

I have seen an example for JOIN tables on your website but I have no clue how I can solve this in a purely DOM sourced data environment.

A short snippet would really help me out.

Thanks for your help!

allan

Hi,

I'm not sure that this can be done with a DOM sourced table since the join requires two pieces of information - the join id (i.e. the value) and the join label to show the end user.

The only option would be to include both pieces of information in the table and use columns.visible to hidden the id (assuming of course that the id is not also the label).

Allan

Denis.David@dqs.de

Hi Allan,

This approach sounds good, I will give it a try.

Thanks,

Denis