|
2067230
|
32316
|
accessibility
|
AXStaticText
|
: This filters the database to only look at rows a : This filters the database to only look at rows associated with your specific MP4 file....
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
129
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067231
|
32316
|
accessibility
|
AXStaticText
|
(Note: Depending on your exact Screenpipe version, (Note: Depending on your exact Screenpipe version, the column name in...
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
130
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067232
|
32316
|
accessibility
|
AXStaticText
|
might be
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
131
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067233
|
32316
|
accessibility
|
AXStaticText
|
instead of
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
132
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067234
|
32316
|
accessibility
|
AXStaticText
|
. If the query throws an error about the column no . If the query throws an error about the column not existing, just swap...
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
133
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067235
|
32316
|
accessibility
|
AXStaticText
|
for
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
134
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067236
|
32316
|
accessibility
|
AXStaticText
|
)
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
135
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067237
|
32316
|
accessibility
|
AXStaticText
|
.
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
136
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067238
|
32316
|
accessibility
|
AXStaticText
|
and
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
137
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067239
|
32316
|
accessibility
|
AXStaticText
|
: This grabs the absolute earliest timestamp (
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
138
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067240
|
32316
|
accessibility
|
AXStaticText
|
) and the absolute latest timestamp (
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
139
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067241
|
32316
|
accessibility
|
AXStaticText
|
) out of all the frames belonging to that video ch ) out of all the frames belonging to that video chunk, effectively giving you the total time span....
|
NULL
|
29
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
140
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067258
|
32316
|
accessibility
|
AXStaticText
|
Show thinking
|
NULL
|
29
|
0.16093750298023224
|
0.0
|
0.03632812574505806
|
0.013194444589316845
|
NULL
|
157
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067272
|
32316
|
accessibility
|
AXStaticText
|
SQL
|
NULL
|
29
|
0.15156249701976776
|
0.17569445073604584
|
0.010937499813735485
|
0.013194444589316845
|
NULL
|
171
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067273
|
32316
|
accessibility
|
AXButton
|
Copy code
|
NULL
|
29
|
0.2574218809604645
|
0.16805554926395416
|
0.015625
|
0.02777777798473835
|
NULL
|
172
|
{"help_text":"","is_enabled {"help_text":"","is_enabled":true,"is_focused":true,"is_selected":false,"role_description":"button","subrole":"AXUnknown"}...
|
|
2067274
|
32316
|
accessibility
|
AXStaticText
|
SELECT
|
NULL
|
29
|
0.11328125
|
0.21250000596046448
|
0.01953125
|
0.013194444589316845
|
NULL
|
173
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067275
|
32316
|
accessibility
|
AXStaticText
|
DISTINCT
|
NULL
|
29
|
0.13632813096046448
|
0.21250000596046448
|
0.02617187425494194
|
0.013194444589316845
|
NULL
|
174
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067276
|
32316
|
accessibility
|
AXStaticText
|
v.file_path
|
NULL
|
29
|
0.16249999403953552
|
0.21250000596046448
|
0.03945312649011612
|
0.013194444589316845
|
NULL
|
175
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067277
|
32316
|
accessibility
|
AXStaticText
|
FROM
|
NULL
|
29
|
0.11328125
|
0.22708334028720856
|
0.01328125037252903
|
0.013194444589316845
|
NULL
|
176
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067278
|
32316
|
accessibility
|
AXStaticText
|
frames f
|
NULL
|
29
|
0.12656250596046448
|
0.22708334028720856
|
0.029296875
|
0.013194444589316845
|
NULL
|
177
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067279
|
32316
|
accessibility
|
AXStaticText
|
JOIN
|
NULL
|
29
|
0.11328125
|
0.24166665971279144
|
0.01328125037252903
|
0.013194444589316845
|
NULL
|
178
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067280
|
32316
|
accessibility
|
AXStaticText
|
video_chunks v
|
NULL
|
29
|
0.12656250596046448
|
0.24166665971279144
|
0.05234374850988388
|
0.013194444589316845
|
NULL
|
179
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067281
|
32316
|
accessibility
|
AXStaticText
|
ON
|
NULL
|
29
|
0.17890624701976776
|
0.24166665971279144
|
0.006640625186264515
|
0.013194444589316845
|
NULL
|
180
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067282
|
32316
|
accessibility
|
AXStaticText
|
f.video_chunk_id
|
NULL
|
29
|
0.185546875
|
0.24166665971279144
|
0.05898437649011612
|
0.013194444589316845
|
NULL
|
181
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067283
|
32316
|
accessibility
|
AXStaticText
|
=
|
NULL
|
29
|
0.24453124403953552
|
0.24166665971279144
|
0.0031250000465661287
|
0.013194444589316845
|
NULL
|
182
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067284
|
32316
|
accessibility
|
AXStaticText
|
v.id
|
NULL
|
29
|
0.24765625596046448
|
0.24166665971279144
|
0.01640624925494194
|
0.013194444589316845
|
NULL
|
183
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067285
|
32316
|
accessibility
|
AXStaticText
|
WHERE
|
NULL
|
29
|
0.11328125
|
0.2562499940395355
|
0.01640624925494194
|
0.013194444589316845
|
NULL
|
184
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067286
|
32316
|
accessibility
|
AXStaticText
|
f.timestamp
|
NULL
|
29
|
0.12968750298023224
|
0.2562499940395355
|
0.04257812350988388
|
0.013194444589316845
|
NULL
|
185
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067287
|
32316
|
accessibility
|
AXStaticText
|
>=
|
NULL
|
29
|
0.17226561903953552
|
0.2562499940395355
|
0.006640625186264515
|
0.013194444589316845
|
NULL
|
186
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067288
|
32316
|
accessibility
|
AXStaticText
|
'2026-04-15T07:00:00+00:00'
|
NULL
|
29
|
0.18203124403953552
|
0.2562499940395355
|
0.08867187798023224
|
0.013194444589316845
|
NULL
|
187
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067289
|
32316
|
accessibility
|
AXStaticText
|
AND
|
NULL
|
29
|
0.11992187798023224
|
0.2708333432674408
|
0.009765625
|
0.013194444589316845
|
NULL
|
188
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067290
|
32316
|
accessibility
|
AXStaticText
|
f.timestamp
|
NULL
|
29
|
0.12968750298023224
|
0.2708333432674408
|
0.04257812350988388
|
0.013194444589316845
|
NULL
|
189
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067291
|
32316
|
accessibility
|
AXStaticText
|
<=
|
NULL
|
29
|
0.17226561903953552
|
0.2708333432674408
|
0.006640625186264515
|
0.013194444589316845
|
NULL
|
190
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067292
|
32316
|
accessibility
|
AXStaticText
|
'2026-04-15T07:05:00+00:00'
|
NULL
|
29
|
0.18203124403953552
|
0.2708333432674408
|
0.08867187798023224
|
0.013194444589316845
|
NULL
|
191
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067293
|
32316
|
accessibility
|
AXStaticText
|
;
|
NULL
|
29
|
0.27070313692092896
|
0.2708333432674408
|
0.0035156249068677425
|
0.013194444589316845
|
NULL
|
192
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067296
|
32316
|
accessibility
|
AXStaticText
|
: Because a 5-minute window contains thousands of : Because a 5-minute window contains thousands of individual frames, this tells the database to only return the...
|
NULL
|
29
|
0.16015625
|
0.3465277850627899
|
0.115234375
|
0.06875000149011612
|
NULL
|
195
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067297
|
32316
|
accessibility
|
AXStaticText
|
unique
|
NULL
|
29
|
0.25
|
0.40069442987442017
|
0.01914062537252903
|
0.014583333395421505
|
NULL
|
196
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067298
|
32316
|
accessibility
|
AXStaticText
|
file paths. Without
|
NULL
|
29
|
0.16015625
|
0.40069442987442017
|
0.11054687201976776
|
0.03263888880610466
|
NULL
|
197
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067299
|
32316
|
accessibility
|
AXStaticText
|
, you would get the same MP4 name repeated for eve , you would get the same MP4 name repeated for every single frame captured in those 5 minutes....
|
NULL
|
29
|
0.16015625
|
0.41874998807907104
|
0.11601562798023224
|
0.06875000149011612
|
NULL
|
198
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067300
|
32316
|
accessibility
|
AXStaticText
|
(Note: If
|
NULL
|
29
|
0.18593749403953552
|
0.4729166626930237
|
0.02421874925494194
|
0.014583333395421505
|
NULL
|
199
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067301
|
32316
|
accessibility
|
AXStaticText
|
throws an error in your version, change it to
|
NULL
|
29
|
0.16015625
|
0.4729166626930237
|
0.115234375
|
0.03263888880610466
|
NULL
|
200
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067302
|
32316
|
accessibility
|
AXStaticText
|
)
|
NULL
|
29
|
0.17812499403953552
|
0.5090277791023254
|
0.001953125
|
0.014583333395421505
|
NULL
|
201
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067303
|
32316
|
accessibility
|
AXStaticText
|
.
|
NULL
|
29
|
0.18007811903953552
|
0.5090277791023254
|
0.0015625000232830644
|
0.014583333395421505
|
NULL
|
202
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067304
|
32316
|
accessibility
|
AXStaticText
|
: This filters the frames to only look at those ca : This filters the frames to only look at those captured within your requested window. Notice that I added the...
|
NULL
|
29
|
0.16015625
|
0.5347222089767456
|
0.11249999701976776
|
0.06875000149011612
|
NULL
|
203
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067305
|
32316
|
accessibility
|
AXStaticText
|
and
|
NULL
|
29
|
0.259765625
|
0.5888888835906982
|
0.01406249962747097
|
0.014583333395421505
|
NULL
|
204
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067306
|
32316
|
accessibility
|
AXStaticText
|
to your timestamp. SQLite handles date filtering v to your timestamp. SQLite handles date filtering via string comparison, so it is highly recommended to match Screenpipe's native ISO 8601 formatting exactly so the database can evaluate the "greater than" and "less than" logic correctly....
|
NULL
|
29
|
0.16015625
|
0.6069444417953491
|
0.11249999701976776
|
0.12291666865348816
|
NULL
|
205
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2067307
|
32316
|
accessibility
|
AXStaticText
|
: Just like before, this acts as the bridge connec : Just like before, this acts as the bridge connecting the frame timestamps to the actual MP4 file names....
|
NULL
|
29
|
0.16015625
|
0.7409722208976746
|
0.11601562798023224
|
0.05069444328546524
|
NULL
|
206
|
{"help_text":"","role_descript {"help_text":"","role_description":"text","subrole":"AXUnknown"}...
|
|
2068769
|
32326
|
accessibility
|
AXStaticText
|
Analyzing
|
2068768
|
29
|
0.2769531309604645
|
0.1006944477558136
|
0.02578124962747097
|
0.0006944444612599909
|
NULL
|
170
|
{"role_description":"text"}
|
|
2068771
|
32326
|
accessibility
|
AXStaticText
|
name_id_format = persistent
|
2068770
|
29
|
0.2890625
|
0.1006944477558136
|
0.07656250149011612
|
0.0055555556900799274
|
NULL
|
172
|
{"role_description":"text"}
|
|
2068775
|
32326
|
accessibility
|
AXStaticText
|
persistent
|
2068774
|
29
|
0.22148437798023224
|
0.12638889253139496
|
0.02851562574505806
|
0.010416666977107525
|
NULL
|
176
|
{"role_description":"text"}
|