forked from antonycourtney/tad
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathtest.out
More file actions
1038 lines (953 loc) · 86.1 KB
/
test.out
File metadata and controls
1038 lines (953 loc) · 86.1 KB
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
> tad@0.8.5 unit-test /Users/antony/home/src/tad
> ELECTRON_RUN_AS_NODE=true && electron build/allTests.bundle.js
basic PathTree
pt1: { '"foo"': { '"bar"': { '"baz"': {} } } }
pt2: { '"foo"': { '"bar"': { '"baz"': {}, '"blech"': {} } },
'"a"': { '"b"': { '"c"': {} } } }
[ 'foo' ]
[ 'foo', 'bar' ]
[ 'foo', 'bar', 'baz' ]
[ 'foo', 'bar', 'blech' ]
[ 'a' ]
[ 'a', 'b' ]
[ 'a', 'b', 'c' ]
pt2Paths: [ [ 'foo' ],
[ 'foo', 'bar' ],
[ 'foo', 'bar', 'baz' ],
[ 'foo', 'bar', 'blech' ],
[ 'a' ],
[ 'a', 'b' ],
[ 'a', 'b', 'c' ] ]
✓ full path set from iterator (comparing to saved snapshot)
pt3Paths: [ [ 'foo' ],
[ 'foo', 'bar' ],
[ 'foo', 'bar', 'blech' ],
[ 'a' ],
[ 'a', 'b' ],
[ 'a', 'b', 'c' ] ]
✓ path set after closing one path (comparing to saved snapshot)
pt4Paths: [ [ 'foo' ],
[ 'foo', 'bar' ],
[ 'a' ],
[ 'a', 'b' ],
[ 'a', 'b', 'c' ] ]
✓ path set after closing two paths with common prefix (comparing to saved snapshot)
pt5Paths: [ [ 'foo' ], [ 'foo', 'bar' ], [ 'a' ], [ 'a', 'b' ] ]
✓ basic isOpen check
✓ negative isOpen check
sqlite test setup
[17:22:43.670] [info] starting metascan...
[17:22:43.672] [info] file size: 2074
[17:22:43.685] [info] countStream: bytesRead: 2074
[17:22:43.687] [info] metascan completed in 0s 14.553074ms
[17:22:43.687] [info] metascan complete. metadata: { columnIds: [ 'Name', 'Title', 'Base', 'TCOE', 'JobFamily', 'Union' ],
columnNames: [ 'Name', 'Title', 'Base', 'TCOE', 'Job Family', 'Union' ],
columnTypes: [ 'text', 'text', 'integer', 'integer', 'text', 'text' ],
rowCount: 23,
tableName: 'barttest',
csvOptions: { delimiter: ',', objectMode: true } }
[17:22:43.690] [info] table created
[17:22:43.700] [info] consumeStream completed, rowCount: 23
set rtc: SqliteContext {
db:
Database {
driver: Database { open: true, filename: ':memory:', mode: 65542 },
Promise: [Function: Promise],
open: [Function] },
tableMap: { barttest: { tableName: 'barttest', schema: [Schema] } },
showQueries: false }
✓ setup and import complete
basic table query
dbTest0: test start: SqliteContext {
db:
Database {
driver: Database { open: true, filename: ':memory:', mode: 65542 },
Promise: [Function: Promise],
open: [Function] },
tableMap: { barttest: { tableName: 'barttest', schema: [Schema] } },
showQueries: false }
✓ basic table read
✓ getSchema column ids
✓ getSchema column types
✓ q1 rowData.length
✓ first row matches expected
TCOE sum: 4691559
basic row count
dbTestRowCount0: test start: SqliteContext {
db:
Database {
driver: Database { open: true, filename: ':memory:', mode: 65542 },
Promise: [Function: Promise],
open: [Function] },
tableMap: { barttest: { tableName: 'barttest', schema: [Schema] } },
showQueries: false }
[17:22:43.717] [info] time to run query: 0s 4.959615ms
✓ got row count!
rowCount: 23
✓ row count matches expected
basic project operator
✓ project query returned success
✓ result schema from project
✓ project result row 0
basic groupBy
✓ groupBy query schema
✓ correct number of grouped rows
✓ grouped TCOE sum matches raw sum
groupBy aggs
group by job family:
item
---------
JobFamily
Title
Union
Name
Base
TCOE
JobFamily Title Union Name Base TCOE
--------------------------------- ----------------------------------- --------------- ---------------- ------- -------
Engineering & Systems Engineering null Non-Represented null 309734 422244
Executive Management null Non-Represented null 1030722 1389290
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139
Legal & Paralegal null Non-Represented null 564028 766571
Maintenance, Vehicle & Facilities null SEIU null 366223 594761
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941
Transportation Operations null null null 413909 709998
✓ should be equivalent
✓ number of grouped rows in q4 result
✓ tcoe sum after groupBy
basic filter
✓ expected row count after filter
item
---------
Name
Title
Base
TCOE
JobFamily
Union
Name Title Base TCOE JobFamily Union
---------------- ------------------------------------ ------ ------ -------------------- ---------------
Crunican, Grace General Manager 312461 399921 Executive Management Non-Represented
Dugger, Dorothy General Manager 298700 419661 Executive Management Non-Represented
Oversier, Paul Assistant General Manager Operations 212647 288160 Executive Management Non-Represented
DeVaughn, Marcia Deputy General Manager 206914 281548 Executive Management Non-Represented
escaped literal string filter
✓ expected row count after filter
item
---------
Name
Title
Base
TCOE
JobFamily
Union
Name Title Base TCOE JobFamily Union
------------- ----------------------------------- ------ ------ -------------------------- ---------------
Hamill, Kerry Department Manager Gov't & Comm Rel 130035 181955 Public Affairs & Marketing Non-Represented
query deserialization
serialized query
{
"query": {
"expType": "QueryExp",
"operator": "filter",
"valArgs": [
{
"expType": "FilterExp",
"op": "AND",
"opArgs": [
{
"expType": "BinRelExp",
"op": "EQ",
"lhs": {
"expType": "ColRef",
"colName": "JobFamily"
},
"rhs": {
"expType": "ConstVal",
"val": "Executive Management"
}
}
]
}
],
"tableArgs": [
{
"expType": "QueryExp",
"operator": "table",
"valArgs": [
"barttest"
],
"tableArgs": []
}
]
}
}
deserialized query: { query:
QueryExp {
expType: 'QueryExp',
operator: 'filter',
valArgs: [ [FilterExp] ],
tableArgs: [ [QueryExp] ] } }
got results of evaluating deserialized query
item
---------
Name
Title
Base
TCOE
JobFamily
Union
Name Title Base TCOE JobFamily Union
---------------- ------------------------------------ ------ ------ -------------------- ---------------
Crunican, Grace General Manager 312461 399921 Executive Management Non-Represented
Dugger, Dorothy General Manager 298700 419661 Executive Management Non-Represented
Oversier, Paul Assistant General Manager Operations 212647 288160 Executive Management Non-Represented
DeVaughn, Marcia Deputy General Manager 206914 281548 Executive Management Non-Represented
✓ expected row count after filter
mapColumns
✓ EmpName
✓ EmpName metadata
✓ expected row count after mapColumns
mapColumnsByIndex
✓ EmpName
✓ expected row count after mapColumnsByIndex
concat
✓ expected row count after filter and concat
✓ filter and concat column vals
basic sort
item
---------
Name
Title
Base
TCOE
JobFamily
Union
Name Title Base TCOE JobFamily Union
---------------- ------------------------------------ ------ ------ -------------------- ---------------
Crunican, Grace General Manager 312461 399921 Executive Management Non-Represented
DeVaughn, Marcia Deputy General Manager 206914 281548 Executive Management Non-Represented
Dugger, Dorothy General Manager 298700 419661 Executive Management Non-Represented
Hardy, Leonard Chief Safety Officer 152125 211941 Safety Non-Represented
Oversier, Paul Assistant General Manager Operations 212647 288160 Executive Management Non-Represented
compound key sort
item
---------
Name
Title
Base
TCOE
JobFamily
Union
Name Title Base TCOE JobFamily Union
---------------- ------------------------------------ ------ ------ -------------------- ---------------
Dugger, Dorothy General Manager 298700 419661 Executive Management Non-Represented
Crunican, Grace General Manager 312461 399921 Executive Management Non-Represented
Oversier, Paul Assistant General Manager Operations 212647 288160 Executive Management Non-Represented
DeVaughn, Marcia Deputy General Manager 206914 281548 Executive Management Non-Represented
Hardy, Leonard Chief Safety Officer 152125 211941 Safety Non-Represented
extend with expression
item
---------
Name
Title
Base
TCOE
JobFamily
Union
ExtraComp
Name Title Base TCOE JobFamily Union ExtraComp
---------------- ------------------------------------ ------ ------ -------------------- --------------- ---------
Crunican, Grace General Manager 312461 399921 Executive Management Non-Represented 87460
Dugger, Dorothy General Manager 298700 419661 Executive Management Non-Represented 120961
Oversier, Paul Assistant General Manager Operations 212647 288160 Executive Management Non-Represented 75513
DeVaughn, Marcia Deputy General Manager 206914 281548 Executive Management Non-Represented 74634
Hardy, Leonard Chief Safety Officer 152125 211941 Safety Non-Represented 59816
initial aggTree test
got schema: Schema {
columns:
[ 'JobFamily', 'Title', 'Union', 'Name', 'Base', 'TCOE', 'Rec' ],
columnMetadata:
{ Rec: { type: 'integer' },
JobFamily: { displayName: 'Job Family', type: 'text' },
Title: { displayName: 'Title', type: 'text' },
Union: { displayName: 'Union', type: 'text' },
Name: { displayName: 'Name', type: 'text' },
Base: { displayName: 'Base', type: 'integer' },
TCOE: { displayName: 'TCOE', type: 'integer' } },
_sortedColumns: null,
columnIndices:
{ JobFamily: 0,
Title: 1,
Union: 2,
Name: 3,
Base: 4,
TCOE: 5,
Rec: 6 } }
vpivot initial promise resolved...
root query exp: QueryExp {
expType: 'QueryExp',
operator: 'project',
valArgs:
[ [ 'JobFamily',
'Title',
'Union',
'Name',
'Base',
'TCOE',
'Rec',
'_depth',
'_pivot',
'_isRoot' ] ],
tableArgs:
[ QueryExp {
expType: 'QueryExp',
operator: 'extend',
valArgs: [Array],
tableArgs: [Array] } ] }
root query:
item
---------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot
--------- ----- ----- ---- ------- ------- --- ------ ------ -------
null null null null 3251221 4691559 23 0 null 1
open root query:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
--------------------------------- ----------------------------------- --------------- ---------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------- --------------------------------- ------
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null
✓ Q1 schema columns
✓ Q1 rowData length
✓ Q1 rowData sum(TCOE)
after opening path "Executive Management":
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
-------------------- ------------------------------------ --------------- ---------------- ------ ------ --- ------ ------------------------------------ ------- ---------- ---------- ---------- -------------------- ------------------------------------
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager
after opening path /Executive Management/General Manager:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
-------------------- --------------- --------------- --------------- ------ ------ --- ------ --------------- ------- ---------- ---------- ---------- -------------------- ---------------
Executive Management General Manager Non-Represented Crunican, Grace 312461 399921 1 3 Crunican, Grace 0 1 1 1 Executive Management General Manager
Executive Management General Manager Non-Represented Dugger, Dorothy 298700 419661 1 3 Dugger, Dorothy 0 1 1 1 Executive Management General Manager
evaluating query returned from getTreeQuery:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
--------------------------------- ------------------------------------ --------------- ---------------- ------- ------- --- ------ ------------------------------------ ------- ---------- ---------- ---------- --------------------------------- ------------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null
sorted aggTree test
vpivot initial promise resolved...
sort query depth 1:
item
------------
_path0
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
_path0 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2
--------------------------------- ------------ ------------ -----------------------------------
Engineering & Systems Engineering 422244 309734 null
Executive Management 1389290 1030722 null
Finance & Accounting 287139 208744 Controller-Treasurer
Legal & Paralegal 766571 564028 null
Maintenance, Vehicle & Facilities 594761 366223 null
Police 127660 75701 Revenue Protection Guard
Public Affairs & Marketing 181955 130035 Department Manager Gov't & Comm Rel
Safety 211941 152125 Chief Safety Officer
Transportation Operations 709998 413909 null
sort query depth 2:
item
------------
_path0
_path1
_sortVal_1_0
_sortVal_1_1
_sortVal_1_2
_path0 _path1 _sortVal_1_0 _sortVal_1_1 _sortVal_1_2
--------------------------------- ------------------------------------ ------------ ------------ ------------------------------------
Engineering & Systems Engineering Group Manager Systems Capital Prog 212535 152434 Group Manager Systems Capital Prog
Engineering & Systems Engineering Group Manager, Capital Projects 209709 157300 Group Manager, Capital Projects
Executive Management Assistant General Manager Operations 288160 212647 Assistant General Manager Operations
Executive Management Deputy General Manager 281548 206914 Deputy General Manager
Executive Management General Manager 819582 611161 General Manager
Finance & Accounting Controller-Treasurer 287139 208744 Controller-Treasurer
Legal & Paralegal General Counsel 321543 238269 General Counsel
Legal & Paralegal Senior Attorney 445028 325759 Senior Attorney
Maintenance, Vehicle & Facilities Electrician 113775 59817 Electrician
Maintenance, Vehicle & Facilities Structures Inspector 124962 77446 Structures Inspector
Maintenance, Vehicle & Facilities Transit Vehicle Mechanic 104260 74068 Transit Vehicle Mechanic
Maintenance, Vehicle & Facilities Vehicle Inspector 123432 77446 Vehicle Inspector
Maintenance, Vehicle & Facilities Wayside Inspector 128332 77446 Wayside Inspector
Police Revenue Protection Guard 127660 75701 Revenue Protection Guard
Public Affairs & Marketing Department Manager Gov't & Comm Rel 181955 130035 Department Manager Gov't & Comm Rel
Safety Chief Safety Officer 211941 152125 Chief Safety Officer
Transportation Operations Chief Transportation Officer 238211 170383 Chief Transportation Officer
Transportation Operations Station Agent 352988 182342 Station Agent
Transportation Operations Train Operator 118799 61184 Train Operator
got depth 1 query and sortQuery, joining...:
result of join query:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2
--------------------------------- ----------------------------------- --------------- ---------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------- --------------------------------- ------ ------------ ------------ -----------------------------------
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null 422244 309734 null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null 1389290 1030722 null
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null 287139 208744 Controller-Treasurer
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null 766571 564028 null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null 594761 366223 null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null 127660 75701 Revenue Protection Guard
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null 181955 130035 Department Manager Gov't & Comm Rel
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null 211941 152125 Chief Safety Officer
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null 709998 413909 null
basic async test
tf: got result:
{ JobFamily: 'Executive Management',
Title: 'General Manager',
Union: 'Non-Represented',
Name: 'Crunican, Grace',
Base: 312461,
TCOE: 399921 } '\n...'
done logging table
✓ handle async result
asyncAggTreeSortTest
vpivot initial promise resolved...
sort query depth 1:
item
------------
_path0
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
_path0 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2
--------------------------------- ------------ ------------ -----------------------------------
Engineering & Systems Engineering 422244 309734 null
Executive Management 1389290 1030722 null
Finance & Accounting 287139 208744 Controller-Treasurer
Legal & Paralegal 766571 564028 null
Maintenance, Vehicle & Facilities 594761 366223 null
Police 127660 75701 Revenue Protection Guard
Public Affairs & Marketing 181955 130035 Department Manager Gov't & Comm Rel
Safety 211941 152125 Chief Safety Officer
Transportation Operations 709998 413909 null
sort query depth 2:
item
------------
_path0
_path1
_sortVal_1_0
_sortVal_1_1
_sortVal_1_2
_path0 _path1 _sortVal_1_0 _sortVal_1_1 _sortVal_1_2
--------------------------------- ------------------------------------ ------------ ------------ ------------------------------------
Engineering & Systems Engineering Group Manager Systems Capital Prog 212535 152434 Group Manager Systems Capital Prog
Engineering & Systems Engineering Group Manager, Capital Projects 209709 157300 Group Manager, Capital Projects
Executive Management Assistant General Manager Operations 288160 212647 Assistant General Manager Operations
Executive Management Deputy General Manager 281548 206914 Deputy General Manager
Executive Management General Manager 819582 611161 General Manager
Finance & Accounting Controller-Treasurer 287139 208744 Controller-Treasurer
Legal & Paralegal General Counsel 321543 238269 General Counsel
Legal & Paralegal Senior Attorney 445028 325759 Senior Attorney
Maintenance, Vehicle & Facilities Electrician 113775 59817 Electrician
Maintenance, Vehicle & Facilities Structures Inspector 124962 77446 Structures Inspector
Maintenance, Vehicle & Facilities Transit Vehicle Mechanic 104260 74068 Transit Vehicle Mechanic
Maintenance, Vehicle & Facilities Vehicle Inspector 123432 77446 Vehicle Inspector
Maintenance, Vehicle & Facilities Wayside Inspector 128332 77446 Wayside Inspector
Police Revenue Protection Guard 127660 75701 Revenue Protection Guard
Public Affairs & Marketing Department Manager Gov't & Comm Rel 181955 130035 Department Manager Gov't & Comm Rel
Safety Chief Safety Officer 211941 152125 Chief Safety Officer
Transportation Operations Chief Transportation Officer 238211 170383 Chief Transportation Officer
Transportation Operations Station Agent 352988 182342 Station Agent
Transportation Operations Train Operator 118799 61184 Train Operator
join result for depth 1:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2
--------------------------------- ----------------------------------- --------------- ---------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------- --------------------------------- ------ ------------ ------------ -----------------------------------
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null 422244 309734 null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null 1389290 1030722 null
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null 287139 208744 Controller-Treasurer
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null 766571 564028 null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null 594761 366223 null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null 127660 75701 Revenue Protection Guard
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null 181955 130035 Department Manager Gov't & Comm Rel
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null 211941 152125 Chief Safety Officer
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null 709998 413909 null
level 2 join result:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
_sortVal_1_0
_sortVal_1_1
_sortVal_1_2
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2 _sortVal_1_0 _sortVal_1_1 _sortVal_1_2
-------------------- ------------------------------------ --------------- ---------------- ------ ------ --- ------ ------------------------------------ ------- ---------- ---------- ---------- -------------------- ------------------------------------ ------------ ------------ ------------ ------------ ------------ ------------------------------------
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations 1389290 1030722 null 288160 212647 Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager 1389290 1030722 null 281548 206914 Deputy General Manager
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
tree query after opening paths:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
--------------------------------- ------------------------------------ --------------- ---------------- ------- ------- --- ------ ------------------------------------ ------- ---------- ---------- ---------- --------------------------------- ------------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager
Executive Management General Manager Non-Represented Crunican, Grace 312461 399921 1 3 Crunican, Grace 0 1 1 1 Executive Management General Manager
Executive Management General Manager Non-Represented Dugger, Dorothy 298700 419661 1 3 Dugger, Dorothy 0 1 1 1 Executive Management General Manager
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 2 Chief Safety Officer 0 1 1 0 Safety Chief Safety Officer
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null
tree query after sort joins:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
_sortVal_1_0
_sortVal_1_1
_sortVal_1_2
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2 _sortVal_1_0 _sortVal_1_1 _sortVal_1_2
--------------------------------- ------------------------------------ --------------- ---------------- ------- ------- --- ------ ------------------------------------ ------- ---------- ---------- ---------- --------------------------------- ------------------------------------ ------------ ------------ ----------------------------------- ------------ ------------ ------------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null null null null null null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null 422244 309734 null null null null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null 1389290 1030722 null null null null
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations 1389290 1030722 null 288160 212647 Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager 1389290 1030722 null 281548 206914 Deputy General Manager
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Executive Management General Manager Non-Represented Crunican, Grace 312461 399921 1 3 Crunican, Grace 0 1 1 1 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Executive Management General Manager Non-Represented Dugger, Dorothy 298700 419661 1 3 Dugger, Dorothy 0 1 1 1 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null 287139 208744 Controller-Treasurer null null null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null 766571 564028 null null null null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null 594761 366223 null null null null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null 127660 75701 Revenue Protection Guard null null null
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null 181955 130035 Department Manager Gov't & Comm Rel null null null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null 211941 152125 Chief Safety Officer null null null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 2 Chief Safety Officer 0 1 1 0 Safety Chief Safety Officer 211941 152125 Chief Safety Officer 211941 152125 Chief Safety Officer
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null 709998 413909 null null null null
result of sorted tree query:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_0_1
_sortVal_0_2
_sortVal_1_0
_sortVal_1_1
_sortVal_1_2
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_0_1 _sortVal_0_2 _sortVal_1_0 _sortVal_1_1 _sortVal_1_2
--------------------------------- ------------------------------------ --------------- ---------------- ------- ------- --- ------ ------------------------------------ ------- ---------- ---------- ---------- --------------------------------- ------------------------------------ ------------ ------------ ----------------------------------- ------------ ------------ ------------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null null null null null null null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null 1389290 1030722 null null null null
Executive Management General Manager Non-Represented null 611161 819582 2 2 General Manager 0 1 1 0 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Executive Management General Manager Non-Represented Dugger, Dorothy 298700 419661 1 3 Dugger, Dorothy 0 1 1 1 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Executive Management General Manager Non-Represented Crunican, Grace 312461 399921 1 3 Crunican, Grace 0 1 1 1 Executive Management General Manager 1389290 1030722 null 819582 611161 General Manager
Executive Management Assistant General Manager Operations Non-Represented Oversier, Paul 212647 288160 1 2 Assistant General Manager Operations 0 1 1 0 Executive Management Assistant General Manager Operations 1389290 1030722 null 288160 212647 Assistant General Manager Operations
Executive Management Deputy General Manager Non-Represented DeVaughn, Marcia 206914 281548 1 2 Deputy General Manager 0 1 1 0 Executive Management Deputy General Manager 1389290 1030722 null 281548 206914 Deputy General Manager
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null 766571 564028 null null null null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null 709998 413909 null null null null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null 594761 366223 null null null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null 422244 309734 null null null null
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null 287139 208744 Controller-Treasurer null null null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null 211941 152125 Chief Safety Officer null null null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 2 Chief Safety Officer 0 1 1 0 Safety Chief Safety Officer 211941 152125 Chief Safety Officer 211941 152125 Chief Safety Officer
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null 181955 130035 Department Manager Gov't & Comm Rel null null null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null 127660 75701 Revenue Protection Guard null null null
✓ finished getting sort tables
basicPivotSortTest
vpivot initial promise resolved...
result of sorted tree query:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_path0
_sortVal_0_0
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _path0 _sortVal_0_0
--------------------------------- ----------------------------------- --------------- ----------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- --------------------------------- -----------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 Engineering & Systems Engineering null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 Executive Management null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 Legal & Paralegal null
Legal & Paralegal General Counsel Non-Represented Burrows, Matthew 238269 321543 1 2 Burrows, Matthew 0 1 1 Legal & Paralegal null
Legal & Paralegal Senior Attorney Non-Represented Lee, Thomas 165470 224345 1 2 Lee, Thomas 0 1 1 Legal & Paralegal null
Legal & Paralegal Senior Attorney Non-Represented Nuetzel, Victoria 160289 220683 1 2 Nuetzel, Victoria 0 1 1 Legal & Paralegal null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 Maintenance, Vehicle & Facilities null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 Transportation Operations null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 Safety Chief Safety Officer
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 Finance & Accounting Controller-Treasurer
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 Public Affairs & Marketing Department Manager Gov't & Comm Rel
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 Police Revenue Protection Guard
✓ sorted tree query matches snapshot (comparing to saved snapshot)
descPivotSortTest
vpivot initial promise resolved...
baseRes:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_path0
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _path0
--------------------------------- ----------------------------------- --------------- ---------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------------------------------
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 Engineering & Systems Engineering
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 Executive Management
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 Finance & Accounting
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 Legal & Paralegal
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 Maintenance, Vehicle & Facilities
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 Police
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 Public Affairs & Marketing
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 Safety
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 Transportation Operations
result of sorted tree query:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_path0
_sortVal_0_0
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _path0 _sortVal_0_0
--------------------------------- ----------------------------------- --------------- ----------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- --------------------------------- -----------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 null null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 Police Revenue Protection Guard
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 Public Affairs & Marketing Department Manager Gov't & Comm Rel
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 Finance & Accounting Controller-Treasurer
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 Safety Chief Safety Officer
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 Engineering & Systems Engineering null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 Executive Management null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 Legal & Paralegal null
Legal & Paralegal Senior Attorney Non-Represented Lee, Thomas 165470 224345 1 2 Lee, Thomas 0 1 1 Legal & Paralegal null
Legal & Paralegal Senior Attorney Non-Represented Nuetzel, Victoria 160289 220683 1 2 Nuetzel, Victoria 0 1 1 Legal & Paralegal null
Legal & Paralegal General Counsel Non-Represented Burrows, Matthew 238269 321543 1 2 Burrows, Matthew 0 1 1 Legal & Paralegal null
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 Maintenance, Vehicle & Facilities null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 Transportation Operations null
✓ sorted tree query matches snapshot (comparing to saved snapshot)
multiPivotSingleSortTest
vpivot initial promise resolved...
result of sorted tree query:
item
------------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
_sortVal_0_0
_sortVal_1_0
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1 _sortVal_0_0 _sortVal_1_0
--------------------------------- ----------------------------------- --------------- ---------------- ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------- --------------------------------- --------------- ----------------------------------- ---------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null null null
Engineering & Systems Engineering null Non-Represented null 309734 422244 2 1 Engineering & Systems Engineering 0 1 0 0 Engineering & Systems Engineering null null null
Executive Management null Non-Represented null 1030722 1389290 4 1 Executive Management 0 1 0 0 Executive Management null null null
Legal & Paralegal null Non-Represented null 564028 766571 3 1 Legal & Paralegal 0 1 0 0 Legal & Paralegal null null null
Legal & Paralegal General Counsel Non-Represented Burrows, Matthew 238269 321543 1 2 General Counsel 0 1 1 0 Legal & Paralegal General Counsel null General Counsel
Legal & Paralegal Senior Attorney Non-Represented null 325759 445028 2 2 Senior Attorney 0 1 1 0 Legal & Paralegal Senior Attorney null Senior Attorney
Maintenance, Vehicle & Facilities null SEIU null 366223 594761 5 1 Maintenance, Vehicle & Facilities 0 1 0 0 Maintenance, Vehicle & Facilities null null null
Transportation Operations null null null 413909 709998 5 1 Transportation Operations 0 1 0 0 Transportation Operations null null null
Safety Chief Safety Officer Non-Represented Hardy, Leonard 152125 211941 1 1 Safety 0 1 0 0 Safety null Chief Safety Officer null
Finance & Accounting Controller-Treasurer Non-Represented Schroeder, Scott 208744 287139 1 1 Finance & Accounting 0 1 0 0 Finance & Accounting null Controller-Treasurer null
Public Affairs & Marketing Department Manager Gov't & Comm Rel Non-Represented Hamill, Kerry 130035 181955 1 1 Public Affairs & Marketing 0 1 0 0 Public Affairs & Marketing null Department Manager Gov't & Comm Rel null
Police Revenue Protection Guard BPOA Ornellas, Robert 75701 127660 1 1 Police 0 1 0 0 Police null Revenue Protection Guard null
✓ sorted tree query (comparing to saved snapshot)
intPivotTest
vpivot initial promise resolved...
result of numeric pivot:
item
----------
JobFamily
Title
Union
Name
Base
TCOE
Rec
_depth
_pivot
_isRoot
_sortVal_0
_sortVal_1
_sortVal_2
_path0
_path1
JobFamily Title Union Name Base TCOE Rec _depth _pivot _isRoot _sortVal_0 _sortVal_1 _sortVal_2 _path0 _path1
--------------------------------- ------------------------------------ --------------- ------------------ ------- ------- --- ------ --------------------------------- ------- ---------- ---------- ---------- ------ ---------------------------------
null null null null 3251221 4691559 23 0 null 1 0 0 0 null null
Maintenance, Vehicle & Facilities Electrician SEIU Knight, Joshua 59817 113775 1 1 59817 0 1 0 0 59817 null
Transportation Operations Station Agent ATU Riggs, Joshua 60771 115104 1 1 60771 0 1 0 0 60771 null
Transportation Operations Station Agent ATU Nagel, Kevin 60781 105854 1 1 60781 0 1 0 0 60781 null
Transportation Operations Station Agent ATU Serrianni, Cheryl 60790 132030 1 1 60790 0 1 0 0 60790 null
Transportation Operations Train Operator ATU Smith, Westley 61184 118799 1 1 61184 0 1 0 0 61184 null
Maintenance, Vehicle & Facilities Transit Vehicle Mechanic SEIU Smith, Daniel 74068 104260 1 1 74068 0 1 0 0 74068 null