Skip to content

Instantly share code, notes, and snippets.

@ValentinMouret

ValentinMouret/query_document_by_field.sql

Last active June 6, 2022 17:00
Show Gist options
  • Save ValentinMouret/9ffb848764e3a3627d66f01a29d0d08d to your computer and use it in GitHub Desktop.
Save ValentinMouret/9ffb848764e3a3627d66f01a29d0d08d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query_document_by_field.sql
select document->>'title' as title,
  id as isbn
  from firestore.collection
 where document->>'author' = 'The Shift Project';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment