-
Notifications
You must be signed in to change notification settings - Fork 9
Expand file tree
/
Copy pathgetDataVisitTest.html
More file actions
263 lines (241 loc) · 8.29 KB
/
Copy pathgetDataVisitTest.html
File metadata and controls
263 lines (241 loc) · 8.29 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
<div id="getData-config-form-div"></div>
<br/>
<div id="getData-grid-div"></div>
<!-- Used as HTML wiki source, so nonce is NOT required -->
<script type="text/javascript">
var cd4Measure = {
"measure":{
"name":"CD4",
"queryName":"Lab Results",
"schemaName":"study"
},
"dimension":null,
"time": "visit"
};
var hemoglobinMeasure = {
"measure":{
"name":"Hemoglobin",
"queryName":"Lab Results",
"schemaName":"study"
},
"dimension":null,
"time": "visit"
};
var weightMeasure = {
"measure":{
"name":"Weight_kg",
"queryName":"Physical Exam",
"schemaName":"study"
},
"dimension":null,
"time": "visit"
};
var vlMeasure = {
"measure":{
"name":"HIVLoadQuant",
"queryName":"HIV Test Results",
"schemaName":"study"
},
"dimension":null,
"time": "visit"
};
var luminexMeasureNonNull = {
"measure":{
"name":"ObsConc",
"queryName":"LuminexAssay",
"schemaName":"study",
"allowNullResults": false
},
"dimension":null,
"time": "visit"
};
var luminexMeasureNullAllowed = {
"measure":{
"name":"ObsConc",
"queryName":"LuminexAssay",
"schemaName":"study",
"allowNullResults": true
},
"dimension":null,
"time": "visit"
};
var luminexMeasureNonNullWithDimension = {
"measure":{
"name":"ObsConc",
"queryName":"LuminexAssay",
"schemaName":"study",
"allowNullResults": false
},
"dimension":{
"name":"AnalyteName",
"queryName":"LuminexAssay",
"schemaName":"study",
"values":["IL-10 (23)", "IL-2 (3)", "TNF-alpha (40)"]
},
"time": "visit"
};
var luminexMeasureNullAllowedWithDimension = {
"measure":{
"name":"ObsConc",
"queryName":"LuminexAssay",
"schemaName":"study",
"allowNullResults": true
},
"dimension":{
"name":"AnalyteName",
"queryName":"LuminexAssay",
"schemaName":"study",
"values":["IL-10 (23)", "IL-2 (3)", "TNF-alpha (40)"]
},
"time": "visit"
};
var luminexMeasureNullAllowedWithDimension2 = {
"measure":{
"name":"FI",
"queryName":"LuminexAssay",
"schemaName":"study",
"allowNullResults": true
},
"dimension":{
"name":"AnalyteName",
"queryName":"LuminexAssay",
"schemaName":"study",
"values":["IL-10 (23)", "IL-2 (3)", "TNF-alpha (40)"]
},
"time": "visit"
};
var firstM1Measure = {
"time": "visit",
"measure":{
"name":"M1",
"queryName":"GenericAssay",
"schemaName":"study"
},
"dimension":null
};
var secondM1Measure = {
"time": "visit",
"measure":{
"name":"M1",
"queryName":"FileBasedAssay",
"schemaName":"study"
},
"dimension":null
};
var sortArray = [
{
"name":"ParticipantId",
"schemaName":"study",
"queryName":"Lab Results",
"values":["249318596","249320107","249320127","249320489","249320897"]
},
{
"name":"ParticipantVisit/sequencenum",
"queryName":"Lab Results",
"schemaName":"study"
}
];
var configs = [
{title: 'Single Measure', measures: [cd4Measure]},
{title: 'Two Measures from the same dataset', measures: [cd4Measure, hemoglobinMeasure]},
{title: 'Two Measures from different datasets', measures: [cd4Measure, weightMeasure]},
{title: 'Two Measures from different datasets (#2)', measures: [cd4Measure, vlMeasure]},
{title: 'Two Measures - without dimension selected for second, inner join', measures: [cd4Measure, luminexMeasureNonNull]},
{title: 'Two Measures - without dimension selected for second, outer join', measures: [cd4Measure, luminexMeasureNullAllowed]},
{title: 'Two Measures - WITH dimension selected for second, inner join', measures: [cd4Measure, luminexMeasureNonNullWithDimension]},
{title: 'Two Measures - WITH dimension selected for second, outer join', measures: [cd4Measure, luminexMeasureNullAllowedWithDimension]},
{title: 'Three Measures - two with the same name', measures: [cd4Measure, firstM1Measure, secondM1Measure]}, // issue 15369
{title: 'Three Measures - two with the same dimension pivot', measures: [cd4Measure, luminexMeasureNullAllowedWithDimension, luminexMeasureNullAllowedWithDimension2]} // issue 12369
];
var measureNames = [
"study_Lab Results_CD4",
"study_Lab Results_Hemoglobin",
"study_Physical Exam_Weight_kg",
"study_HIV Test Results_HIVLoadQuant",
"study_LuminexAssay_ObsConc",
"study_LuminexAssay_ObsConc",
"IL-10 (23)::study_LuminexAssay_ObsConc_MAX",
"IL-10 (23)::study_LuminexAssay_ObsConc_MAX",
"study_GenericAssay_M1",
"IL-10 (23)::study_LuminexAssay_ObsConc_MAX"
];
var configCounter = -1;
var configForm;
function init(){
configForm = new Ext.FormPanel({
renderTo: 'getData-config-form-div',
frame: false,
items: [{
xtype: 'numberfield',
fieldLabel: 'Current Config ',
name: 'currentConfig',
value: 0,
allowBlank: false,
width: 30
},
{
xtype: 'numberfield',
fieldLabel: 'Total Number ',
name: 'configCount',
value: 0,
allowBlank: false,
width: 30
},
{
xtype: 'displayfield',
fieldLabel: 'Config Title ',
name: 'configTitle',
width: 500
}],
buttons: [{
xtype: 'button',
name: 'nextBtn',
text: 'Next',
handler: changeGrid
}],
buttonAlign: 'left'
});
changeGrid();
}
function changeGrid(){
// increment the config counter
configCounter++;
configForm.getForm().findField('currentConfig').setValue(configCounter);
// check that config exists for current value of counter
if(configCounter >= configs.length){
alert("Config does not exist: " + configCounter);
return;
}
// set the values in the form
configForm.getForm().findField('configCount').setValue(configs.length);
// call the getData API with the new config measures
LABKEY.Query.Visualization.getData({
success: function(data){
// show the results in a query webpart using the temp queryName provided in the result
new LABKEY.QueryWebPart({
renderTo: 'getData-grid-div',
schemaName: data.schemaName,
queryName: data.queryName,
dataRegionName: 'apiTestDataRegion',
sort: 'study_Lab Results_ParticipantId,study_Lab Results_ParticipantVisit_sequencenum,'+measureNames[configCounter],
allowChooseQuery: false,
allowChooseView: false,
title: "",
frame: "none",
success: function() {
configForm.getForm().findField('configTitle').setValue(configs[configCounter].title);
}
});
},
failure : function(info, response, options) {LABKEY.Utils.displayAjaxErrorResponse(response, options);},
measures: configs[configCounter].measures,
sorts: sortArray,
scope: this
});
}
LABKEY.requiresExt3ClientAPI(function() {
LABKEY.requiresVisualization(function() {
Ext.onReady(init);
});
});
</script>