Hello,
thanks for the answer.
I have made something like this:
`SELECT nest(measurements, weights, additional_data) AS technical_data FROM (SELECT nest(v.value, v.description) AS measurements FROM v WHERE category in ('INNENRAUMABMESSUNGEN', 'AUSSENABMESSUNGEN')) INNER JOIN (SELECT nest(v.value, v.description) AS weights FROM v WHERE category = 'GEWICHTE') INNER JOIN (SELECT nest(v.value, v.description) AS additional_data FROM v WHERE category = 'WEITERE DATEN');`
This creates the following inside the nest(technical_data)
| weights | additional_data | weights |
| -------- | -------- | -------- |
| Array | Array | Array |
as for the equipments nest I did this:
`SELECT nest(v.description, v.value) AS equipment, v.token AS token, v.country AS country, v.brand_id AS brand_id, v.model_id AS model_id, v.model_type AS model_type, v.model_year AS model_year, v.color_ext AS color_ext, v.color_int AS color_int FROM v WHERE category in ('FAHRLEISTUNGEN', 'MOTOR, GERIEBE, ELEKTRIK', 'REICHWEITE', 'BATTERIE / LADESYSTEM');`
and to achieve this:
| equipment | technical_data |
| -------- | -------- |
| Array | Array |
I just joined both views. Now, the problem is this:
my Base View has some search methods, which can be obtained from the derived view "v" with the View Parameters that are given default values. I dont know how to propagate those input parameter up to the final derived view so that those parameters are used to call the Rest web services that the Base View uses. The view technical_data cannot be edited afterwards