Using Adapter, Targeting .NET 3.5, using June 28th v2.6 release.
I have a SQL query:
SELECT sp.Id FROM SpecialPrice sp
WHERE EXISTS (SELECT sp2.Id FROM SpecialPrice sp2 WHERE sp2.ProductId = sp.ProductId AND sp2.CustomerId = sp.CustomerId AND
sp2.VolumePackNo = sp.VolumePackNo AND sp2.EffectiveDate >= '03 April 2008' AND sp2.Id <> sp.Id)
Or in other words:
Fetch all special prices where there is another special price with the same product, customer and volume that has an effective date of 03 April 2008 or earlier.
That I'm trying to write as a LLBLGen filter, without success. I believe the FieldCompareSetPredicate is the appropriate Predicate type to use but I'm not sure. Any help would be much appreciated.