aggregation in front end

[sai_12]

Hi everyone,

I have a requirement to filter rows in front end

For every client i have op and ip dates

client	op	ip
a	14/10/2022	14/03/2023
a	14/10/2022	25/05/2023
a	25/01/2023	14/03/2023
a	25/01/2023	25/05/2023
b	29/09/2022	5/09/2022
b	29/09/2022	19/07/2023

I want to

aggregation  per client

give 1 record if

min(ip) date is  greater than min(op) date

then 

the record with with min(op) and min(ip)

else

if min(ip) date is less than min(op) date

then give all records for that client

so for client a i want 

a, 14/10/2022,14/03/2023

but for client b i want 

both records

Note: On front end