Comparing values in all the rows in aggregate

Comparing values in all the rows in aggregate

  

Can I confirm that the values that passes only compares to the top row of the aggregate? 

eg. that I had various Start and End date in an aggregate. 

I would like to compare if my new input of start and end lies in between any of the datas.

I managed to compare the values in the top row but not the below. are there any way to compare all data in the aggregate?


For simplicity, it is leave application. Would like to set a logic to provide an error if the employee had already applied for leave.


Thank you!

Solution

Patrick,

You can do a for each on the list returned by aggregate and compare inside the for each with the current.

Or you can modify the aggregate to have a filter with your start date and end date. 


Regards, 

Abílio Matos 

Solution

Got It... thank you!