请问各位大佬，我创建数据集预览可以显示数据，为啥把数据集中的字段拖到模板中预览模板就没有数据？预览模板没有报错，就是没有数据。语句如下 SELECT
count( member_id ),
a.travel_city_id,
b.employee_number ,
'+$fine_username+'
FROM
(
SELECT DISTINCT
( member_id ),
travel_city_id
FROM
ads_brand_contact
WHERE
is_member = 1
AND date_format( now( ), '%Y-%m-%d' ) = substr( register_time, 1, 10 )
) a
JOIN dim_crm_poster_inviter_employee b ON a.travel_city_id = b.travel_city_id
WHERE
b.employee_number = '${fine_username}'
GROUP BY
a.travel_city_id,
b.employee_number |
1min目标场景问卷
立即参与
