How to get items without of prices?

Common questions about 1C:Query language, Query builder tool and Data composition schema

Pages: 1

Eric Kruger	#1 People who like this:0 Yes/0 No Oct 18, 2012 09:21 AM
Active user Rating: 5 Joined: Sep 27, 2011 Company:	Hello! I need to get items which have no prices to set prices or mark those items for deletion. How can I do so? Prices are in information register with dimension Item as reference to Items catalog.

Alexey Alexandrovich

People who like this:0 Yes/0 No

Oct 18, 2012 01:24 PM

Active user

Rating: 3
Joined: Nov 1, 2011
Company:

Code

SEL ECT
   Products.Ref
FR OM
   Catalog.Products AS Products
      LEFT JOIN InformationRegister.PriceList.SliceLast AS PriceListSliceLast
      ON (PriceListSliceLast.Product = Products.Ref)
WHERE
   PriceListSliceLast.Price IS NULL

Eric Kruger	#3 People who like this:0 Yes/0 No Oct 18, 2012 02:59 PM
Active user Rating: 5 Joined: Sep 27, 2011 Company:	Thank you, that was so easy!

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

How to get items without of prices?

Download brochures