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.