KamoCRM

Doc engagement badge and the hot-lead bell for doc views (DL2.9)

FeatureSecurityService
Shipped
November 13, 2026 at 2:19 PM UTC
Author
Kamo
Commit
697eb75

- GET **************** (<=200): per lead {views, lastViewedAt, hot} for the lead header and the /leads grid page; hot is READ (last view < 24 h), never stored - no new status, priority or column. Same read gate as the lead timeline, same sharer + reporting-line scope per view. - **************** gains DOC_VIEW. - LeadDocViewSignal: queue subscription on docs.share.viewed.<org>; the verified email (or an anonymous Anyone view's only outside recipient) is matched by ix_lcp_lookup_window, leads read by pk, and the lead's owner gets a DOC_VIEWED bell (sourceType LEAD_DOC_VIEW, one card per lead) when they are the sharer or above them. No sweep, no org scan. - img_shares lookup by sw_email without lower(): the index is used again (was a seq scan).

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free ForeverView Pricing