I have a requirement where I have to fetch overall record of an employee using the effective start date and effective end date. This is because I want all of the effective dates of that employee, then concatenate those dates and send that to a target field.
For example an employee X, if he has 10 records with different effective dates, then I want all those 10 records in a single document and then I will get those 10 different effective dates.
Please let me know if any more info is required. What type of filters should I apply in the operation, so that I can get the whole data of an employee?
Thanks & Regards,