QAS getByQuestionnaireResourceId: Difference between revisions

Revision as of 07:22, 21 July 2011

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

Questionnaire_Functions

@@ Line 1: / Line 1: @@
-'''<span style="color: rgb(51, 51, 153); font-family: &quot;verdana","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman"; mso-bidi-font-family: "times new roman";">QAS_getByQuestionnaireResourceId</span>'''
+'''QAS_getByQuestionnaireResourceId<br>'''Get all answer sheets of a specific Questionnaire by Questionnaire resource Id.
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Get all answer sheets of a specific
+<br> '''Syntax<br>'''QAS_getByQuestionnaireResourceId(questionnaireResourceId) <br>'''Arguments<br>'''- questionnaireResourceId: is a number expression, it is resource id of Questionnaire. <br>'''Return value<br>'''This function returns <u>'''an array of answer sheet objects'''</u> {{QAS_1},{QAS_2},{QAS_3},…...). If no answer sheets exists then it will return an <u>'''empty array'''</u>.<br>See <u>'''QAS_new()'''</u>to get more understanding of a QAS object and know how to get value of items of a QAS object.
-        Questionnaire by Questionnaire resource Id.</span>
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />'''
+<br> '''Example:<br>'''array All_QASs = QAS_getByQuestionnaireResourceId(37244945);<br>print(All_QASs);&nbsp;&nbsp; <br>&nbsp;// ---- Result: <br>&nbsp;&nbsp; {{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},<br>&nbsp;&nbsp;&nbsp; {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},<br>&nbsp;&nbsp;&nbsp; {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: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Syntax</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
+array QAS_object = All_QASs[0];<br>print(QAS_object[QAS_ID]);&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // --- Result:&nbsp; 90267303&nbsp; <br>print(QAS_object[QAS_USER_RESOURCE_ID]); &nbsp;&nbsp;// --- Result:&nbsp; 37244953<br>print(QAS_object[QAS_TEST]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;// --- Result:&nbsp; False<br>print(QAS_object[QAS_STATUS]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;// --- Result:&nbsp; 1<br>print(QAS_object[QAS_COMPLETED]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// --- Result:&nbsp; False<br>print(QAS_object[QAS_STARTDATE]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;// --- Result:&nbsp; {1,1,1,1,0,0,0,1,40}<br>print(QAS_object[QAS_ENDDATE]);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;// --- Result:&nbsp; {1,1,1,1,0,0,0,1,40}
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">
+'''Availability<br>'''Version 5.8.1
-        QAS_getByQuestionnaireResourceId(questionnaireResourceId)</span>
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Arguments</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
+<br>Questionnaire_Functions
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">- questionnaireResourceId: is a number
-        expression, it is resource id of Questionnaire.</span>
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Return value</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">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'''.</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">See '''
-        QAS_new()''' to get more understanding of a QAS object and know how to get
-        value of items of a QAS object.</span>
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />'''
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Example:</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">array All_QASs =
-        QAS_getByQuestionnaireResourceId(37244945);</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(All_QASs);<span style="mso-spacerun: yes;">&nbsp;&nbsp;
-        </span></span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";"><span style="mso-spacerun: yes;">&nbsp;</span>// ---- Result: </span>
-'''<span style="font-family: &quot;courier new"; font-size: 16pt;">{</span><span style="color: red; font-family: &quot;courier new";">{</span>'''<span style="font-family: &quot;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: &quot;courier new"; font-size: 16pt;">}</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">array QAS_object = All_QASs[0];</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_ID]);<span style="mso-spacerun: yes;">&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>90267303<span style="mso-spacerun: yes;">&nbsp; </span></span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_USER_RESOURCE_ID]);
-        <span style="mso-spacerun: yes;">&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>37244953</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_TEST]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span> False</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_STATUS]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>1</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_COMPLETED]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>False</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_STARTDATE]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>{1,1,1,1,0,0,0,1,40}</span>
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">print(QAS_object[QAS_ENDDATE]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-        &nbsp;&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span> {1,1,1,1,0,0,0,1,40}</span>
-'''<span style="color: rgb(128, 0, 64); font-family: &quot;arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Availability</span>'''<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" />
-<span style="color: black; font-family: &quot;tahoma","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";">Version 5.8.1</span>
-[[Category:Questionnaire_Functions]]