Reproducible query — Product (shared drive)
COUNT FILES BY IS_FOLDER
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
| no | 12 63% |
| yes | 7 37% |
2 groups · 19 rows total
Applied the source default TRASHED IS "no". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it.
epoch 1source gdrive:filesas of 2026-09-14T21:44:11Ztransforms type-coercion, source-default-filtercache hit
Applied source default TRASHED IS "no" — Drive hides trashed items by default, so counting them would disagree with what any Drive user sees.
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "COUNT",
"subject": "FILES",
"data": {
"groups": [
{
"group": "no",
"count": 12
},
{
"group": "yes",
"count": 7
}
],
"total": 19
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:files",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion",
"source-default-filter"
],
"source_defaults": [
{
"field": "TRASHED",
"op": "IS",
"value": "no",
"rationale": "Drive hides trashed items by default, so counting them would disagree with what any Drive user sees."
}
]
},
"related": [
"SUM FILES DEPTH BY IS_FOLDER",
"LIST FILES LIMIT 10"
],
"hints": [
"Applied the source default TRASHED IS \"no\". Drive hides trashed items by default, so counting them would disagree with what any Drive user sees. Filter TRASHED explicitly to override it."
],
"cache": "hit"
}
}