Add Date Rage Filter in parent object from child object

 I have two object one is candidate other is work experience. I need to create one report based on candidate object.

In that object I need provide date rage filter of work experience object.

I don’t know how I can create date rage filter from one object to other object.

I have from date in work experience object. Work Experience object is child object of candidate object.

Now I need to use from date date rage filter into candidate object.

I need your help in this task.


Date range filters are not supported on Child Records.  You can implement a select filter that lets users select from predefined values:  last week, last month, last quarter.  But you cannot have that be a date range filter. 

If you are building a report and don’t inted for the data in candidate to be modified,  I’d reccomend that you make your report on the Work Experience object ( whose date fields will construct a date range filter)  and then traverse the relationship field to get data about candidates.  

Can i do group by in work experience in basic model. I do not want to use aggregate model because it is not supporting load more.

“Group by” is by definition an aggregation. You can’t perform that function in a basic model.