|
|
Line 1: |
Line 1: |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | '''<span style="color: rgb(51, 51, 153); font-family: "verdana","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman"; mso-bidi-font-family: "times new roman";"> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | QAS_getByQuestionnaireResourceId</span>''' |
− | <b><span | + | |
− | style="font-size:10.0pt;font-family:"Verdana","sans-serif";mso-fareast-font-family:
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Get all answer sheets of a specific |
− | "Times New Roman";mso-bidi-font-family:"Times New Roman";color:#333399">
| + | Questionnaire by Questionnaire resource Id.</span> |
− | QAS_getByQuestionnaireResourceId</span></b></p>
| + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />''' |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Syntax</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | "Times New Roman";color:black">Get all answer sheets of a specific
| + | |
− | Questionnaire by Questionaire resource Id.</span></p>
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";"> |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | QAS_getByQuestionnaireResourceId(questionnaireResourceId)</span> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <b> | + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Arguments</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
| + | |
− | "Times New Roman";color:#800040"></span></b></p>
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">- questionnaireResourceId: is a number |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | expression, it is resource id of Questionnaire.</span> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <b>
| + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Return value</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
| + | |
− | "Times New Roman";color:#800040">Syntax</span></b><span style="font-size:10.0pt;
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">This function returns an |
− | font-family:"Tahoma","sans-serif";mso-fareast-font-family:"Times New Roman"; | + | '''array of answer sheet objects''' {{QAS_1},{QAS_2},{QAS_3},…...). If no answer |
− | color:black"></span></p>
| + | sheets exists then it will return an '''empty array'''.</span> |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">See ''' |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| + | QAS_new()''' to get more understanding of a QAS object and know how to get |
− | "Times New Roman";color:black">
| + | value of items of a QAS object.</span> |
− | QAS_getByQuestionnaireResourceId(questionnaireResourceId)</span></p> | + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />''' |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <b> | + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Example:</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: | + | |
− | "Times New Roman";color:#800040">Arguments</span></b><span style="font-size:
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">array All_QASs = |
− | 10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:"Times New Roman";
| + | QAS_getByQuestionnaireResourceId(37244945);</span> |
− | color:black"></span></p>
| + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(All_QASs); <span style="mso-spacerun: yes;"> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | </span></span> |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| + | |
− | "Times New Roman";color:black">- questionnaireResourceId: is a number
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";"><span style="mso-spacerun: yes;"> </span>// ---- Result: </span> |
− | expression, it is resource id of Questionnaire.</span></p> | + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:0in;
| + | '''<span style="font-family: "courier new"; font-size: 16pt;">{</span><span style="color: red; font-family: "courier new";">{</span>'''<span style="font-family: "courier new";">15,90267303,37244945,37244953,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},0b0f4d6f-97de-488c-80d6-5f843363f046,{1,1,1,0,0,0,0,1,40},1,0'''<span style="color: red;">}</span>''',<br> '''<span style="color: red;">{</span>'''15,90267304,37244945,37244954,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},ab9826c5-1556-418d-a00e-0a1b20ae41a2,{1,1,1,0,0,0,0,1,40},1,0'''<span style="color: red;">}</span>''',<br> '''<span style="color: red;">{</span>'''15,90267305,37244945,37244955,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},c50290a0-fd28-40a2-a112-2249cff6217d,{1,1,1,0,0,0,0,1,40},1,0'''<span style="color: red;">}</span>'''</span>'''<span style="font-family: "courier new"; font-size: 16pt;">}</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | margin-left:0in;margin-bottom:.0001pt;line-height:normal;vertical-align:baseline">
| + | |
− | <b>
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">array QAS_object = All_QASs[0];</span> |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family: | + | |
− | "Times New Roman";color:#800040">Return value</span></b><span style="font-size:
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_ID]);<span style="mso-spacerun: yes;"> |
− | 10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:"Times New Roman";
| + | </span>// --- Result:<span style="mso-spacerun: yes;"> |
− | color:black"></span></p>
| + | </span>90267303<span style="mso-spacerun: yes;"> </span></span> |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_USER_RESOURCE_ID]); |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| + | <span style="mso-spacerun: yes;"> </span>// --- Result:<span style="mso-spacerun: yes;"> </span>37244953</span> |
− | "Times New Roman";color:black">This function returns an
| + | |
− | <b style="mso-bidi-font-weight:
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_TEST]);<span style="mso-spacerun: yes;"> |
− | normal">array of answer sheet objects</b> {{QAS_1},{QAS_2},{QAS_3},…...). If no answer
| + | </span>// --- Result:<span style="mso-spacerun: yes;"> </span> False</span> |
− | sheets exists then it will return an <b style="mso-bidi-font-weight:
| + | |
− | normal">empty array</b>.</span></p>
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_STATUS]);<span style="mso-spacerun: yes;"> |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | </span>// --- Result:<span style="mso-spacerun: yes;"> </span>1</span> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_COMPLETED]);<span style="mso-spacerun: yes;"> </span>// --- Result:<span style="mso-spacerun: yes;"> </span>False</span> |
− | "Times New Roman";color:black">See <b style="mso-bidi-font-weight:normal">
| + | |
− | QAS_new()</b> to get more understanding of a QAS object and know how to get
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_STARTDATE]);<span style="mso-spacerun: yes;"> </span>// --- Result:<span style="mso-spacerun: yes;"> </span>{1,1,1,1,0,0,0,1,40}</span> |
− | value of items of a QAS object.</span></p>
| + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_ENDDATE]);<span style="mso-spacerun: yes;"> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | </span>// --- Result:<span style="mso-spacerun: yes;"> </span> {1,1,1,1,0,0,0,1,40}</span> |
− | <b>
| + | |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
| + | '''<span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Availability</span>'''<span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /> |
− | "Times New Roman";color:#800040"></span></b></p>
| + | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| + | <span style="color: black; font-family: "tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Version 5.8.1</span> |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| + | |
− | <b>
| |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:#800040">Example:</span></b><span style="font-size:
| |
− | 10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:"Times New Roman";
| |
− | color:black"></span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">array All_QASs = | |
− | QAS_getByQuestionnaireResourceId(37244945);</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(All_QASs); <span style="mso-spacerun:yes">
| |
− | </span></span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black"><span style="mso-spacerun:yes"> </span>// ----
| |
− | Result: </span>
| |
− | </p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <b style="mso-bidi-font-weight:normal">
| |
− | <span style="font-size:16.0pt;font-family: | |
− | "Courier New"">{</span><span | |
− | style="font-family:"Courier New";color:red">{</span></b><span style="font-family:
| |
− | "Courier New"">15,90267303,37244945,37244953,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},0b0f4d6f-97de-488c-80d6-5f843363f046,{1,1,1,0,0,0,0,1,40},1,0<b
| |
− | style="mso-bidi-font-weight:normal"><span style="color:red">}</span></b>,<br />
| |
− | <b style="mso-bidi-font-weight:normal"><span style="color:red">{</span></b>15,90267304,37244945,37244954,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},ab9826c5-1556-418d-a00e-0a1b20ae41a2,{1,1,1,0,0,0,0,1,40},1,0<b
| |
− | style="mso-bidi-font-weight:normal"><span style="color:red">}</span></b>,<br />
| |
− | <b style="mso-bidi-font-weight:normal"><span style="color:red">{</span></b>15,90267305,37244945,37244955,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},c50290a0-fd28-40a2-a112-2249cff6217d,{1,1,1,0,0,0,0,1,40},1,0<b
| |
− | style="mso-bidi-font-weight:normal"><span style="color:red">}</span></b></span><b
| |
− | style="mso-bidi-font-weight:normal"><span style="font-size:16.0pt;font-family:
| |
− | "Courier New"">}</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"; | |
− | mso-fareast-font-family:"Times New Roman";color:black"></span></p> | |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">array QAS_object = All_QASs[0];</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_ID]);<span
| |
− | style="mso-spacerun:yes">
| |
− | </span>// --- Result:<span style="mso-spacerun:yes">
| |
− | </span>90267303<span style="mso-spacerun:yes"> </span></span>
| |
− | </p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_USER_RESOURCE_ID]);
| |
− | <span style="mso-spacerun:yes"> </span>// --- Result:<span
| |
− | style="mso-spacerun:yes"> </span>37244953</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_TEST]);<span
| |
− | style="mso-spacerun:yes">
| |
− | </span>// --- Result:<span style="mso-spacerun:yes"> </span>
| |
− | False</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_STATUS]);<span
| |
− | style="mso-spacerun:yes">
| |
− | </span>// --- Result:<span style="mso-spacerun:yes"> </span>1</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_COMPLETED]);<span
| |
− | style="mso-spacerun:yes"> </span>//
| |
− | --- Result:<span style="mso-spacerun:yes"> </span>False</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_STARTDATE]);<span
| |
− | style="mso-spacerun:yes"> </span>//
| |
− | --- Result:<span style="mso-spacerun:yes"> </span>{1,1,1,1,0,0,0,1,40}</span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">print(QAS_object[QAS_ENDDATE]);<span
| |
− | style="mso-spacerun:yes">
| |
− | </span>// --- Result:<span style="mso-spacerun:yes"> </span>
| |
− | {1,1,1,1,0,0,0,1,40}<b> </b></span>
| |
− | </p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <b>
| |
− | <span style="font-size:10.0pt;font-family:"Arial","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:#800040">Availability</span></b><span style="font-size:
| |
− | 10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:"Times New Roman";
| |
− | color:black"></span></p>
| |
− | <p style="margin-top:6.0pt;margin-right:0in;margin-bottom:6.0pt;
| |
− | margin-left:0in;line-height:normal;vertical-align:baseline">
| |
− | <span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
| |
− | "Times New Roman";color:black">Version 5.8.1</span></p>
| |
| [[Category:Questionnaire_Functions]] | | [[Category:Questionnaire_Functions]] |
QAS_getByQuestionnaireResourceId
Get all answer sheets of a specific
Questionnaire by Questionnaire resource Id.
Syntax
QAS_getByQuestionnaireResourceId(questionnaireResourceId)
Arguments
- questionnaireResourceId: is a number
expression, it is resource id of Questionnaire.
Return value
This function returns an
array of answer sheet objects {{QAS_1},{QAS_2},{QAS_3},…...). If no answer
sheets exists then it will return an empty array.
See
QAS_new() to get more understanding of a QAS object and know how to get
value of items of a QAS object.
Example:
array All_QASs =
QAS_getByQuestionnaireResourceId(37244945);
print(All_QASs);
// ---- Result:
{{15,90267303,37244945,37244953,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},0b0f4d6f-97de-488c-80d6-5f843363f046,{1,1,1,0,0,0,0,1,40},1,0},
{15,90267304,37244945,37244954,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},ab9826c5-1556-418d-a00e-0a1b20ae41a2,{1,1,1,0,0,0,0,1,40},1,0},
{15,90267305,37244945,37244955,False,1,False,{1,1,1,1,0,0,0,1,40},{1,1,1,1,0,0,0,1,40},c50290a0-fd28-40a2-a112-2249cff6217d,{1,1,1,0,0,0,0,1,40},1,0}}
array QAS_object = All_QASs[0];
print(QAS_object[QAS_ID]);
// --- Result:
90267303
print(QAS_object[QAS_USER_RESOURCE_ID]);
// --- Result: 37244953
print(QAS_object[QAS_TEST]);
// --- Result: False
print(QAS_object[QAS_STATUS]);
// --- Result: 1
print(QAS_object[QAS_COMPLETED]); // --- Result: False
print(QAS_object[QAS_STARTDATE]); // --- Result: {1,1,1,1,0,0,0,1,40}
print(QAS_object[QAS_ENDDATE]);
// --- Result: {1,1,1,1,0,0,0,1,40}
Availability
Version 5.8.1