Salesforce Tableau CRM Dashboards,如何添加登录User为查询条件

2022-03-23 14:33:38 浏览数 (15)

打开查询模式

变更前:

代码语言:javascript复制
SELECT Id, IsDeleted, MasterRecordId, Name, Type, BillingLatitude,
BillingLongitude, ShippingLatitude, ShippingLongitude, AnnualRevenue
FROM Account LIMIT 100

变更后:

代码语言:javascript复制
SELECT Id, IsDeleted, MasterRecordId, Name, Type, BillingLatitude,
BillingLongitude, ShippingLatitude, ShippingLongitude, AnnualRevenue
FROM Account WHERE OwnerId = '!{user.id}' LIMIT 100

0 人点赞