Untitled
unknown
plain_text
a year ago
1.5 kB
4
Indexable
select b.createdon + interval '3 hours' created_on, createdby.name as created_by, b.modifiedon + interval '3 hours' as modified_on, modifiedby.name as modified_by, b.smexternalcode as external_code, b.smexternalid as external_id, sh.smname as holding_name, sbit.name as integration_type, b.smname as name, b.smrestarauntcnt as rest_count, ss.name as segment, sbs.name as status, sbt.name as tier, b.id as identificator, owner.name as owner, b.smnumberrestaurants as number_restaurants, sbcit.name as content_integration_type, b.smnotes as notes --oc."Name" as category, --sov."Name" from vw_ods_bpm_soft.vw_smbrand b left join vw_ods_bpm_soft.vw_contact createdby on createdby.id = b.createdbyid left join vw_ods_bpm_soft.vw_contact modifiedby on modifiedby.id = b.modifiedbyid left join vw_ods_bpm_soft.vw_smholding sh on sh.id = b.smholdingid left join vw_ods_bpm_soft.vw_smbrandintegrationtype sbit on sbit.id = b.smintegrationtypeid left join vw_ods_bpm_soft.vw_smsegment ss on ss.id = b.smsegmentid left join vw_ods_bpm_soft.vw_smbrandstatus sbs on sbs.id = b.smstatusid left join vw_ods_bpm_soft.vw_smbrandtier sbt on sbt.id = b.smtierid left join vw_ods_bpm_soft.vw_contact owner on owner.id = b.smownerid left join vw_ods_bpm_soft.vw_smbrandcontentintegrationtype sbcit on sbcit.id = b.smcontentintegrationtypeid --left join vw_ods_bpm_soft.vw_smopportunitycategory oc -- on oc.id = b."SmCategoryId" --left join vw_ods_bpm_soft.vw_smopportunityvertical sov -- on sov.id = b."SmVerticalId";
Editor is loading...
Leave a Comment