qobrix_top_field_changers
Rank users by how often they edited a specific CRM field. Scan audit logs over a custom period to get a leaderboard of top editors.
Instructions
Leaderboard: which users most often edited a given field (tenant-wide audit scan). Paginates GET /{resource}/changes, counts rows where field appears in changed, groups by user_id. Returns [{user_id, user_name?, change_count, latest_change_at, sample_record_ids}]. Use for: 'who rewrites lead source to direct most often in the last 6 months?'
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| field | Yes | Field name to rank editors by (must appear in LogAudit.changed). Example: 'source'. | |
| limit | No | Max users in leaderboard (default 20). | |
| since | No | Lower bound for timestamp search. Qobrix expression fragment or full clause. Examples: 'DAYS_AGO(180)' (auto-wrapped as timestamp >= ...), '2025-01-01'. | |
| until | No | Upper bound. Example: 'NOW' or ISO date. Wrapped as timestamp <= ... when bare. | |
| resource | Yes | CRM resource name. PascalCase (e.g. 'Opportunities', 'Properties', 'Contracts') or kebab slug (e.g. 'opportunities'). Maps to GET /api/v2/{resource}/changes. Common values: Opportunities, Properties, Contacts, Contracts, Offers, Tasks, Calls, Meetings. | |
| max_pages | No | Max API pages to scan (100 rows/page). Default 50 (5000 audit rows). | |
| resolve_users | No | When true, resolve user_id to display name (default false). |