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