通过 Data Explorer 获取 Pull Event RSVP 列表

社区 数据与报告
,
3

我设法通过机器人完成了以下工作，但它返回 0 个结果（尽管我可以看到 30 多人已回复。如果我删除 WHERE 语句，查询就可以工作。

-- [params]
-- text :event_url = 'https://developer.sailpoint.com/discuss/t/deploying-the-beyondtrust-password-safe-connector-for-identityiq-with-michel-bluteau/68228'

SELECT
    users.username AS "用户名",
    invitees.status AS "回复状态",
    invitees.updated_at AS "最后更新时间"
FROM
    discourse_post_event_events AS events
JOIN
    discourse_post_event_invitees AS invitees
ON
    events.id = invitees.post_id
JOIN
    users
ON
    invitees.user_id = users.id
WHERE
    events.url = :event_url