Hi,
Is it possible to create a fetchXML that will only display records per day (crm_date) where the count of crm_flag1 and crm_flag 2 that is set to yes is greater than or equal to 4? Also it should take the date into condiseration when performing the logic. So the logic is run per date. The entity name is crm_timeregistrations.
Record set 1
This will display the first 2 records. It will be displayed because on 07-01-2019 there is 2 x crm_flag1=yes and 2 x crm_flag2 = yes. So in total 4 x yes for 07-01-2019. Record 3 will not be displayed because it's another date and there is less than 4 yes.
crm_date: 07-01-2019, crm_flag1=yes, crm_flag2 = yes
crm_date: 07-01-2019, crm_flag1=yes, crm_flag2 = yes
crm_date: 08-01-2019, crm_flag1=no, crm_flag2 = no
Record set 2
Nothing will be dispalyed. There is only 1 x crm_flag1= yes and 1 x crm_flag2 = yes. So in total 2 x yes.
crm_date: 09-01-2019, crm_flag1=yes, crm_flag2 = yes
crm_date: 09-01-2019, crm_flag1=no, crm_flag2 = no
crm_date: 10-01-2019, crm_flag1=no, crm_flag2 = no
