--数据查询及建派生表时,引入参数的写法
select distinct count(*) from "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
('PLACEHOLDER'=('$$varuname$$','P01~800/20227992'),
'PLACEHOLDER'=('$$startdate$$','20140601'),
'PLACEHOLDER'=('$$enddate$$','20141001'),
'PLACEHOLDER'=('$$valuetype$$','1'))
SELECT *
FROM "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
('PLACEHOLDER'=('$$startdate$$',@Prompt(startdate)),
'PLACEHOLDER'=('$$enddate$$',@Prompt(enddate)),
'PLACEHOLDER'=('$$valuetype$$',@Prompt(valuetype)),
'PLACEHOLDER'=('$$varuname$$',@Variable('BOUSER')))
--在新模型中,引入旧模型及其参数的写法
SELECT *
FROM "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
(PLACEHOLDER."$$startdate$$" =>:startdate,
PLACEHOLDER."$$enddate$$" =>:enddate,
PLACEHOLDER."$$valuetype$$" =>:valuetype)
select distinct count(*) from "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
('PLACEHOLDER'=('$$varuname$$','P01~800/20227992'),
'PLACEHOLDER'=('$$startdate$$','20140601'),
'PLACEHOLDER'=('$$enddate$$','20141001'),
'PLACEHOLDER'=('$$valuetype$$','1'))
SELECT *
FROM "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
('PLACEHOLDER'=('$$startdate$$',@Prompt(startdate)),
'PLACEHOLDER'=('$$enddate$$',@Prompt(enddate)),
'PLACEHOLDER'=('$$valuetype$$',@Prompt(valuetype)),
'PLACEHOLDER'=('$$varuname$$',@Variable('BOUSER')))
--在新模型中,引入旧模型及其参数的写法
SELECT *
FROM "_SYS_BIC"."crmbo/CA_S_41F_VISIT_EXECUTION_V1"
(PLACEHOLDER."$$startdate$$" =>:startdate,
PLACEHOLDER."$$enddate$$" =>:enddate,
PLACEHOLDER."$$valuetype$$" =>:valuetype)