1Ci Support Help Center home page
Submit a request
Sign in
  1. 1Ci Support
  2. 1C:Enterprise Platform FAQ
  3. Development

How to insert a value table to a query as a parameter

  • Development
    • How to read and write data to/from a 1C:Enterprise info base to an XML file?
    • How to show totals for dynamic list fields on the form
    • How to setup and work with distributed infobases in 1C:Drive, alternative way, when the subordinate databases will not be created from the main infobase
    • Is it possible to cumulatively select and deselect rows of a form table by just left clicking on them?
    • How to filter a dynamic list via programming
    • How can I create a Dynamic List via programming?
    • How to filter a value table on a form by changing the query filling the value table
    • How to insert a value table to a query as a parameter
    • Conditional Appearance: How to set it up from the Designer
    • An example on how the asynchronous methods work
See more

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:

1.png

 

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.

2.png

3.png

 

Then we put the temporary table description into a temporary table. This is a requirement of the platform.

4.png5.png6.png

 

Lastly, don’t forget to assign our value table as a parameter to the query. That’s it.

7.png

 

  • FAQ_InsertValueTableToQuery.epf
    6 KB Download
© 2020-2022 1C INTERNATIONAL LLC www.1Ci.com Support policy