Untitled

 avatar
unknown
plain_text
a year ago
3.4 kB
3
Indexable
select
    opportunity.id identificator,
    opportunity.title  title, 
    opportunity.createdon  + interval '3 hours' created_on,
    createdby.name as created_by,
    opportunity.modifiedon  + interval '3 hours' as modified_on,
    modifiedby.name as modified_by,
    type.name as type,
    stage.name as stage,
    owner.name as owner,
    opportunity.notes  as notes,
    opportunity.accountid as account_identificator,
    category.name as category,
    contact.name as contact,
    opportunity.description as description,
    opportunity.smexternalcode as sm_external_code,
    opportunity.partnerid as sm_parent_id,
    contract.number as contract_number,
    opportunity.smleadfirstid as first_lead_id,
    segment.name as segment,
    opportunity.smbrandid as brand_identificator,
    opportunity.smintegrationchat as integration_chat,
    opportunity.smcontenttask as content_task,
    opportunity.smisdeliveryarealoaded as delivery_area_loaded,
    opportunity.smlinkadmin as link_admin,
    opportunity.smiscontentintegrationcomplete as content_integration_complete,
    opportunity.smisinstalledphoto as installed_photo,
    opportunity.smduplicatebynameid as duplicated_by_name_id,
    --content_status."Name" as content_status,
    loss_reason.name as loss_reason,
    opportunity.smlosscomment as loss_comment,
    opportunity.smispartnerloadsmenu as partner_loads_menu,
    opportunity.smisintegration as is_integration,
    opportunity.smchatphotoshoot as chat_photoshoot,
    opportunity.smlinkfoodphoto as link_food_photo,
    opportunity.smlinkfoodtable as link_food_table,
    opportunity.smlinkphoto as link_photo,
    opportunity.smaddconnectionrest as add_conection_rest,
    opportunity.smphotoshootrequired as photoshoot_required,
    vertical.name as vertical,
    connection_status.name as connection_status,
    opportunity.smisshowcaseready as is_showcase_ready
from vw_ods_bpm_soft.vw_opportunity opportunity
    left join vw_ods_bpm_soft.vw_contact createdby
        on createdby.id = opportunity.createdbyid  
    left join vw_ods_bpm_soft.vw_contact modifiedby
        on modifiedby.id = opportunity.modifiedbyid  
    left join vw_ods_bpm_soft.vw_opportunitytype type
        on type.id = opportunity.typeid  
    left join vw_ods_bpm_soft.vw_opportunitystage stage
        on stage.id = opportunity.stageid 
    left join vw_ods_bpm_soft.vw_contact owner
        on owner.id = opportunity.ownerid  
    left join vw_ods_bpm_soft.vw_smopportunitycategory category
        on category.id = opportunity.categoryid  
    left join vw_ods_bpm_soft.vw_contact contact
        on contact.id = opportunity.contactid 
    left join vw_ods_bpm_soft.vw_contract contract
        on contract.id = opportunity.contactid 
    left join vw_ods_bpm_soft.vw_smsegment segment
        on segment.id = opportunity.smsegmentid 
    --left join vw_ods_bpm_soft.vw_smopportunitycontentstatus content_status
    --    on content_status.id = opportunity."SmRecommendationStatusId"  
    left join vw_ods_bpm_soft.vw_smopportunitylossreason loss_reason
        on loss_reason.id = opportunity.smlossreasonid
    left join vw_ods_bpm_soft.vw_smopportunityvertical vertical
        on vertical.id = opportunity.smverticalid  
    left join vw_ods_bpm_soft.vw_smconnectionstatus connection_status
        on connection_status.id = opportunity.smopportunityconnectionstatusid;
Editor is loading...
Leave a Comment