Main > Forum > 1C:Enterprise Platform > 1C:Query language and DCS > How to get items without of prices?

Forum

How to get items without of prices?

Eric Kruger	#1 Oct 18, 2012 09:21 AM
Active user Points:: 0 Joined:: Sep 27, 2011	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.
	Profile

Alexey Alexandrovich

Oct 18, 2012 01:24 PM

Active user

Points:: 0
Joined:: Nov 1, 2011

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

Profile

Eric Kruger	#3 Oct 18, 2012 02:59 PM
Active user Points:: 0 Joined:: Sep 27, 2011	Thank you, that was so easy!
	Profile

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