## YAML Template.
---
Customer:
  0: {customer_id: 1, name: 'John'}

Project:
  0: {project_id: 1, customer_id: 1, name: 'NUS'}

ProjectActivity:
  0: {activity_id: 1, project_id: 1, name: 'Create Schema', deleted: 0}
  1: {activity_id: 2, project_id: 1, name: 'Build Model', deleted: 0}

ReportGroup:
  0: {report_group_id: 1, name: 'timesheet', core_join_dql: 'core join'}

Report:
  0: {report_id: 1, name: 'project report', report_group_id: 1}
  1: {report_id: 2, name: 'employee report', report_group_id: 1}

FilterField:
  0: {filter_field_id: 1, report_group_id: 1, name: 'project_name', where_clause_part: 'hs_hr_project.project_id', filter_field_widget: 'ohrmWidgetProjectList', condition_no: 2, type: 'Rintime'}

SelectedFilterField:
  0: {report_id: 1, filter_field_id: 1, value: '3000', where_condition: 'greater than', where_clause: 'where salary > 3000'}
  1: {report_id: 1, filter_field_id: 2, value: 'computer science', where_condition: 'equals', where_clause: 'where department = computer science '}
  2: {report_id: 2, filter_field_id: 1, value: '4'}
  3: {report_id: 2, filter_field_id: 2, value: '1'}
  4: {report_id: 2, filter_field_id: 3, value: '3'}
  5: {report_id: 2, filter_field_id: 4, value: '2'}

SelectedDisplayField:
  0: {id: 1, display_field_id: 1, report_id: 1}
  1: {id: 2, display_field_id: 2, report_id: 1}

DisplayField:
  0: {display_field_id: 1, report_group_id: 1, name: 'hs_hr_project.name', label: 'Project Name', field_alias: 'projectname', is_sortable: 'true', sort_order: 'ASC', sort_field: 'projectname', element_type: 'label', element_property: '<xml><getter>projectname</getter></xml>', width: 200, is_exportable: 0, text_alignment_style: false, is_value_list: 0, default_value: '', is_encrypted: 0}
  1: {display_field_id: 2, report_group_id: 1, name: 'hs_hr_project_activity.name', label: 'Activity Name', field_alias: 'activityname', is_sortable: 'false', element_type: 'label', element_property: '<xml><getter>activityname</getter></xml>', width: 200, is_exportable: 0, text_alignment_style: false, is_value_list: 0, default_value: '', is_encrypted: 0}
  2: {display_field_id: 3, report_group_id: 1, name: 'hs_hr_project_activity.project_id', label: 'Project Id', is_sortable: 'false', element_type: 'label', element_property: '<xml><getter>project_id</getter></xml>', width: 75, is_exportable: 0, text_alignment_style: right, text_alignment_style: false, is_value_list: 0, default_value: '', is_encrypted: 0, is_meta: 1}
  3: {display_field_id: 4, report_group_id: 1,  name: 'hs_hr_project_activity.activity_id', label: 'Activity Id', is_sortable: 'false', element_type: 'label', element_property: '<xml><getter>activity_id</getter></xml>', width: 75, is_exportable: 0, text_alignment_style: right, text_alignment_style: false, is_value_list: 0, default_value: '', is_encrypted: 0, is_meta: 1}

GroupField:
  0: {group_field_id: 1, name: 'activity id', group_by_clause: 'GROUP BY hs_hr_project_activity.activity_id'}

SelectedGroupField:
  0: {group_field_id: 1, summary_display_field_id: 1, report_id: 1}

CompositeDisplayField:
  0: {composite_display_field_id: 1}

SelectedCompositeDisplayField:
  0: {id: 1, composite_display_field_id: 1, report_id: 3}
  1: {id: 2, composite_display_field_id: 2, report_id: 3}






