Class: ViewOpportunityConversion

Inherits:

ApplicationViewRecord

• Object
• ActiveRecord::Base
• ApplicationRecord
• ApplicationViewRecord
• ViewOpportunityConversion

Defined in:

app/models/view_opportunity_conversion.rb

Overview

== Schema Information

Table name: view_opportunity_conversions
Database name: primary

id :bigint
amount :decimal(, )
days_conversion :integer
discount_name_range :text
discount_numeric_range :integer
discount_percentage :decimal(10, 2)
group1 :text
group2 :text
group3 :text
num_quotes_created :bigint
num_quotes_orders_won :bigint
report_grouping :string
resource_type :text
state :string(255)
won_lost_date :date
created_at :date
company_id :integer
opportunity_id :integer
primary_sales_rep_id :integer
resource_id :integer

Indexes

index_view_opportunity_conversions_on_company_id (company_id)
index_view_opportunity_conversions_on_created_at (created_at)
index_view_opportunity_conversions_on_discount_numeric_range (discount_numeric_range)
index_view_opportunity_conversions_on_group1 (group1)
index_view_opportunity_conversions_on_group2 (group2)
index_view_opportunity_conversions_on_group3 (group3)
index_view_opportunity_conversions_on_id (id) UNIQUE
index_view_opportunity_conversions_on_opportunity_id (opportunity_id)
index_view_opportunity_conversions_on_primary_sales_rep_id (primary_sales_rep_id)
index_view_opportunity_conversions_on_report_grouping (report_grouping)
index_view_opportunity_conversions_on_resource_id (resource_id)
index_view_opportunity_conversions_on_resource_type (resource_type)
index_view_opportunity_conversions_on_state (state)
index_view_opportunity_conversions_on_won_lost_date (won_lost_date)

Class Method Summary

• .refresh ⇒ Object

Methods inherited from ApplicationViewRecord

create, create!, #readonly?

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::EventPublishable

#publish_event

Class Method Details

.refresh ⇒ Object

# File 'app/models/view_opportunity_conversion.rb', line 45

def self.refresh
  Scenic.database.refresh_materialized_view(table_name, concurrently: true, cascade: false)
end