ResultsetFields fieldsn = new ResultsetFields(6);
fieldsn.DefineField(GljourFieldIndex.GljourNo, 0, "GljourNo", "Gljour");
fieldsn.DefineField(GljourFieldIndex.BranchId, 1, "BranchId", "Gljour");
fieldsn.DefineField(GljourFieldIndex.GljourDate, 2, "GljourDate", "Gljour", AggregateFunction.Max);
fieldsn.DefineField(GljourFieldIndex.GljourDesc, 3, "GlJourDesc", "Gljour", AggregateFunction.Max);
fieldsn.DefineField(GljourlsFieldIndex.GljourlsDr, 4, "GljourlsDr", "Gljourls", AggregateFunction.Sum);
fieldsn.DefineField(GljourlsFieldIndex.GljourlsCr, 5, "GljourlsCr", "Gljourls", AggregateFunction.Sum);
IPredicateExpression B = new PredicateExpression();
B.Add(PredicateFactory.CompareValue(GljourFieldIndex.BranchId, ComparisonOperator.Equal, ConfigBranch));
B.AddWithAnd(PredicateFactory.CompareValue(GljourFieldIndex.GljourDate, ComparisonOperator.GreaterEqual, SelectFrom.EditValue));
B.AddWithAnd(PredicateFactory.CompareValue(GljourFieldIndex.GljourDate, ComparisonOperator.LessEqual, SelectTo.EditValue));
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add(GljourEntity.Relations.GljourlsEntityUsingGljourNoBranchId, "Gljourls", "Gljour", JoinHint.Right);
bucket.PredicateExpression.Add(B);
ISortExpression sorterGljour = new SortExpression(
SortClauseFactory.Create(GljourFieldIndex.GljourNo, SortOperator.Descending));
IPredicateExpression havingFilter = new PredicateExpression();
havingFilter.Add(new FieldCompareNullPredicate(GljourlsFields.GljourlsDr, null));
havingFilter.AddWithOr(new FieldCompareExpressionPredicate(fieldsn[4], null, ComparisonOperator.NotEqual, new Expression(fieldsn[5])));
IGroupByCollection groupByClause = new GroupByCollection();
groupByClause.Add(fields[0]);
groupByClause.Add(fields[1]);
groupByClause.HavingClause = havingFilter;
DataTable dynamicList = new DataTable();
adapter.FetchTypedList(fieldsn, dynamicList, bucket, 0, sorterGljour , true, groupByClause);
It's not work I have error
The multi-part identifier "essdata.dbo.gljour.branch_id" could not be bound.
The multi-part identifier "essdata.dbo.gljour.gljour_date" could not be bound.