Setting the file. One moment.
Skill 103 · Querying PostHog Data
Subchapter 103.55
references/models-session-recording-playlists.mdMarkdown2 KBView on GitHub
system.session_recording_playlistsSaved views for organizing session recordings. There are two types: collections (manually curated lists) and filters (saved filter criteria that dynamically match recordings).
| Column | Type | Nullable | Description |
|---|---|---|---|
id | Integer | NOT NULL | Playlist id. |
short_id | String | NOT NULL | Short URL-safe id used in playlist links. |
name | String | NOT NULL | User-given playlist name. |
derived_name | String | NOT NULL | Auto-generated name used when no name is set. |
description | String | NOT NULL | Playlist description. |
team_id | Integer | NOT NULL | |
pinned | Integer | NOT NULL | 1 if the playlist is pinned, 0 otherwise. |
deleted | Integer | NOT NULL | 1 if the playlist has been deleted, 0 otherwise. |
filters | JSON | NOT NULL | JSON filters defining which recordings are in the playlist. |
type | String | NOT NULL | Playlist type, e.g. filter-based or a collection of pinned recordings. |
created_at | DateTime | NOT NULL | When the playlist was created. |
created_by_id | Integer | NOT NULL | User who created the playlist. |
last_modified_at | DateTime | NOT NULL | When the playlist was last modified. |
last_modified_by_id | Integer | NOT NULL | User who last modified the playlist. |
team_id)created_by_id)SessionRecordingPlaylistItem (not exposed as a system table)type field determines behavior:
collection — manually curated list of recordingsfilters — saved filter criteria that dynamically match recordingsshort_id for lookups (this is the API lookup field)deleted = 0 to filter out soft-deleted playlists — deleted is an integer 0/1filters field is only meaningful when type = 'filters'