Difference between revisions of "QAS getByQuestionnaireResourceId"

From Catglobe Wiki
Jump to: navigation, search
(Tag: visualeditor)
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
'''<span />'''  
+
{{HelpFiles}}
 +
'''QAS_getByQuestionnaireResourceId'''
  
        QAS_getByQuestionnaireResourceId&lt;o:p&gt;&lt;/o:p&gt;
+
Get all answer sheets of a specific Questionnaire by Questionnaire resource Id.
  
<span>Get all answer sheets of a specific
+
'''Syntax'''
</span>
 
  
        Questionnaire by Questionaire resource Id.
+
QAS_getByQuestionnaireResourceId(questionnaireResourceId)
 +
 +
'''Arguments'''
  
'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'''
+
questionnaireResourceId: is a number expression, it is resource id of Questionnaire.
  
'''<span>Syntax</span>'''  
+
'''Return value'''
  
<span>
+
<nowiki>Array of answer sheet objects(include Test QASs) {{QAS_1},{QAS_2},{QAS_3},…...)</nowiki>
</span>
 
  
        QAS_getByQuestionnaireResourceId(questionnaireResourceId)&lt;o:p&gt;&lt;/o:p&gt;
+
If no answer sheets exists then it will return an empty array.
  
<span>'''Arguments'''</span>
+
See [[QAS_new]] to get more understanding of a QAS object and know how to get value of items of a QAS object.
  
<span>- questionnaireResourceId: is a number
+
In later version, return value is array of [[QAS_class]]
</span>
 
  
        expression, it is resource id of Questionnaire.&lt;o:p&gt;&lt;/o:p&gt;
+
<br> '''Example:<br>'''
 +
<source lang="javascript">
 +
array All_QASs = QAS_getByQuestionnaireResourceId(37244945);
 +
print(All_QASs);
 +
/*old return: {
 +
{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}
 +
}*/
 +
//new return: {QAS, QAS, QAS}
  
'''<span>Return value</span>'''
+
//old way to get items value of QAS object
 +
array QAS_object = All_QASs[0];
 +
print(QAS_object[QAS_ID]);//90267303
 +
print(QAS_object[QAS_USER_RESOURCE_ID]);//37244953
 +
print(QAS_object[QAS_TEST]);//False
 +
print(QAS_object[QAS_STATUS]);//1
 +
print(QAS_object[QAS_COMPLETED]);//False
 +
print(QAS_object[QAS_STARTDATE]);//{1,1,1,1,0,0,0,1,40}
 +
print(QAS_object[QAS_ENDDATE]);//Result:  {1,1,1,1,0,0,0,1,40}
  
<span>This function returns an
+
//new way to get items value of QAS class
</span>
+
QAS qas = All_QASs[0];
 +
print(qas.Id);//90267303
 +
print(qas.UserResourceId);//37244953
 +
print(qas.Test);//False
 +
print(qas.Status);//1
 +
print(qas.Completed);//False
 +
print(qas.StartDate);//{1,1,1,1,0,0,0,1,40}
 +
print(qas.EndDate);//Result:  {1,1,1,1,0,0,0,1,40}
 +
</source>
 +
'''Availability<br>'''Version 5.8.1
  
        '''array of answer sheet objects''' {{QAS_1},{QAS_2},{QAS_3},…...). If no answer
+
[[Category:Questionnaire_Functions]]
      sheets exists then it will return an '''empty array'''.&lt;o:p&gt;&lt;/o:p&gt;
 
 
 
<span>See
 
</span>
 
 
 
        QAS_new()''' to get more understanding of a QAS object and know how to get '''
 
      value of items of a QAS object.&lt;o:p&gt;&lt;/o:p&gt;
 
 
 
'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'''
 
 
 
'''<span>Example:</span>'''
 
 
 
<span>array All_QASs =
 
</span>
 
 
 
        QAS_getByQuestionnaireResourceId(37244945);
 
 
 
<span>print(All_QASs); <span style="mso-spacerun: yes;">
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span>
 
 
 
<span><span style="mso-spacerun: yes;">&nbsp;</span>// ---- Result:</span>
 
 
 
'''<span>{</span><span>{</span>'''<span>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>}</span>'''
 
 
 
<span>array QAS_object = All_QASs[0];</span>
 
 
 
<span>print(QAS_object[QAS_ID]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span>
 
 
 
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// --- Result:<span style="mso-spacerun: yes;">&nbsp;
 
      </span>90267303
 
 
 
<span>print(QAS_object[QAS_USER_RESOURCE_ID]);
 
</span>
 
 
 
        <span style="mso-spacerun: yes;">&nbsp;&nbsp;</span>// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>37244953
 
 
 
<span>print(QAS_object[QAS_TEST]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span>
 
 
 
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span> False
 
 
 
<span>print(QAS_object[QAS_STATUS]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span>
 
 
 
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span>1
 
 
 
<span>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>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>print(QAS_object[QAS_ENDDATE]);<span style="mso-spacerun: yes;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
</span></span>
 
 
 
        &nbsp;&nbsp;&nbsp;// --- Result:<span style="mso-spacerun: yes;">&nbsp; </span> {1,1,1,1,0,0,0,1,40}
 
 
 
'''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span style="color: rgb(128, 0, 64); font-family: "arial","sans-serif"; font-size: 10pt; mso-fareast-font-family: "times new roman";" /&gt;'''
 
 
 
'''<span>Availability</span>'''
 
 
 
<span>Version 5.8.1</span>
 

Latest revision as of 10:28, 7 August 2019

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

Array of answer sheet objects(include Test QASs) {{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.

In later version, return value is array of QAS_class


Example:

array All_QASs = QAS_getByQuestionnaireResourceId(37244945);
print(All_QASs);  
/*old return: {
{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}
}*/
//new return: {QAS, QAS, QAS}

//old way to get items value of QAS object
array QAS_object = All_QASs[0];
print(QAS_object[QAS_ID]);//90267303 
print(QAS_object[QAS_USER_RESOURCE_ID]);//37244953
print(QAS_object[QAS_TEST]);//False
print(QAS_object[QAS_STATUS]);//1
print(QAS_object[QAS_COMPLETED]);//False
print(QAS_object[QAS_STARTDATE]);//{1,1,1,1,0,0,0,1,40}
print(QAS_object[QAS_ENDDATE]);//Result:  {1,1,1,1,0,0,0,1,40} 

//new way to get items value of QAS class
QAS qas = All_QASs[0];
print(qas.Id);//90267303 
print(qas.UserResourceId);//37244953
print(qas.Test);//False
print(qas.Status);//1
print(qas.Completed);//False
print(qas.StartDate);//{1,1,1,1,0,0,0,1,40}
print(qas.EndDate);//Result:  {1,1,1,1,0,0,0,1,40}

Availability
Version 5.8.1