Check tabular section is empty with Query

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Mar 6, 2018
Company: Bodega LLC

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?

 
#2
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Mar 6, 2018
Company: Bodega LLC

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 Ref

Ref = [Item1,Item2,Item3....] => I fill the list with another query where the list items in.

 
#3
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Oct 6, 2023
Company:

You can use LEFT JOIN on ref with tabular section table and IS NULL check in WHERE

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

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.