Activity search view rebuild
Regenerates the activity search index for the workspace.
How it works
The activity picker, activity search, and several reports read from a materialised search view rather than scanning the source projects/activities tables on every keystroke. The view is kept in sync as activities and projects change. If it drifts (after a bulk import, a restored backup, or a fix to a malformed activity), this job rebuilds it from scratch:
- Drops the current search rows for the workspace
- Walks every project and activity in the workspace
- Inserts a fresh search row for each one, with the searchable text recomputed
When it runs
The job is operator-driven — there is no scheduled trigger. Run it manually when the activity picker shows stale results.
Parameters
This job has no parameters.
Job results
| Metric | Description |
|---|---|
rebuilt | Always true on success |
The job returns success as soon as every activity has been re-indexed; per-row counters are not exposed.
When to run
- Activity picker shows activities that were renamed or deleted
- An activity does not appear in the picker but exists in the project page
- After a restore-from-backup of project data
- After running a manual SQL fix on the projects or activities tables
Troubleshooting
| Issue | Solution |
|---|---|
| Picker still shows stale results after rebuild | Force-refresh the browser. The search view sits behind a short cache on the client side |
| Activity expected to appear is still missing | Check that the activity is not soft-deleted, that its project is not archived, and that the activity’s status is not disabled |