REPLACE INTO `saved_reports` VALUES ('1','eb170f08-43ad-11e9-a801-069940e16132','833f4bd8-43cb-11ef-9dab-27b497052113','recent customers - this month by stage','Contacts','detailed_summary','{\"display_columns\":[{\"name\":\"full_name\",\"label\":\"Name\",\"table_key\":\"self\"},{\"name\":\"email_address\",\"label\":\"Email Address\",\"table_key\":\"Contacts:email_addresses_primary\"},{\"name\":\"date_modified\",\"label\":\"Date Modified\",\"table_key\":\"self\"},{\"name\":\"date_entered\",\"label\":\"Date Created\",\"table_key\":\"self\"},{\"name\":\"name\",\"label\":\"Tags\",\"table_key\":\"Contacts:tag_link\"},{\"name\":\"last_login_c\",\"label\":\"Last Login\",\"table_key\":\"self\"},{\"name\":\"opportunity_type\",\"label\":\"Opp. Type\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"name\",\"label\":\"Opp. Name\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"date_closed\",\"label\":\"Opp.Close Date\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"amount\",\"label\":\"Opportunity Amount (excl. GST)\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"amount_charged_c\",\"label\":\"Amount Charged (excl. GST)\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"amount_remaining_c\",\"label\":\"Amount Remaining (excl. GST)\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"department\",\"label\":\"Department\",\"table_key\":\"self\"},{\"name\":\"sales_stage\",\"label\":\"Sales Stage\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"id\",\"label\":\"ID\",\"table_key\":\"self\"}],\"module\":\"Contacts\",\"group_defs\":[{\"name\":\"sales_stage\",\"label\":\"Sales Stage\",\"table_key\":\"Contacts:opportunities\",\"type\":\"enum\",\"force_label\":\"Sales Stage\"},{\"name\":\"opportunity_type\",\"label\":\"Type\",\"table_key\":\"Contacts:opportunities\",\"type\":\"enum\",\"force_label\":\"Type\"}],\"summary_columns\":[{\"name\":\"sales_stage\",\"label\":\"Sales Stage\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"opportunity_type\",\"label\":\"Type\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"count\",\"label\":\"Count\",\"field_type\":\"\",\"group_function\":\"count\",\"table_key\":\"self\"},{\"name\":\"ap_amount_c\",\"label\":\"SUM: AP amount\",\"field_type\":\"currency\",\"group_function\":\"sum\",\"table_key\":\"self\"},{\"name\":\"ap_amount_c\",\"label\":\"AVG: AP amount\",\"field_type\":\"currency\",\"group_function\":\"avg\",\"table_key\":\"self\"},{\"name\":\"ap_combined_amount_c\",\"label\":\"SUM: ap combined amount\",\"field_type\":\"currency\",\"group_function\":\"sum\",\"table_key\":\"self\"},{\"name\":\"amount\",\"label\":\"SUM: Opportunity Amount (excl. GST)\",\"field_type\":\"currency\",\"group_function\":\"sum\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"amount_charged_c\",\"label\":\"SUM: Amount Charged (excl. GST)\",\"field_type\":\"currency\",\"group_function\":\"sum\",\"table_key\":\"Contacts:opportunities\"},{\"name\":\"amount_remaining_c\",\"label\":\"SUM: Amount Remaining (excl. GST)\",\"field_type\":\"currency\",\"group_function\":\"sum\",\"table_key\":\"Contacts:opportunities\"}],\"report_name\":\"recent customers - this month by stage\",\"chart_type\":\"pieF\",\"do_round\":1,\"chart_description\":\"\",\"numerical_chart_column\":\"self:count\",\"numerical_chart_column_type\":\"\",\"assigned_user_id\":\"56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5\",\"report_type\":\"summary\",\"order_by\":[{\"name\":\"date_closed\",\"vname\":\"Expected Close Date\",\"type\":\"date\",\"audited\":true,\"importable\":\"required\",\"required\":true,\"enable_range_search\":true,\"options\":[{\"value\":\"=\",\"text\":\"Equals\"},{\"value\":\"not_equal\",\"text\":\"Not On\"},{\"value\":\"greater_than\",\"text\":\"After\"},{\"value\":\"less_than\",\"text\":\"Before\"},{\"value\":\"last_7_days\",\"text\":\"Last 7 Days\"},{\"value\":\"next_7_days\",\"text\":\"Next 7 Days\"},{\"value\":\"last_30_days\",\"text\":\"Last 30 Days\"},{\"value\":\"next_30_days\",\"text\":\"Next 30 Days\"},{\"value\":\"last_month\",\"text\":\"Last Month\"},{\"value\":\"this_month\",\"text\":\"This Month\"},{\"value\":\"next_month\",\"text\":\"Next Month\"},{\"value\":\"last_year\",\"text\":\"Last Year\"},{\"value\":\"this_year\",\"text\":\"This Year\"},{\"value\":\"next_year\",\"text\":\"Next Year\"},{\"value\":\"between\",\"text\":\"Is Between\"}],\"massupdate\":true,\"comments\":\"Expected or actual date the oppportunity will close\",\"duplicate_merge\":\"enabled\",\"duplicate_merge_dom_value\":1,\"merge_filter\":\"disabled\",\"table_key\":\"Contacts:opportunities\",\"sort_dir\":\"d\"}],\"full_table_list\":{\"self\":{\"value\":\"Contacts\",\"module\":\"Contacts\",\"label\":\"Contacts\",\"dependents\":[]},\"Contacts:opportunities\":{\"name\":\"Contacts  \\u003E  Opportunities\",\"parent\":\"self\",\"link_def\":{\"name\":\"opportunities\",\"relationship_name\":\"opportunities_contacts\",\"bean_is_lhs\":false,\"link_type\":\"many\",\"label\":\"Opportunities\",\"module\":\"Opportunities\",\"table_key\":\"Contacts:opportunities\"},\"dependents\":[\"Filter.1_table_filter_row_1\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"Filter.1_table_filter_row_1\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"Filter.1_table_filter_row_1\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"Filter.1_table_filter_row_1\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_11\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_11\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_11\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_6\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_11\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_10\",\"display_cols_row_12\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_7\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_10\",\"display_cols_row_12\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_20\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_20\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_20\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_20\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_21\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_21\",\"group_by_row_4\",\"display_summaries_row_group_by_row_4\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_21\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_21\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_21\",\"display_cols_row_22\",\"display_cols_row_23\",\"display_cols_row_24\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_22\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_cols_row_15\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_22\",\"display_summaries_row_23\",\"display_summaries_row_24\",\"display_summaries_row_25\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_summaries_row_7\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_23\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_summaries_row_10\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_22\",\"display_cols_row_24\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_summaries_row_10\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_22\",\"display_cols_row_24\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"group_by_row_3\",\"display_summaries_row_group_by_row_3\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_summaries_row_10\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_22\",\"display_cols_row_24\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_1\",\"display_summaries_row_group_by_row_1\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_summaries_row_7\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_23\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_1\",\"display_summaries_row_group_by_row_1\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_summaries_row_7\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_23\",\"Filter.1_table_filter_row_1\",\"Filter.1_table_filter_row_2\",\"group_by_row_1\",\"display_summaries_row_group_by_row_1\",\"group_by_row_2\",\"display_summaries_row_group_by_row_2\",\"display_summaries_row_7\",\"display_summaries_row_8\",\"display_summaries_row_9\",\"display_cols_row_16\",\"display_cols_row_17\",\"display_cols_row_18\",\"display_cols_row_19\",\"display_cols_row_20\",\"display_cols_row_21\",\"display_cols_row_23\"],\"module\":\"Opportunities\",\"label\":\"Opportunities\"},\"Contacts:email_addresses_primary\":{\"name\":\"Contacts  \\u003E  Email Address\",\"parent\":\"self\",\"link_def\":{\"name\":\"email_addresses_primary\",\"relationship_name\":\"contacts_email_addresses_primary\",\"bean_is_lhs\":true,\"link_type\":\"many\",\"label\":\"Email Address\",\"module\":\"EmailAddresses\",\"table_key\":\"Contacts:email_addresses_primary\"},\"dependents\":[\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_2\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_9\",\"display_cols_row_8\",\"display_cols_row_9\",\"display_cols_row_9\",\"display_cols_row_9\",\"display_cols_row_9\",\"display_cols_row_9\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_10\",\"display_cols_row_11\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\"],\"module\":\"EmailAddresses\",\"label\":\"Email Address\"},\"Contacts:tag_link\":{\"name\":\"Contacts  \\u003E  Tags\",\"parent\":\"self\",\"link_def\":{\"name\":\"tag_link\",\"relationship_name\":\"contacts_tags\",\"bean_is_lhs\":true,\"link_type\":\"many\",\"label\":\"Tags\",\"module\":\"Tags\",\"table_key\":\"Contacts:tag_link\"},\"dependents\":[\"display_cols_row_12\",\"display_cols_row_5\",\"display_cols_row_5\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_11\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_11\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_12\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_13\",\"display_cols_row_14\",\"display_cols_row_15\",\"display_cols_row_15\",\"display_cols_row_15\",\"display_cols_row_14\",\"display_cols_row_14\",\"display_cols_row_14\"],\"module\":\"Tags\",\"label\":\"Tags\",\"optional\":true}},\"filters_def\":{\"Filter_1\":{\"operator\":\"AND\",\"0\":{\"name\":\"sales_stage\",\"table_key\":\"Contacts:opportunities\",\"qualifier_name\":\"one_of\",\"runtime\":1,\"input_name0\":[\"Prospecting\",\"Agreed_to_meet\",\"Needs Analysis\",\"Proposal_preparation\",\"Proposal_presentation\",\"Verbal_acceptance\",\"Closed Won\",\"Closed Lost\",\"Do it Yourself\",\"Signed up\",\"Application Completed Subscribed\",\"Application Sent to Adviser\",\"Application Withdrawn After Payment\",\"Application on hold\",\"Application on hold after payment\",\"Went to Centrelink\",\"Application Approved\",\"Application Rejected\",\"Content Viewed\",\"Direct Contact\",\"Intention to Implement\",\"Financial Planning Referral\",\"Interested\",\"Subscribed\",\"Not Interested\",\"Client Unresponsive\",\"Expired\",\"Booked\",\"Paid\",\"Payment reminder sent\",\"Admin done\"]},\"1\":{\"name\":\"date_closed\",\"table_key\":\"Contacts:opportunities\",\"qualifier_name\":\"tp_this_month\",\"runtime\":1,\"input_name0\":\"tp_this_month\",\"input_name1\":\"on\"}}}}',0,'2024-07-16 23:31:21','2024-07-17 00:06:48','56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5','56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5','56b26ecb-8bda-3fbd-00d6-50c9af4ac5a5',0,'pieF','pro',0,NULL,NULL,NULL,0);
