Hello

How would I achieve the following command using a RelationPredicateBucket. I have a typedlist and I need to add the following clause to the typedlist.

Regards, Simon

HAVING 
        Count(*) =
        (
        SELECT
            Count(*)
        FROM
            tblDocumentGroupingDocumentType
        WHERE
            tblDocumentGroupingDocumentType.ifkDocumentGroupingID = @XYZ
        )

Hi,

You can see the Generated code - using GROUP BY and HAVING clauses section in the documentation.

Aurelien wrote:

Hi,

You can see the Generated code - using GROUP BY and HAVING clauses section in the documentation.

I understand it, but how do I make a Count(*) = to a sub query.

Use a ScalarQueryExpression, see the documentation for more info -> Generated code - Field expressions and aggregates

DvK wrote:

Use a ScalarQueryExpression, see the documentation for more info -> Generated code - Field expressions and aggregates

Hello Dvk

I got it right by fluke I think. I got it after chatting to the Aurelien. Here is the code which I have posted below for everyone else to know.

Regards, Simon

                    groupBy.HavingClause = new PredicateExpression();
                    groupBy.HavingClause.Add(new FieldCompareSetPredicate(
                        DocumentGroupingDocumentTypeFields.DocumentGroupingId.SetAggregateFunction(AggregateFunction.Count),
                        null,
                        DocumentGroupingDocumentTypeFields.DocumentGroupingId.SetAggregateFunction(AggregateFunction.Count),
                        null,
                        SetOperator.Equal,
                        (DocumentGroupingDocumentTypeFields.DocumentGroupingId == ID),
                        false));