Difference between revisions of "QAS getByQuestionnaireResourceId"
(Created page with "'''QAS_getByQuestionnaireResourceId<br>'''Get all answer sheets of a specific Questionnaire by Questionaire resource Id. '''Syntax<br>''''''Arguments<br>''' - questionnaire...") |
(Tag: visualeditor) |
||
(17 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | '''QAS_getByQuestionnaireResourceId | + | {{HelpFiles}} |
+ | '''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''' | ||
+ | |||
+ | <nowiki>Array of answer sheet objects(include Test QASs) {{QAS_1},{QAS_2},{QAS_3},…...)</nowiki> | ||
+ | |||
+ | 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]] | ||
+ | |||
+ | <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} | ||
+ | |||
+ | //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} | ||
+ | </source> | ||
+ | '''Availability<br>'''Version 5.8.1 | ||
+ | |||
+ | [[Category:Questionnaire_Functions]] |
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