The 1C:Enterprise developers forum
Hello, I hope everyone is good and healthy. I have goods catalog and each item has a tabular section. How can I create a query where this tabular section is empty?
I think I found the answer. I used IN operator and I prepared the list items and I compared them.WHERE NOT ListItem.Ref IN RefRef = [Item1,Item2,Item3....] => I fill the list with another query where the list items in.
You can use LEFT JOIN on ref with tabular section table and IS NULL check in WHERE
A confirmation e-mail has been sent to the e-mail address you provided .
Click the link in the e-mail to confirm and activate the subscription.
© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors to our website.
Get our brochures now! They are packed with all the info you need on 1C:Enterprise, a comprehensive technological platform with a wide range of built-in and separate tools and services and a system of off-the-shelf solutions powered by this platform. Plus, data on customer projects, including stats on their size and the effect of automation. Just leave your email address to download!
Your request has been successfully sent.