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

How to filter a value table on a form by changing the query filling the value table

  • 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: I am filling a value table from a query and outputting the it to a form, I have also added fields on the form for filtering. Each time a filter has changed, I need the value table refilled from the query taking into account the currently set filters. How can I realize this?

 

Answer: On create at server event of the form and on change events of the filter fields all run the same FillTheTable procedure. Salient point here is how to exclude the filter parameters from the query in case the user hasn’t chosen any value for a given filtering field. Here is an example on how to do it:

1.png

2.png

© 2020-2022 1C INTERNATIONAL LLC www.1Ci.com Support policy