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.
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!
We're committed to your privacy. 1С uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy
Your request has been successfully sent.