AggregateColumns must not be null or empty

Yes Bhanu. I believe the above query

"select int_field, text_field from table_name where date_field = (select MAX(date_field) from table_name where id = id)"

which was given can be simplified using the sorting on date field in descending order so that required row will be picked up.

second option could be to split this into two rules - one for the aggregation and second for the selection and then use the aggregate rule in the filter condition.

Yes Bhanu. I believe the above query

"select int_field, text_field from table_name where date_field = (select MAX(date_field) from table_name where id = id)"

which was given can be simplified using the sorting on date field in descending order so that required row will be picked up.

second option could be to split this into two rules - one for the aggregation and second for the selection and then use the aggregate rule in the filter condition.