商机新增的业务流程,如何通过sql获取商机当前业务阶段
SELECT
opp.Name AS OpportunityName,opp.rf_number,
stage.ActiveStageIdName,opp.OpportunityId,stage.ActiveStageId
FROM
OpportunityBase AS opp
INNER JOIN
rf_sales_process AS stage ON opp.OpportunityId=stage.bpf_opportunityid --and opp.stageid=stage.ActiveStageId
WHERE
opp.StateCode = 0 -- 活动状态的商机
记得收藏并关注,掌握更多相关知识!!!

浙公网安备 33010602011771号