Add Date Rage Filter in parent object from child object

  • 1
  • Question
  • Updated 4 years ago
  • Answered
 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.

 

Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
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.  
Photo of Rohit Vakhariya

Rohit Vakhariya

  • 1,054 Points 1k badge 2x thumb

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.

Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
"Group by" is by definition an aggregation. You can't perform that function in a basic model.