Hi!
I wonder if it is possible to fetch collection of entity objects by using SQL like the following:
SELECT [LeasingAgreement].*
FROM ( [LeasingAgreement]
INNER JOIN [LeasingAgreementObject]
ON [LeasingAgreement].[LeasingAgreementId]=[LeasingAgreementObject].[LeasingAgreementId])
WHERE ( [LeasingAgreementObject].[AgreementObjectId] IN
(SELECT [AgreementObjectAttributeValue].[AgreementObjectId] AS [AgreementObjectId]
FROM [AgreementObjectAttributeValue]
WHERE ( ( [AgreementObjectAttributeValue].[AgreementObjectTypeAttributeId] = 66
And [AgreementObjectAttributeValue].[AgreementObjectTypeAttributeValue] = 'REG 0001')
Or ( [AgreementObjectAttributeValue].[AgreementObjectTypeAttributeId] = 70
And [AgreementObjectAttributeValue].[AgreementObjectTypeAttributeValue] = 'CHA 0001'))
GROUP BY [AgreementObjectAttributeValue].[AgreementObjectId]
HAVING COUNT([AgreementObjectAttributeValue].[AgreementObjectId]) = 2))
I was unable to set IGroupByCollection (and 'Having' clause) in predicate for FieldCompareSetPredicate constructor.
How can I perform task like this?
