-
Notifications
You must be signed in to change notification settings - Fork 1
/
bank_20221031.dsnb
2261 lines (2261 loc) · 250 KB
/
bank_20221031.dsnb
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
[
{
"name" : "bank_20221031",
"description" : null,
"tags" : null,
"version" : "6",
"layout" : "zeppelin",
"type" : "Default",
"readOnly" : false,
"snapshot" : false,
"template" : "dsYaky3j",
"templateConfig" : "{\"visualization\":{\"filters\":[{\"_id\":1656315070707,\"component\":\"edge\",\"type\":\"styling\",\"target\":\"edge\",\"enabled\":true,\"conditions\":{\"operator\":\"and\",\"conditions\":[{\"property\":\"label\",\"operator\":\"=\",\"value\":\"TRANSFERRED_TO\"}]},\"properties\":{\"label\":[\"AMOUNT\"]},\"aggregation\":[]},{\"_id\":1656315033165,\"component\":\"edge\",\"type\":\"styling\",\"target\":\"edge\",\"enabled\":true,\"conditions\":{\"operator\":\"and\",\"conditions\":[{\"property\":\"label\",\"operator\":\"=\",\"value\":\"OWNS\"}]},\"properties\":{\"label\":[\"label\"]},\"aggregation\":[]},{\"_id\":1656314980408,\"component\":\"vertex\",\"type\":\"styling\",\"target\":\"vertex\",\"enabled\":true,\"conditions\":{\"operator\":\"and\",\"conditions\":[{\"property\":\"label\",\"operator\":\"=\",\"value\":\"CUSTOMER\"}]},\"properties\":{\"colors\":[\"blue\"],\"icons\":[\"fa-user-man\"],\"iconColors\":[\"white\"],\"label\":[\"FIRST_NAME\"]},\"aggregation\":[]},{\"_id\":1656314802889,\"component\":\"vertex\",\"type\":\"styling\",\"target\":\"vertex\",\"enabled\":true,\"conditions\":{\"operator\":\"and\",\"conditions\":[{\"property\":\"label\",\"operator\":\"=\",\"value\":\"ACCOUNT\"}]},\"properties\":{\"colors\":[\"red\"],\"sizes\":[5,10],\"icons\":[\"fa-address-card-o\"],\"iconColors\":[\"white\"],\"label\":[\"ACC_ID\"]},\"aggregation\":[],\"interpolation\":{\"min\":\"0.01\",\"max\":\"0.02\",\"property\":\"PAGERANK\"}}],\"version\":9}}",
"paragraphs" : [
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 0,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"# Create a graph",
"",
"---",
"",
"This is how to write a mapping from a table to a graph. For the graph, we need to identify and extract information about vertices, edges, and labels from our tables. The paragraphs below for VERTEX TABLES and EDGE TABLES specify which tables serve as the source of information for vertices and edges, respectively, and their labels in the newly created graph.",
"",
"Here, the vertex description is straightforward, as it simply creates “customer” vertices from the customer table and “account” vertices from the account table. For edges, we label the relationships held in the transaction table as “transferred_to”. And from the account table, we extract and label the relationships of which customer “owns” the account.",
"",
"This operation reads the table dataset in the database, converts it into a graph according to the mapping defined, and expands it in the memory of the Graph Server.",
"",
"For running the scripts in this notebook, please load the following CSV files into tables first.",
"",
"- [bank_account.csv](https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_account.csv)",
"- [bank_customer.csv](https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_customer.csv)",
"- [bank_transaction.csv](https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_transaction.csv)"
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667289574608,
"endTime" : 1667289574662,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<h1 id=\"create-a-graph\">Create a graph</h1>\n<hr />\n<p>This is how to write a mapping from a table to a graph. For the graph, we need to identify and extract information about vertices, edges, and labels from our tables. The paragraphs below for VERTEX TABLES and EDGE TABLES specify which tables serve as the source of information for vertices and edges, respectively, and their labels in the newly created graph.</p>\n<p>Here, the vertex description is straightforward, as it simply creates “customer” vertices from the customer table and “account” vertices from the account table. For edges, we label the relationships held in the transaction table as “transferred_to”. And from the account table, we extract and label the relationships of which customer “owns” the account.</p>\n<p>This operation reads the table dataset in the database, converts it into a graph according to the mapping defined, and expands it in the memory of the Graph Server.</p>\n<p>For running the scripts in this notebook, please load the following CSV files into tables first.</p>\n<ul>\n<li><a href=\"https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_account.csv\">bank_account.csv</a></li>\n<li><a href=\"https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_customer.csv\">bank_customer.csv</a></li>\n<li><a href=\"https://raw.githubusercontent.com/ryotayamanaka/oracle-graph/main/bank-transaction/data/scale-100/bank_transaction.csv\">bank_transaction.csv</a></li>\n</ul>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 1,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%python-pgx",
"statement = \"\"\"",
"CREATE PROPERTY GRAPH bank_graph",
" VERTEX TABLES (",
" bank_customer",
" KEY (cst_id)",
" LABEL customer",
" PROPERTIES (cst_id, first_name, last_name)",
" , bank_account",
" KEY (acc_id)",
" LABEL account",
" PROPERTIES (acc_id)",
" )",
" EDGE TABLES (",
" bank_transaction",
" KEY (txn_id)",
" SOURCE KEY(acc_id_src) REFERENCES bank_account",
" DESTINATION KEY(acc_id_dst) REFERENCES bank_account",
" LABEL transferred_to",
" PROPERTIES (txn_id, datetime, amount)",
" , bank_account",
" KEY (acc_id)",
" SOURCE KEY(cst_id) REFERENCES bank_customer",
" DESTINATION KEY(acc_id) REFERENCES bank_account",
" LABEL owns",
" )",
"\"\"\"",
"session.prepare_pgql(statement).execute()"
],
"selectedVisualization" : "raw",
"visualizationConfig" : "[{\"raw\":{\"lastColumns\":[\"False\"],\"version\":1}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667290108702,
"endTime" : 1667290113097,
"interpreter" : "python-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "False\n",
"type" : "TEXT"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 2,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"First, we will check the accounts held by the customer with cst_id = 10.",
"",
"We can see that this customer’s name is Laura, and she owns two accounts."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403155744,
"endTime" : 1656403155790,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>First, we will check the accounts held by the customer with cst_id = 10.</p>\n<p>We can see that this customer’s name is Laura, and she owns two accounts.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 3,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (c:customer)-[e:owns]->(a:account) ON bank_graph",
"WHERE c.cst_id = 10"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667290123386,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[-269.5182492753414,-89.64711504104181,1.6979607726867811,759]],\"lastColumns\":[\"C\",\"A\",\"E\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667290120793,
"endTime" : 1667290123386,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_3\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A\"]},{\"_id\":\"BANK_CUSTOMER(10)\",\"p\":[{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false},{\"n\":\"FIRST_NAME\",\"v\":\"Laura\",\"s\":false},{\"n\":\"LAST_NAME\",\"v\":\"Espinal\",\"s\":false}],\"l\":[\"CUSTOMER\"],\"g\":[\"C\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A\"]}],\"edges\":[{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"OWNS\"],\"g\":[\"E\"],\"s\":\"BANK_CUSTOMER(10)\",\"d\":\"BANK_ACCOUNT(90)\",\"u\":false},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"OWNS\"],\"g\":[\"E\"],\"s\":\"BANK_CUSTOMER(10)\",\"d\":\"BANK_ACCOUNT(10)\",\"u\":false}],\"paths\":[],\"totalNumResults\":2},\"table\":\"C\\tA\\tE\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 4,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%python-pgx",
"import time",
"time_s = time.time()",
"session.execute_pgql(\"\"\"",
"SELECT *",
"FROM MATCH (a1:account)-/:transferred_to*/->(a2:account) ON bank_graph",
"WHERE a1.acc_id = 10",
"\"\"\")",
"time_e = time.time()",
"print(time_e - time_s)"
],
"selectedVisualization" : "raw",
"visualizationConfig" : null,
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667185254691,
"endTime" : 1667185255002,
"interpreter" : "python-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "0.207047700881958\n",
"type" : "TEXT"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 5,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%java-pgx",
"long timeStart = System.nanoTime()",
"session.executePgql(\"SELECT * FROM MATCH (a1:account)-/:transferred_to*/->(a2:account) ON bank_graph WHERE a1.acc_id = 10\")",
"long timeEnd = System.nanoTime()",
"(timeEnd - timeStart) / 1000 / 1000 + \"ms\""
],
"selectedVisualization" : "raw",
"visualizationConfig" : null,
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667185292003,
"endTime" : 1667185292431,
"interpreter" : "java-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "\"169ms\"\n",
"type" : "TEXT"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 6,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (a1:account)-/:transferred_to*/->(a2:account) ON bank_graph",
"WHERE a1.acc_id = 10"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667290137639,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[123.15499954769206,35.17353566425675,0.6750261532508849,759]],\"lastColumns\":[\"A1\",\"A2\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667290136830,
"endTime" : 1667290137639,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_4\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(49)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"49\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(37)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"37\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(89)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"89\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(77)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"77\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(25)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"25\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(13)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"13\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(41)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"41\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(65)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"65\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(7)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"7\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(53)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"53\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(81)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"81\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(93)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"93\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(48)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"48\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(12)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"12\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(88)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"88\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(36)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"36\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(24)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"24\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(52)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"52\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(40)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"40\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(6)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"6\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(76)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"76\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(64)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"64\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(92)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"92\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(80)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"80\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(27)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"27\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(15)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"15\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(39)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"39\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(67)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"67\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(55)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"55\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(1)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"1\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(79)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"79\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(95)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"95\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(43)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"43\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(31)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"31\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(9)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"9\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(83)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"83\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(71)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"71\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(38)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"38\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(26)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"26\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(78)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"78\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(0)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"0\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(66)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"66\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(14)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"14\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(30)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"30\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(54)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"54\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(42)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"42\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(70)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"70\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(8)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"8\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(94)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"94\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(82)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"82\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(29)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"29\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(17)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"17\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(45)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"45\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(33)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"33\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(69)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"69\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(57)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"57\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(3)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"3\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(85)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"85\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(73)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"73\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(21)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"21\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(97)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"97\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(61)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"61\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(16)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"16\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(28)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"28\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(56)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"56\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(44)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"44\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(2)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"2\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(68)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"68\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(96)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"96\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(84)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"84\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(32)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"32\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(20)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"20\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(72)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"72\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(60)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"60\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(19)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"19\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(59)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"59\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(23)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"23\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(11)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"11\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(99)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"99\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(47)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"47\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(35)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"35\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(63)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"63\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(51)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"51\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(5)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"5\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(87)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"87\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(75)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"75\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(91)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"91\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(18)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"18\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(34)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"34\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(22)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"22\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(58)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"58\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(46)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"46\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(74)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"74\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(4)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"4\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(62)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"62\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\",\"A2\"]},{\"_id\":\"BANK_ACCOUNT(98)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"98\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(86)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"86\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(50)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"50\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]}],\"edges\":[],\"paths\":[],\"totalNumResults\":100},\"table\":\"A1\\tA2\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=60,ID=BANK_ACCOUNT(60)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=92,ID=BANK_ACCOUNT(92)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=97,ID=BANK_ACCOUNT(97)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=78,ID=BANK_ACCOUNT(78)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=12,ID=BANK_ACCOUNT(12)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=24,ID=BANK_ACCOUNT(24)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=28,ID=BANK_ACCOUNT(28)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=32,ID=BANK_ACCOUNT(32)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=36,ID=BANK_ACCOUNT(36)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=44,ID=BANK_ACCOUNT(44)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=64,ID=BANK_ACCOUNT(64)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=13,ID=BANK_ACCOUNT(13)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=21,ID=BANK_ACCOUNT(21)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=93,ID=BANK_ACCOUNT(93)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=11,ID=BANK_ACCOUNT(11)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=19,ID=BANK_ACCOUNT(19)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=79,ID=BANK_ACCOUNT(79)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=8,ID=BANK_ACCOUNT(8)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=84,ID=BANK_ACCOUNT(84)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=88,ID=BANK_ACCOUNT(88)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=9,ID=BANK_ACCOUNT(9)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=6,ID=BANK_ACCOUNT(6)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=54,ID=BANK_ACCOUNT(54)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=58,ID=BANK_ACCOUNT(58)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=66,ID=BANK_ACCOUNT(66)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=35,ID=BANK_ACCOUNT(35)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=51,ID=BANK_ACCOUNT(51)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=55,ID=BANK_ACCOUNT(55)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=20,ID=BANK_ACCOUNT(20)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=48,ID=BANK_ACCOUNT(48)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=33,ID=BANK_ACCOUNT(33)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=69,ID=BANK_ACCOUNT(69)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=81,ID=BANK_ACCOUNT(81)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=89,ID=BANK_ACCOUNT(89)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=22,ID=BANK_ACCOUNT(22)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=34,ID=BANK_ACCOUNT(34)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=38,ID=BANK_ACCOUNT(38)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=94,ID=BANK_ACCOUNT(94)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=40,ID=BANK_ACCOUNT(40)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=72,ID=BANK_ACCOUNT(72)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=65,ID=BANK_ACCOUNT(65)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=4,ID=BANK_ACCOUNT(4)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=80,ID=BANK_ACCOUNT(80)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=41,ID=BANK_ACCOUNT(41)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=85,ID=BANK_ACCOUNT(85)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=2,ID=BANK_ACCOUNT(2)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=7,ID=BANK_ACCOUNT(7)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=15,ID=BANK_ACCOUNT(15)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=31,ID=BANK_ACCOUNT(31)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=63,ID=BANK_ACCOUNT(63)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=91,ID=BANK_ACCOUNT(91)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=99,ID=BANK_ACCOUNT(99)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=37,ID=BANK_ACCOUNT(37)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=45,ID=BANK_ACCOUNT(45)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=73,ID=BANK_ACCOUNT(73)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=43,ID=BANK_ACCOUNT(43)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=83,ID=BANK_ACCOUNT(83)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=87,ID=BANK_ACCOUNT(87)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=68,ID=BANK_ACCOUNT(68)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=57,ID=BANK_ACCOUNT(57)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=26,ID=BANK_ACCOUNT(26)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=82,ID=BANK_ACCOUNT(82)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=98,ID=BANK_ACCOUNT(98)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=16,ID=BANK_ACCOUNT(16)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=1,ID=BANK_ACCOUNT(1)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=29,ID=BANK_ACCOUNT(29)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=30,ID=BANK_ACCOUNT(30)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=46,ID=BANK_ACCOUNT(46)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=50,ID=BANK_ACCOUNT(50)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=27,ID=BANK_ACCOUNT(27)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=39,ID=BANK_ACCOUNT(39)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=53,ID=BANK_ACCOUNT(53)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=47,ID=BANK_ACCOUNT(47)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=76,ID=BANK_ACCOUNT(76)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=5,ID=BANK_ACCOUNT(5)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=14,ID=BANK_ACCOUNT(14)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=67,ID=BANK_ACCOUNT(67)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=17,ID=BANK_ACCOUNT(17)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=71,ID=BANK_ACCOUNT(71)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=52,ID=BANK_ACCOUNT(52)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=42,ID=BANK_ACCOUNT(42)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=86,ID=BANK_ACCOUNT(86)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=96,ID=BANK_ACCOUNT(96)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=18,ID=BANK_ACCOUNT(18)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=56,ID=BANK_ACCOUNT(56)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=95,ID=BANK_ACCOUNT(95)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=3,ID=BANK_ACCOUNT(3)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=0,ID=BANK_ACCOUNT(0)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 7,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"Next, let’s show all of Laura’s transfers.",
"We will add one more hop to the matching pattern.",
"Since there are two accounts in the pattern, we assign different variables for them, like \"a\" and \"a1\".",
"",
"You can see that Laura has transferred money to some accounts using both of the two accounts."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403166245,
"endTime" : 1656403166294,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>Next, let’s show all of Laura’s transfers.\nWe will add one more hop to the matching pattern.\nSince there are two accounts in the pattern, we assign different variables for them, like "a" and "a1".</p>\n<p>You can see that Laura has transferred money to some accounts using both of the two accounts.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 8,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (c:customer)-[e:owns]->(a:account)-[t:transferred_to]->(a1:account) ON bank_graph",
"WHERE c.cst_id = 10"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"vertexPositions\":[{\"id\":\"CUSTOMER(10)\",\"x\":0.011259011960710831,\"y\":0.46872102867941606},{\"id\":\"ACCOUNT(10)\",\"x\":0.14605911109779468,\"y\":0.37297293101815754},{\"id\":\"ACCOUNT(90)\",\"x\":0.14340113295601045,\"y\":0.5670409146520858}],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667290159647,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[38.72494020674935,5.709407763668452,0.8928872688120679,759]],\"lastColumns\":[\"C\",\"A\",\"A1\",\"E\",\"T\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667290158928,
"endTime" : 1667290159647,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_5\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(49)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"49\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(59)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"59\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(17)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"17\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_CUSTOMER(10)\",\"p\":[{\"n\":\"LAST_NAME\",\"v\":\"Espinal\",\"s\":false},{\"n\":\"FIRST_NAME\",\"v\":\"Laura\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"CUSTOMER\"],\"g\":[\"C\"]},{\"_id\":\"BANK_ACCOUNT(23)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"23\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(77)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"77\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(25)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"25\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(47)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"47\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(79)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"79\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(97)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"97\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(75)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"75\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(53)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"53\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(9)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"9\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(61)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"61\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(71)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"71\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(18)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"18\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(78)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"78\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(12)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"12\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(22)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"22\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(58)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"58\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(24)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"24\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(74)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"74\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(62)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"62\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A\"]},{\"_id\":\"BANK_ACCOUNT(54)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"54\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(92)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"92\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(70)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"70\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(60)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"60\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A\"]}],\"edges\":[{\"_id\":\"BANK_TRANSACTION(9009)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T12:10:17\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9009\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(58)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9017)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T12:24:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9017\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(61)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1041)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T16:44:02\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1041\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(62)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1038)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T14:04:13\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1038\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1026)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"400.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T10:36:56\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1026\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(78)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1014)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T12:48:39\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1014\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1046)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"400.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T08:59:55\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1046\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1002)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T20:28:42\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1002\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(97)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1034)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T22:41:50\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1034\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1022)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T19:13:41\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1022\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1010)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T16:49:13\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1010\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1042)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T11:43:10\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1042\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9016)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T01:36:48\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9016\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(53)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9004)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T09:47:29\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9004\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9012)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T01:33:31\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9012\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9000)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-17T22:54:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9000\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(54)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1018)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T14:28:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1018\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1006)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T02:43\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1006\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(92)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9018)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T14:28:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9018\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(18)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9006)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-18T14:16:08\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9006\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(71)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1040)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T04:04:37\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1040\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(70)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1049)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T19:38:21\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1049\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1005)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"600.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T22:18:24\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1005\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1037)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T10:51:41\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1037\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1025)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-18T01:26:12\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1025\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(62)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1013)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T06:46:54\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1013\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(60)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1045)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T13:14:45\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1045\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(60)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1001)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1001\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1033)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"400.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T01:08:27\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1033\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1021)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T13:19:06\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1021\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9005)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"600.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T22:18:24\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9005\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9013)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T06:46:54\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9013\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(24)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1009)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T12:10:17\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1009\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(70)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9001)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9001\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(17)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1029)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T03:16:04\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1029\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1017)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T12:24:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1017\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9019)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T19:22:51\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9019\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(79)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9007)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T20:29:15\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9007\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(47)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1016)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T01:36:48\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1016\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(61)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1048)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T12:42:31\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1048\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1004)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T09:47:29\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1004\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1036)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T23:00:31\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1036\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(61)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1024)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T04:53:11\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1024\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(78)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1012)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T01:33:31\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1012\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(70)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1000)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T05:27:31\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1000\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(97)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1044)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T13:48:17\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1044\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(62)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1032)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T15:21:33\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1032\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1020)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-17T05:42:03\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1020\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(78)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9014)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T12:48:39\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9014\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(12)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9002)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"600.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T06:58:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9002\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(9)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1008)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T01:53:55\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1008\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9010)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T16:49:13\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9010\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(71)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1028)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-17T19:09:53\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1028\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9008)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-14T01:53:55\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9008\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1030)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-18T10:56:18\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1030\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"OWNS\"],\"g\":[\"E\"],\"s\":\"BANK_CUSTOMER(10)\",\"d\":\"BANK_ACCOUNT(10)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1027)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"500.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T04:10:17\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1027\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1015)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1015\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1047)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T00:00:21\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1047\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(61)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1003)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1003\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1035)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T17:29:19\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1035\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(74)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1023)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T20:39:55\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1023\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(92)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1011)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T00:46:41\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1011\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(70)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1043)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T05:39:36\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1043\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"OWNS\"],\"g\":[\"E\"],\"s\":\"BANK_CUSTOMER(10)\",\"d\":\"BANK_ACCOUNT(90)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1031)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T01:41:55\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1031\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9015)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9015\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(22)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9003)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9003\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1019)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T19:22:51\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1019\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9011)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T00:46:41\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9011\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(58)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1007)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-19T20:29:15\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1007\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(61)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1039)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1039\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(59)\",\"u\":false}],\"paths\":[],\"totalNumResults\":70},\"table\":\"C\\tA\\tA1\\tE\\tT\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=60,ID=BANK_ACCOUNT(60)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1045,ID=BANK_TRANSACTION(1045)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=60,ID=BANK_ACCOUNT(60)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1013,ID=BANK_TRANSACTION(1013)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=92,ID=BANK_ACCOUNT(92)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1006,ID=BANK_TRANSACTION(1006)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=92,ID=BANK_ACCOUNT(92)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1023,ID=BANK_TRANSACTION(1023)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1032,ID=BANK_TRANSACTION(1032)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1014,ID=BANK_TRANSACTION(1014)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1049,ID=BANK_TRANSACTION(1049)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1046,ID=BANK_TRANSACTION(1046)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1028,ID=BANK_TRANSACTION(1028)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1001,ID=BANK_TRANSACTION(1001)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1022,ID=BANK_TRANSACTION(1022)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1018,ID=BANK_TRANSACTION(1018)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1021,ID=BANK_TRANSACTION(1021)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1036,ID=BANK_TRANSACTION(1036)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1016,ID=BANK_TRANSACTION(1016)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1047,ID=BANK_TRANSACTION(1047)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1007,ID=BANK_TRANSACTION(1007)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1027,ID=BANK_TRANSACTION(1027)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1038,ID=BANK_TRANSACTION(1038)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1042,ID=BANK_TRANSACTION(1042)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1037,ID=BANK_TRANSACTION(1037)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1019,ID=BANK_TRANSACTION(1019)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=97,ID=BANK_ACCOUNT(97)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1000,ID=BANK_TRANSACTION(1000)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=97,ID=BANK_ACCOUNT(97)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1002,ID=BANK_TRANSACTION(1002)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1041,ID=BANK_TRANSACTION(1041)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1044,ID=BANK_TRANSACTION(1044)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1025,ID=BANK_TRANSACTION(1025)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1012,ID=BANK_TRANSACTION(1012)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1011,ID=BANK_TRANSACTION(1011)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1040,ID=BANK_TRANSACTION(1040)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1009,ID=BANK_TRANSACTION(1009)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1034,ID=BANK_TRANSACTION(1034)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1017,ID=BANK_TRANSACTION(1017)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1048,ID=BANK_TRANSACTION(1048)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1030,ID=BANK_TRANSACTION(1030)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1029,ID=BANK_TRANSACTION(1029)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=74,ID=BANK_ACCOUNT(74)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1035,ID=BANK_TRANSACTION(1035)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=78,ID=BANK_ACCOUNT(78)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1024,ID=BANK_TRANSACTION(1024)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=78,ID=BANK_ACCOUNT(78)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1026,ID=BANK_TRANSACTION(1026)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=78,ID=BANK_ACCOUNT(78)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1020,ID=BANK_TRANSACTION(1020)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1043,ID=BANK_TRANSACTION(1043)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1031,ID=BANK_TRANSACTION(1031)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1015,ID=BANK_TRANSACTION(1015)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1008,ID=BANK_TRANSACTION(1008)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1039,ID=BANK_TRANSACTION(1039)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1004,ID=BANK_TRANSACTION(1004)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1003,ID=BANK_TRANSACTION(1003)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1005,ID=BANK_TRANSACTION(1005)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1033,ID=BANK_TRANSACTION(1033)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxEdge[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1010,ID=BANK_TRANSACTION(1010)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=12,ID=BANK_ACCOUNT(12)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9014,ID=BANK_TRANSACTION(9014)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=24,ID=BANK_ACCOUNT(24)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9013,ID=BANK_TRANSACTION(9013)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=9,ID=BANK_ACCOUNT(9)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9002,ID=BANK_TRANSACTION(9002)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=17,ID=BANK_ACCOUNT(17)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9001,ID=BANK_TRANSACTION(9001)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=53,ID=BANK_ACCOUNT(53)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9016,ID=BANK_TRANSACTION(9016)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9017,ID=BANK_TRANSACTION(9017)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=18,ID=BANK_ACCOUNT(18)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9018,ID=BANK_TRANSACTION(9018)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=22,ID=BANK_ACCOUNT(22)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9015,ID=BANK_TRANSACTION(9015)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=54,ID=BANK_ACCOUNT(54)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9000,ID=BANK_TRANSACTION(9000)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=58,ID=BANK_ACCOUNT(58)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9009,ID=BANK_TRANSACTION(9009)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=58,ID=BANK_ACCOUNT(58)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9011,ID=BANK_TRANSACTION(9011)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9003,ID=BANK_TRANSACTION(9003)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9004,ID=BANK_TRANSACTION(9004)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9008,ID=BANK_TRANSACTION(9008)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=47,ID=BANK_ACCOUNT(47)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9007,ID=BANK_TRANSACTION(9007)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=59,ID=BANK_ACCOUNT(59)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9012,ID=BANK_TRANSACTION(9012)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=71,ID=BANK_ACCOUNT(71)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9006,ID=BANK_TRANSACTION(9006)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=71,ID=BANK_ACCOUNT(71)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9010,ID=BANK_TRANSACTION(9010)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9005,ID=BANK_TRANSACTION(9005)]\\nPgxVertex[provider=BANK_CUSTOMER,key=10,ID=BANK_CUSTOMER(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=79,ID=BANK_ACCOUNT(79)]\\tPgxEdge[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9019,ID=BANK_TRANSACTION(9019)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 9,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"Now, focusing only on the transfers between accounts, let’s look for a pattern starting from the account with acc_id = 10 and returning to the same account in 3 hops. Furthermore, we can add a condition that these transfers happened in this order in time, and the amount of money transfer must always be more than 500.",
"",
"In the whole graph, this pattern is detected only in the paths that include the accounts with acc_id = 10, 75, and 77."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403179532,
"endTime" : 1656403179579,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>Now, focusing only on the transfers between accounts, let’s look for a pattern starting from the account with acc_id = 10 and returning to the same account in 3 hops. Furthermore, we can add a condition that these transfers happened in this order in time, and the amount of money transfer must always be more than 500.</p>\n<p>In the whole graph, this pattern is detected only in the paths that include the accounts with acc_id = 10, 75, and 77.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 10,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (",
" (a1)-[t1:transferred_to]->(a2)-[t2:transferred_to]->(a3)",
" , (a3)-[t3:transferred_to]->(a1)",
" ) ON bank_graph",
"WHERE a1.acc_id = 10",
" AND t1.amount > 500 AND t2.amount > 500 AND t3.amount > 500",
" AND t1.datetime < t2.datetime AND t2.datetime < t3.datetime"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667291592073,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[-198.45986139453362,-66.26681068170964,1.5525526156518457,759]],\"lastColumns\":[\"A1\",\"A2\",\"A3\",\"T1\",\"T2\",\"T3\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667291590380,
"endTime" : 1667291592073,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_7\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(77)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"77\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A3\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(75)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"75\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]}],\"edges\":[{\"_id\":\"BANK_TRANSACTION(1005)\",\"p\":[{\"n\":\"TXN_ID\",\"v\":\"1005\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T22:18:24\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"600.0\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T1\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7512)\",\"p\":[{\"n\":\"DATETIME\",\"v\":\"2020-11-13T01:33:31\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7512\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T2\"],\"s\":\"BANK_ACCOUNT(75)\",\"d\":\"BANK_ACCOUNT(77)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7714)\",\"p\":[{\"n\":\"DATETIME\",\"v\":\"2020-11-16T12:48:39\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7714\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T3\"],\"s\":\"BANK_ACCOUNT(77)\",\"d\":\"BANK_ACCOUNT(10)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1010)\",\"p\":[{\"n\":\"TXN_ID\",\"v\":\"1010\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T16:49:13\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T1\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(75)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7728)\",\"p\":[{\"n\":\"DATETIME\",\"v\":\"2020-11-17T19:09:53\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7728\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T3\"],\"s\":\"BANK_ACCOUNT(77)\",\"d\":\"BANK_ACCOUNT(10)\",\"u\":false}],\"paths\":[],\"totalNumResults\":4},\"table\":\"A1\\tA2\\tA3\\tT1\\tT2\\tT3\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1005,ID=BANK_TRANSACTION(1005)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7512,ID=BANK_TRANSACTION(7512)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7728,ID=BANK_TRANSACTION(7728)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1005,ID=BANK_TRANSACTION(1005)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7512,ID=BANK_TRANSACTION(7512)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7714,ID=BANK_TRANSACTION(7714)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1010,ID=BANK_TRANSACTION(1010)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7512,ID=BANK_TRANSACTION(7512)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7728,ID=BANK_TRANSACTION(7728)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=77,ID=BANK_ACCOUNT(77)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1010,ID=BANK_TRANSACTION(1010)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7512,ID=BANK_TRANSACTION(7512)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7714,ID=BANK_TRANSACTION(7714)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 11,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"Similarly, we will try it for 4 hops. The query is getting longer, but it is still much more compact than it would be in SQL.",
"",
"Again, the pattern is detected only in one combination in the case of 4 hops."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403263972,
"endTime" : 1656403264031,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>Similarly, we will try it for 4 hops. The query is getting longer, but it is still much more compact than it would be in SQL.</p>\n<p>Again, the pattern is detected only in one combination in the case of 4 hops.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 12,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (",
" (a1)-[t1:transferred_to]->(a2)-[t2:transferred_to]->(a3)",
" , (a3)-[t3:transferred_to]->(a4)-[t4:transferred_to]->(a1)",
" ) ON bank_graph",
"WHERE a1.acc_id = 10 AND ALL_DIFFERENT(a1, a2, a3, a4)",
" AND t1.amount > 500 AND t2.amount > 500",
" AND t3.amount > 500 AND t4.amount > 500",
" AND t1.datetime < t2.datetime AND t2.datetime < t3.datetime",
" AND t3.datetime < t4.datetime"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"vertexPositions\":[{\"id\":\"ACCOUNT(81)\",\"x\":0.42728533268644153,\"y\":0.38461921438327334},{\"id\":\"ACCOUNT(49)\",\"x\":0.510828505742056,\"y\":0.35137339103826826}],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667291603321,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[-343.43412593968446,-123.25419339134945,1.904964835328435,759]],\"lastColumns\":[\"A1\",\"A2\",\"A3\",\"A4\",\"T1\",\"T2\",\"T3\",\"T4\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667291601330,
"endTime" : 1667291603321,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_8\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(81)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"81\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A3\"]},{\"_id\":\"BANK_ACCOUNT(49)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"49\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(25)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"25\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A4\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]}],\"edges\":[{\"_id\":\"BANK_TRANSACTION(2531)\",\"p\":[{\"n\":\"TXN_ID\",\"v\":\"2531\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-15T01:41:55\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T4\"],\"s\":\"BANK_ACCOUNT(25)\",\"d\":\"BANK_ACCOUNT(10)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(4905)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"600.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T22:18:24\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"4905\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T2\"],\"s\":\"BANK_ACCOUNT(49)\",\"d\":\"BANK_ACCOUNT(81)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1022)\",\"p\":[{\"n\":\"TXN_ID\",\"v\":\"1022\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T19:13:41\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T1\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1018)\",\"p\":[{\"n\":\"TXN_ID\",\"v\":\"1018\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-11T14:28:32\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"800.0\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T1\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(49)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(8121)\",\"p\":[{\"n\":\"DATETIME\",\"v\":\"2020-11-14T13:19:06\",\"s\":false},{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"8121\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T3\"],\"s\":\"BANK_ACCOUNT(81)\",\"d\":\"BANK_ACCOUNT(25)\",\"u\":false}],\"paths\":[],\"totalNumResults\":2},\"table\":\"A1\\tA2\\tA3\\tA4\\tT1\\tT2\\tT3\\tT4\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxVertex[provider=BANK_ACCOUNT,key=81,ID=BANK_ACCOUNT(81)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1022,ID=BANK_TRANSACTION(1022)]\\tPgxEdge[provider=BANK_TRANSACTION,key=4905,ID=BANK_TRANSACTION(4905)]\\tPgxEdge[provider=BANK_TRANSACTION,key=8121,ID=BANK_TRANSACTION(8121)]\\tPgxEdge[provider=BANK_TRANSACTION,key=2531,ID=BANK_TRANSACTION(2531)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=49,ID=BANK_ACCOUNT(49)]\\tPgxVertex[provider=BANK_ACCOUNT,key=81,ID=BANK_ACCOUNT(81)]\\tPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1018,ID=BANK_TRANSACTION(1018)]\\tPgxEdge[provider=BANK_TRANSACTION,key=4905,ID=BANK_TRANSACTION(4905)]\\tPgxEdge[provider=BANK_TRANSACTION,key=8121,ID=BANK_TRANSACTION(8121)]\\tPgxEdge[provider=BANK_TRANSACTION,key=2531,ID=BANK_TRANSACTION(2531)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 13,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"It is also possible to aggregate using GROUP BY. For example, let’s look for accounts that received a large number of small remittances (less than 500) during the period between Oct 1 and Dec 1.",
"",
"However, the aggregation results cannot be represented as a graph, so you will have to show them in a table."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403307015,
"endTime" : 1656403307065,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>It is also possible to aggregate using GROUP BY. For example, let’s look for accounts that received a large number of small remittances (less than 500) during the period between Oct 1 and Dec 1.</p>\n<p>However, the aggregation results cannot be represented as a graph, so you will have to show them in a table.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 14,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT a2.acc_id AS acc_id, COUNT(a2) AS num_of_txn",
"FROM MATCH (a1)-[t:transferred_to]->(a2) ON bank_graph",
"WHERE t.datetime >= TIMESTAMP '2020-10-01 00:00:00'",
" AND t.datetime < TIMESTAMP '2020-12-01 00:00:00'",
" AND t.amount < 500.00",
"GROUP BY a2 ORDER BY num_of_txn DESC LIMIT 10"
],
"selectedVisualization" : "table",
"visualizationConfig" : "[{\"table\":{\"lastColumns\":[\"ACC_ID\",\"NUM_OF_TXN\"],\"version\":1}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667185367671,
"endTime" : 1667185368312,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"table\":\"ACC_ID\\tNUM_OF_TXN\\n23\\t29\\n41\\t27\\n33\\t26\\n30\\t24\\n74\\t20\\n34\\t20\\n24\\t19\\n37\\t19\\n99\\t18\\n46\\t18\",\"totalNumResults\":10}",
"type" : "TABLE"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 15,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"The account with acc_id = 23 has received 29 transfers, so let’s show them.",
"",
"You can confirm the transfers."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403348736,
"endTime" : 1656403348796,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>The account with acc_id = 23 has received 29 transfers, so let’s show them.</p>\n<p>You can confirm the transfers.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 16,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (a1)-[t:transferred_to]->(a2)<-[o:owns]-(c) ON bank_graph",
"WHERE t.datetime >= TIMESTAMP '2020-10-01 00:00:00'",
" AND t.datetime < TIMESTAMP '2020-12-01 00:00:00'",
" AND t.amount < 500.00",
" AND a2.acc_id = 23"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"vertexPositions\":[{\"id\":\"CUSTOMER(23)\",\"x\":0.12872142792370858,\"y\":0.5935668560942443},{\"id\":\"ACCOUNT(23)\",\"x\":0.22914529531050698,\"y\":0.5935667892492692}],\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667185373728,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"}]}},\"viewTransform\":[[56.26475737712184,5.595296052469607,0.8984263527772884,759]],\"lastColumns\":[\"A1\",\"A2\",\"C\",\"T\",\"O\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667185373213,
"endTime" : 1667185373728,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_15\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(17)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"17\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(23)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"23\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(78)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"78\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(33)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"33\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(36)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"36\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_CUSTOMER(23)\",\"p\":[{\"n\":\"FIRST_NAME\",\"v\":\"Darleen\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"23\",\"s\":false},{\"n\":\"LAST_NAME\",\"v\":\"Warner\",\"s\":false}],\"l\":[\"CUSTOMER\"],\"g\":[\"C\"]},{\"_id\":\"BANK_ACCOUNT(25)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"25\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(47)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"47\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(35)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"35\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(41)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"41\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(5)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"5\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(62)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"62\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(65)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"65\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(64)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"64\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(53)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"53\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(75)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"75\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(92)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"92\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(61)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"61\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(60)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"60\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(71)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"71\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]},{\"_id\":\"BANK_ACCOUNT(90)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"90\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]}],\"edges\":[{\"_id\":\"BANK_TRANSACTION(7115)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7115\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(71)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7515)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7515\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(75)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7539)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7539\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(75)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_ACCOUNT(23)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"23\",\"s\":false},{\"n\":\"CST_ID\",\"v\":\"23\",\"s\":false}],\"l\":[\"OWNS\"],\"g\":[\"O\"],\"s\":\"BANK_CUSTOMER(23)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(2539)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"2539\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(25)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6501)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6501\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(65)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(2515)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"2515\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(25)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(2503)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"2503\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(25)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6115)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6115\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(61)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6139)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6139\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(61)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1703)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1703\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(17)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(5339)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"5339\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(53)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7813)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T06:46:54\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7813\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(78)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(5315)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"5315\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(53)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9220)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:21:30\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9220\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(92)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(3601)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"3601\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(36)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(4703)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"4703\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(47)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(503)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"503\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(5)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6401)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6401\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(64)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(4103)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"4103\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(41)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6520)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:21:30\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6520\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(65)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6015)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6015\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(60)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(3515)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"3515\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(35)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(3539)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"3539\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(35)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6215)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-10T11:47:49\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6215\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(62)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(6239)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"100.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-12T23:19:09\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6239\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(62)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1043)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T05:39:36\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1043\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9003)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T07:14:01\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9003\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(90)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(9201)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"200.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T01:36:32\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"9201\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(92)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(3313)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"300.0\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T06:46:54\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"3313\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(33)\",\"d\":\"BANK_ACCOUNT(23)\",\"u\":false}],\"paths\":[],\"totalNumResults\":29},\"table\":\"A1\\tA2\\tC\\tT\\tO\\nPgxVertex[provider=BANK_ACCOUNT,key=36,ID=BANK_ACCOUNT(36)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=3601,ID=BANK_TRANSACTION(3601)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=60,ID=BANK_ACCOUNT(60)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6015,ID=BANK_TRANSACTION(6015)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=64,ID=BANK_ACCOUNT(64)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6401,ID=BANK_TRANSACTION(6401)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=92,ID=BANK_ACCOUNT(92)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9201,ID=BANK_TRANSACTION(9201)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=92,ID=BANK_ACCOUNT(92)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9220,ID=BANK_TRANSACTION(9220)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=5,ID=BANK_ACCOUNT(5)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=503,ID=BANK_TRANSACTION(503)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=17,ID=BANK_ACCOUNT(17)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1703,ID=BANK_TRANSACTION(1703)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=2515,ID=BANK_TRANSACTION(2515)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=2503,ID=BANK_TRANSACTION(2503)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=25,ID=BANK_ACCOUNT(25)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=2539,ID=BANK_TRANSACTION(2539)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=33,ID=BANK_ACCOUNT(33)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=3313,ID=BANK_TRANSACTION(3313)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=41,ID=BANK_ACCOUNT(41)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=4103,ID=BANK_TRANSACTION(4103)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=53,ID=BANK_ACCOUNT(53)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=5339,ID=BANK_TRANSACTION(5339)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=53,ID=BANK_ACCOUNT(53)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=5315,ID=BANK_TRANSACTION(5315)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6115,ID=BANK_TRANSACTION(6115)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=61,ID=BANK_ACCOUNT(61)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6139,ID=BANK_TRANSACTION(6139)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=65,ID=BANK_ACCOUNT(65)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6501,ID=BANK_TRANSACTION(6501)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=65,ID=BANK_ACCOUNT(65)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6520,ID=BANK_TRANSACTION(6520)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1043,ID=BANK_TRANSACTION(1043)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6239,ID=BANK_TRANSACTION(6239)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6215,ID=BANK_TRANSACTION(6215)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=78,ID=BANK_ACCOUNT(78)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7813,ID=BANK_TRANSACTION(7813)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=90,ID=BANK_ACCOUNT(90)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=9003,ID=BANK_TRANSACTION(9003)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=35,ID=BANK_ACCOUNT(35)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=3515,ID=BANK_TRANSACTION(3515)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=35,ID=BANK_ACCOUNT(35)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=3539,ID=BANK_TRANSACTION(3539)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=47,ID=BANK_ACCOUNT(47)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=4703,ID=BANK_TRANSACTION(4703)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=71,ID=BANK_ACCOUNT(71)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7115,ID=BANK_TRANSACTION(7115)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7515,ID=BANK_TRANSACTION(7515)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\nPgxVertex[provider=BANK_ACCOUNT,key=75,ID=BANK_ACCOUNT(75)]\\tPgxVertex[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\\tPgxVertex[provider=BANK_CUSTOMER,key=23,ID=BANK_CUSTOMER(23)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7539,ID=BANK_TRANSACTION(7539)]\\tPgxEdge[provider=BANK_ACCOUNT,key=23,ID=BANK_ACCOUNT(23)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 17,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"# Run path-finding queries",
"",
"---",
"",
"Although PGQL queries can still be executed in the database (by being rewritten into SQL queries), we can expect some queries to become faster when the graph is deployed in the memory of Graph Server. Path-finding is one example.",
"",
"The following query uses the TOP K SHORTEST clause to retrieve the shortest K (in this case, 5) paths between two accounts (one with acc_id = 10 and another with accc_id = 50). The condition COUNT(a) = COUNT(DISTINCT a)eliminates paths that go through the same account more than once."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656481984275,
"endTime" : 1656481984347,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<h1 id=\"run-path-finding-queries\">Run path-finding queries</h1>\n<hr />\n<p>Although PGQL queries can still be executed in the database (by being rewritten into SQL queries), we can expect some queries to become faster when the graph is deployed in the memory of Graph Server. Path-finding is one example.</p>\n<p>The following query uses the TOP K SHORTEST clause to retrieve the shortest K (in this case, 5) paths between two accounts (one with acc_id = 10 and another with accc_id = 50). The condition COUNT(a) = COUNT(DISTINCT a)eliminates paths that go through the same account more than once.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 18,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT ARRAY_AGG(a.acc_id) AS acc_ids",
" , ARRAY_AGG(t.txn_id) AS txn_ids",
" , ARRAY_AGG(t.amount) AS amounts",
"FROM MATCH TOP 5 SHORTEST ((a1) (-[t:transferred_to]->(a))* (a2)) ON bank_graph",
"WHERE a1.acc_id = 10 AND a2.acc_id = 50",
" AND COUNT(a) = COUNT(DISTINCT a)"
],
"selectedVisualization" : "table",
"visualizationConfig" : "[{\"table\":{\"lastColumns\":[\"ACC_IDS\",\"TXN_IDS\",\"AMOUNTS\"],\"version\":1}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : false,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667185379038,
"endTime" : 1667185379603,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_16\",\"graph\":{\"idType\":\"number\",\"vertices\":[],\"edges\":[],\"paths\":[],\"totalNumResults\":5},\"table\":\"ACC_IDS\\tTXN_IDS\\tAMOUNTS\\n[62, 50]\\t[1044, 6212]\\t[200.0, 900.0]\\n[62, 50]\\t[1044, 6227]\\t[200.0, 500.0]\\n[62, 50]\\t[1025, 6212]\\t[100.0, 900.0]\\n[62, 50]\\t[1025, 6227]\\t[100.0, 500.0]\\n[62, 50]\\t[1041, 6212]\\t[300.0, 900.0]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 19,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"You can also include a condition that the amount of all transfers must be greater than 500."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403560993,
"endTime" : 1656403561040,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>You can also include a condition that the amount of all transfers must be greater than 500.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 20,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT ARRAY_AGG(a.acc_id) AS acc_ids",
" , ARRAY_AGG(t.txn_id) AS txn_ids",
" , ARRAY_AGG(t.amount) AS amounts",
"FROM MATCH TOP 5 SHORTEST",
" ((a1) (-[t:transferred_to]->(a) WHERE t.amount > 500)+ (a2)) ON bank_graph",
"WHERE a1.acc_id = 10 AND a2.acc_id = 50",
" AND COUNT(a) = COUNT(DISTINCT a)"
],
"selectedVisualization" : "table",
"visualizationConfig" : "[{\"table\":{\"lastColumns\":[\"ACC_IDS\",\"TXN_IDS\",\"AMOUNTS\"],\"version\":1}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667291688809,
"endTime" : 1667291690126,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_12\",\"graph\":{\"idType\":\"number\",\"vertices\":[],\"edges\":[],\"paths\":[],\"totalNumResults\":5},\"table\":\"ACC_IDS\\tTXN_IDS\\tAMOUNTS\\n[49, 58, 50]\\t[1018, 4900, 5805]\\t[800.0, 700.0, 900.0]\\n[61, 62, 50]\\t[1007, 6111, 6212]\\t[700.0, 800.0, 900.0]\\n[49, 58, 50]\\t[1022, 4900, 5805]\\t[800.0, 700.0, 900.0]\\n[49, 58, 50]\\t[1021, 4900, 5805]\\t[700.0, 700.0, 900.0]\\n[61, 62, 50]\\t[1047, 6111, 6212]\\t[900.0, 800.0, 900.0]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 21,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"Selecting one of the resulting paths, we can visualize it by using the list of transaction IDs. This series of queries and the logic between them would be implemented in the application layer in a real system."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1656403760362,
"endTime" : 1656403760409,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>Selecting one of the resulting paths, we can visualize it by using the list of transaction IDs. This series of queries and the logic between them would be implemented in the application layer in a real system.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 22,
"width" : 12,
"title" : null,
"hasTitle" : false,
"message" : [
"%pgql-pgx",
"SELECT *",
"FROM MATCH (a1)-[t]->(a2) ON bank_graph",
"WHERE t.txn_id IN (1040, 7000, 6212)"
],
"selectedVisualization" : "visualization",
"visualizationConfig" : "[{\"visualization\":{\"filters\":[],\"layout\":\"hierarchical\",\"layoutProperties\":{\"hierarchical\":{\"rankDirection\":\"leftRight\"}},\"graphAction\":{\"graphName\":\"BANK_GRAPH\",\"lastRun\":1667291696300,\"metadata\":{\"vertexProperties\":[{\"name\":\"id\",\"type\":\"string\"},{\"name\":\"ACC_ID\",\"type\":\"long\"},{\"name\":\"LAST_NAME\",\"type\":\"string\"},{\"name\":\"FIRST_NAME\",\"type\":\"string\"},{\"name\":\"CST_ID\",\"type\":\"long\"}],\"edgeProperties\":[{\"name\":\"id\",\"type\":\"integer\"},{\"name\":\"TXN_ID\",\"type\":\"long\"},{\"name\":\"AMOUNT\",\"type\":\"double\"},{\"name\":\"DATETIME\",\"type\":\"timestamp\"},{\"name\":\"CST_ID\",\"type\":\"long\"},{\"name\":\"ACC_ID\",\"type\":\"long\"}]}},\"viewTransform\":[[-840.4377682403433,-304.5723293451792,3.2145922746781115,759]],\"lastColumns\":[\"A1\",\"A2\",\"T\"],\"version\":9}}]",
"hideCode" : false,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667291694984,
"endTime" : 1667291696300,
"interpreter" : "pgql-pgx",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "{\"name\":\"BANK_GRAPH\",\"resultSetId\":\"pgql_13\",\"graph\":{\"idType\":\"string\",\"vertices\":[{\"_id\":\"BANK_ACCOUNT(70)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"70\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\",\"A2\"]},{\"_id\":\"BANK_ACCOUNT(50)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"50\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A2\"]},{\"_id\":\"BANK_ACCOUNT(62)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"62\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\",\"A2\"]},{\"_id\":\"BANK_ACCOUNT(10)\",\"p\":[{\"n\":\"ACC_ID\",\"v\":\"10\",\"s\":false}],\"l\":[\"ACCOUNT\"],\"g\":[\"A1\"]}],\"edges\":[{\"_id\":\"BANK_TRANSACTION(6212)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"6212\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-13T01:33:31\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(62)\",\"d\":\"BANK_ACCOUNT(50)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(1040)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"900.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"1040\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-16T04:04:37\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(10)\",\"d\":\"BANK_ACCOUNT(70)\",\"u\":false},{\"_id\":\"BANK_TRANSACTION(7000)\",\"p\":[{\"n\":\"AMOUNT\",\"v\":\"700.0\",\"s\":false},{\"n\":\"TXN_ID\",\"v\":\"7000\",\"s\":false},{\"n\":\"DATETIME\",\"v\":\"2020-11-17T22:54:32\",\"s\":false}],\"l\":[\"TRANSFERRED_TO\"],\"g\":[\"T\"],\"s\":\"BANK_ACCOUNT(70)\",\"d\":\"BANK_ACCOUNT(62)\",\"u\":false}],\"paths\":[],\"totalNumResults\":3},\"table\":\"A1\\tA2\\tT\\nPgxVertex[provider=BANK_ACCOUNT,key=10,ID=BANK_ACCOUNT(10)]\\tPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxEdge[provider=BANK_TRANSACTION,key=1040,ID=BANK_TRANSACTION(1040)]\\nPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxVertex[provider=BANK_ACCOUNT,key=50,ID=BANK_ACCOUNT(50)]\\tPgxEdge[provider=BANK_TRANSACTION,key=6212,ID=BANK_TRANSACTION(6212)]\\nPgxVertex[provider=BANK_ACCOUNT,key=70,ID=BANK_ACCOUNT(70)]\\tPgxVertex[provider=BANK_ACCOUNT,key=62,ID=BANK_ACCOUNT(62)]\\tPgxEdge[provider=BANK_TRANSACTION,key=7000,ID=BANK_TRANSACTION(7000)]\"}",
"type" : "NETWORK"
}
]
},
"relations" : [ ],
"dynamicFormParams" : null
},
{
"row" : 0,
"col" : 0,
"sizeX" : 0,
"order" : 23,
"width" : 0,
"title" : null,
"hasTitle" : false,
"message" : [
"%md",
"",
"This visualization can be done in a single query below. The keyword **ONE ROW PER STEP** retrieves the steps in the paths and maps them to new variables **v1, e, v2**."
],
"selectedVisualization" : "html",
"visualizationConfig" : null,
"hideCode" : true,
"hideResult" : false,
"hideGutter" : true,
"hideVizConfig" : true,
"hideInIFrame" : false,
"forms" : "[]",
"result" : {
"startTime" : 1667186561009,
"endTime" : 1667186561059,
"interpreter" : "md",
"taskStatus" : "SUCCESS",
"status" : "SUCCESS",
"results" : [
{
"message" : "<p>This visualization can be done in a single query below. The keyword <strong>ONE ROW PER STEP</strong> retrieves the steps in the paths and maps them to new variables <strong>v1, e, v2</strong>.</p>\n",
"type" : "HTML"
}
]
},
"relations" : [ ],