Question: How can I insert the data from a value table to query?
Answer: If we want to insert a value table to a query, we must make sure date all of the columns of the value table are assigned corresponding value type descriptions. If the value table is extracted from another query or from a tabular section, then it’s columns will already have the value types descriptions assigned by the system. Otherwise, we must define them manually as seen on the screenshot below:
Once our value table is ready, using the query builder, create a temporary table description. Here for the ref type fields, you can define the value types if you will need to access the attributes and tabular sections of these objects later in the query.
Then we put the temporary table description into a temporary table. This is a requirement of the platform.
Lastly, don’t forget to assign our value table as a parameter to the query. That’s it.
