Query raw entries
query_entriesRetrieve filtered raw tracking entries by project, tag, app, search, or time period to analyze specific activity details.
Instructions
Filtered list of raw tracking entries. Useful for digging into specific projects, tags, or finding what window titles appeared. When a period is set, respects the same dashboard exclusions stored in SQLite (ignored apps/projects/breakdown patterns, days_filter) plus optional hour/device filters so aggregates stay consistent with Charts; omit period to bypass those scope rules while still filtering by tag/app/search/etc. Defaults to active foreground entries only — pass mode='passive' or 'all' to include away-listening (background music while idle). Returns at most 5000 rows; default 200.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| period | No | today | yesterday | week | month | year | a single date YYYY-MM-DD | an inclusive date range YYYY-MM-DD..YYYY-MM-DD | |
| app | No | Restrict to a single app name (canonical name, not display_name) | |
| project | No | Restrict to a single project (exact match) | |
| tag | No | Restrict to entries carrying a tag with this exact name | |
| search | No | Substring match against window title, project, or sub-project | |
| mode | No | active = foreground only (default), passive = away-listening only, all = both | |
| hour_start | No | Inclusive start hour 0-24 in local time. Combine with hour_end (e.g. 9 and 17 = 9am to 4:59pm). Omit both for no hour filter. | |
| hour_end | No | Exclusive end hour 0-24 in local time. Combine with hour_start. | |
| weekdays | No | Restrict to specific weekdays. 0=Sunday, 1=Monday, …, 6=Saturday. Omit or pass [0,1,2,3,4,5,6] for no weekday filter. | |
| device | No | Restrict to a single device. Pass 'current' (or 'this') for the local machine, a device UUID from get_device_breakdown, or a platform name like 'darwin', 'win32', 'browser-extension'. Omit or pass 'all' for no device filter. | |
| limit | No |