-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathrows.sql
executable file
·30 lines (30 loc) · 2.01 KB
/
rows.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SELECT doc->'meta'->'view'->'columns'->7->'name' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->79042->23 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->151->4 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->83113->0 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->113797->11 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->119405->15 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'metadata'->'custom_fields'->'Notes'->'6.' FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'approvals'->0->'reviewedAutomatically' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->30770->16 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->36696->13 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->7555->5 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->74347->3 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->65342->9 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'tableAuthor'->'profileImageUrlSmall' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->36594->11 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'owner'->'profileImageUrlSmall' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->104239->23 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'columns'->4->'position' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->92065->21 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'provenance' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->49363->6 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->9579->2 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->20861->0 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->37772->2 FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->26482->0 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'approvals'->0->'submitter'->'displayName' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->2468->17 FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'name' FROM jsontest3 WHERE id = 1;
SELECT doc->'meta'->'view'->'metadata'->'custom_fields'->'Identification'->'Originator' FROM jsontest3 WHERE id = 1;
SELECT doc->'data'->23427->10 FROM jsontest3 WHERE id = 1;