Connect all components of `type: SHADING` from IGSDB to the product data network

[christoph-maurer]

Currently, only the bsdf files are connected from shading components of type bsdf-file.

[danielmcquillen]

@simon-wacker @christoph-maurer Where does this feature stand at the moment?

[simonwacker]

@christoph-maurer What other shading component types are there? From a product-detail file type perspective, there are BSDF, GEN_BSDF, THMX, TOLERANCE, and OTHER files. Shall any of these be queryable? And if yes under which domain: optical, geometric, calorimetric, ...?

[christoph-maurer]

Currently, the product data network returns the optical data sets of 337 shading components with format BED-JSON. This is surprising, because https://igsdb-v2.herokuapp.com/ shows 940 rows/components. Are only components with spectral data returned as BED-JSON? BSDF files are currently not returned.

The 337 optical data sets are the ones which:

1. Are part of the materialized table.
2. The calculation standard must be NFRC.
3. The field opticalData (or later the field BSDF file) in the database must be filled.

[simonwacker]

Yes, so the reason that there are fewer entries may be that

1. There are missing rows in the materialized view.
2. There are products with other calculation standard.
3. There are products without optical data.

Personally, I believe that points 2 and 3 are the most probable and that the results are correct.

There are also fewer entries for optical data of type glazing, about 8000 in the table view of the IGSDB and about 6000 in the GraphQL response.