Difference between revisions of "ConversionMethods"

From Catglobe Wiki
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 1,127: Line 1,127:
 
getResourceGuid(resourceId);
 
getResourceGuid(resourceId);
 
</source>
 
</source>
−
| style="border: 1px solid;" |
+
| style="border: 1px solid;" |This function is obsolete with 2 parameters, only implemented for questionnaire and PQ, others resource type will throw error
  
 
|- valign="top" align="left"
 
|- valign="top" align="left"
Line 1,420: Line 1,420:
 
string resourceTemplateName = "Consultant";
 
string resourceTemplateName = "Consultant";
 
User_getRoleIdByName(resourceTemplateName);//1
 
User_getRoleIdByName(resourceTemplateName);//1
 +
</source>
 +
[[getRoleIdByName|getRoleIdByName(resourceTemplateName)]]
 +
<source lang="javascript">
 +
string resourceTemplateName = "Consultant";
 +
getRoleIdByName(resourceTemplateName);//1
 
</source>
 
</source>
 
| style="border: 1px solid;" |[[User_getRoleResourceIdByName|User_getRoleResourceIdByName(resourceTemplateName)]]
 
| style="border: 1px solid;" |[[User_getRoleResourceIdByName|User_getRoleResourceIdByName(resourceTemplateName)]]
Line 1,425: Line 1,430:
 
string resourceTemplateName = "Consultant";
 
string resourceTemplateName = "Consultant";
 
User_getRoleResourceIdByName(resourceTemplateName);//1842
 
User_getRoleResourceIdByName(resourceTemplateName);//1842
 +
</source>
 +
[[ResourceTemplateHelper_class|ResourceTemplateHelper.GetTemplate(resourceTemplateName, ResourceType).ResourceId]]
 +
<source lang="javascript">
 +
string resourceTemplateName = "Consultant";
 +
ResourceTemplateHelper h = new ResourceTemplateHelper ();
 +
h.GetTemplate(resourceTemplateName, Resource_Type_User).ResourceId//1842
 
</source>
 
</source>
 
| style="border: 1px solid;" |new function User_getRoleResourceIdByName
 
| style="border: 1px solid;" |new function User_getRoleResourceIdByName
Line 1,434: Line 1,445:
 
getResourceTemplateIdByName(resourceTemplateName);//7
 
getResourceTemplateIdByName(resourceTemplateName);//7
 
</source>
 
</source>
−
| style="border: 1px solid;" |[[ResourceTemplateHelper|ResourceTemplateHelper.GetTemplate(resourceTemplateName, ResourceType).ResourceId]]
+
| style="border: 1px solid;" |[[ResourceTemplateHelper_class|ResourceTemplateHelper.GetTemplate(resourceTemplateName, ResourceType).ResourceId]]
 
<source lang="javascript">
 
<source lang="javascript">
 
string resourceTemplateName = "Standard Group";
 
string resourceTemplateName = "Standard Group";
Line 1,503: Line 1,514:
 
</source>
 
</source>
 
| style="border: 1px solid;" |Return a dictionary where the keys are questionnaire resource id  
 
| style="border: 1px solid;" |Return a dictionary where the keys are questionnaire resource id  
−
| style="border: 1px solid;" |
+
| style="border: 1px solid;" |Change return result from id to resource id
  
  
Line 1,514: Line 1,525:
 
| style="border: 1px solid;" |
 
| style="border: 1px solid;" |
 
Return a dictionary where the keys are user resource ids
 
Return a dictionary where the keys are user resource ids
−
| style="border: 1px solid;" |
+
| style="border: 1px solid;" |Change return result from id to resource id
  
  
Line 1,526: Line 1,537:
 
| style="border: 1px solid;" |
 
| style="border: 1px solid;" |
 
Return a dictionary where the keys are user resource ids
 
Return a dictionary where the keys are user resource ids
−
| style="border: 1px solid;" |
+
| style="border: 1px solid;" | Change return result from id to resource id
  
  
  
 
|}
 
|}

Latest revision as of 10:45, 21 September 2023

Catglobe system has been using two types of Ids at the same time, that causes a lot of confusion.

Therefore, need cleaning up to keep only one type of Id. Some methods will be obsolete and should update to use another one.

Please refer conversion table below for detail:

Obsolete methods Replace with Note
updateUserPermission(resourceId, permissionUsers) 
number resourceId = 17148446;
number userId1 = 5895442;
number userId2 = 5898785;
array permissionUsers = {{userId1, "Read"}, {userId2, "FullControl"}};
updateUserPermission(resourceId, permissionUsers);
updateUserResourceIdPermission(resourceId, permissionUsers) 
number resourceId = 17148446;
number userId1 = 12702700;
number userId2 = 12706043;
Dictionary permissionUsers = {userId1: "Read", userId2: "FullControl"};
updateUserResourceIdPermission(resourceId, permissionUsers);
QAS.UserId 
number userId = 5895442;
number qasId = 193213312;
QAS qas = new QAS (qasId);
qas.UserId = userId;
qas.Save();
print(qas.UserId);
QAS.UserResourceId 
number userId = 12702700;
number qasId = 193213312;
QAS qas = new QAS (qasId);
qas.UserResourceId = userId;
qas.Save();
print(qas.UserResourceId);
User_getResourceIdFromUserId(userId) Obsolete
User_getResourceIdFromUserIds(userIds) Obsolete
sendBulkMail(bulkMailId[, maxToSend]) 
number bulkMailId = 21063;
sendBulkMail(bulkMailId);




number bulkMailId = 21063;
number maxToSend = 100;
sendBulkMail(bulkMailId, maxToSend);
BulkMail.Send() 
number bulkMailId = 17148200;
BulkMail bm = new BulkMail(bulkMailId);
bm.Send();// return Cattask Instance Id

BulkMail.SendBulkMail(maxToSend, isTest, isSyncronious) 

number bulkMailId = 17148200;
number maxToSend = 100;
bool isTest = false;
bool isSyncronious = false;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)
New class BulkMail
sendBulkMailSyncronious(bulkMailId[, maxToSend]) 
number bulkMailId = 21063;
sendBulkMailSyncronious(bulkMailId);




number bulkMailId = 21063;
number maxToSend = 100;
sendBulkMailSyncronious(bulkMailId, maxToSend);
BulkMail.SendSyncronious() 
number bulkMailId = 17148200;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendSyncronious();//return number of sent

BulkMail.SendBulkMail(maxToSend, isTest, isSyncronious) 

number bulkMailId = 17148200;
number maxToSend = 100;
bool isTest = false;
bool isSyncronious = true;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)
New class BulkMail
sendTestBulkMail(bulkMailId[, maxToSend]) 
number bulkMailId = 21063;
sendTestBulkMail(bulkMailId);





number bulkMailId = 21063;
number maxToSend = 100;
sendTestBulkMail(bulkMailId, maxToSend);
BulkMail.SendBulkMail(maxToSend, isTest, isSyncronious) 
number bulkMailId = 17148200;
number maxToSend = -1;
bool isTest = true;
bool isSyncronious = false;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)

number bulkMailId = 17148200;
number maxToSend = 100;
bool isTest = true;
bool isSyncronious = false;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)
New class BulkMail
sendTestBulkMailSyncronious(bulkMailId[, maxToSend]) 
number bulkMailId = 21063;
sendTestBulkMailSyncronious(bulkMailId);





number bulkMailId = 21063;
number maxToSend = 100;
sendTestBulkMailSyncronious(bulkMailId, maxToSend);
BulkMail.SendBulkMail(maxToSend, isTest, isSyncronious) 
number bulkMailId = 17148200;
number maxToSend = -1;
bool isTest = true;
bool isSyncronious = true;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)

number bulkMailId = 17148200;
number maxToSend = 100;
bool isTest = true;
bool isSyncronious = true;
BulkMail bm = new BulkMail(bulkMailId);
bm.SendBulkMail(maxToSend, isTest, isSyncronious)
New class BulkMail
setBulkMailFromResource(bulkMailId, resourceId) 
number bulkMailId = 21065;
number resourceId = 17145420;

setBulkMailFromResource(bulkMailId, resourceId);
BulkMail.From = value 
number bulkMailId = 17148449;
number resourceId = 17145420;
BulkMail bm = new BulkMail (bulkMailId);
bm.From = new EmailAccount(0, resourceId);
bm.Save();
New class BulkMail
setBulkMailFromGlobalEmailAlias(bulkMailId, globalEmailId) 
number bulkMailId = 21065;
number globalEmailId = 16238;

setBulkMailFromGlobalEmailAlias(bulkMailId,globalEmailId);
BulkMail.From = value 
number bulkMailId = 17148449;
number globalEmailId = 16238;
BulkMail bm = new BulkMail (bulkMailId);
bm.From = new EmailAccount(1, globalEmailId);
bm.Save();
New class BulkMail
setBulkMailFromWebshop(bulkMailId) 
number bulkMailId = 21065;

setBulkMailFromWebshop(bulkMailId);
BulkMail.From = value 
number bulkMailId = 17148449;
BulkMail bm = new BulkMail (bulkMailId);
bm.From = new EmailAccount(2);
bm.Save();
New class BulkMail
setBulkMailFromSupport(bulkMailId) 
number bulkMailId = 21065;

setBulkMailFromSupport(bulkMailId);
BulkMail.From = value 
number bulkMailId = 17148449;
BulkMail bm = new BulkMail (bulkMailId);
bm.From = new EmailAccount(3);
bm.Save();
New class BulkMail
setBulkMailGroups(bulkMailId, groupIds) 
number bulkMailId = 21065;
array groupIds = {84129, 84130};
setBulkMailGroups(bulkMailId, groupIds)
BulkMail.SetGroups(groupIds) 
number bulkMailId = 17148449;
array groupIds = {17146562, 17146563};
BulkMail bm = new BulkMail (bulkMailId);
bm.SetGroups(groupIds)
New class BulkMail
setBulkMailGroupsToBeRebuilt(bulkMailId, groupIds) 
number bulkMailId = 21065;
array groupIds = {84129, 84130};
setBulkMailGroupsToBeRebuilt(bulkMailId, groupIds)
BulkMail.SetGroupsToBeRebuilt(groupIds) 
number bulkMailId = 17148449;
array groupIds = {17146562, 17146563};
BulkMail bm = new BulkMail (bulkMailId);
bm.SetGroupsToBeRebuilt(groupIds)
New class BulkMail
setBulkMailUsers(bulkMailId, userIds) 
number bulkMailId = 21065;
array userIds = {5895442, 5898785};
setBulkMailUsers(bulkMailId, userIds);
BulkMail.SetUsers(userIds) 
number bulkMailId = 17148449;
array userIds = {12702700, 12706043};
BulkMail bm = new BulkMail (bulkMailId);
bm.SetUsers(userIds);
New class BulkMail
addToGroup(groupId) 
//run on QAS context
number groupId = 84129;
addToGroup(groupId);
Group_addUser(userId, groupId) 
//run on QAS context
number groupId = 17146562;
number userId = QAS_getCurrentQAS().UserResourceId;
Group_addUser(userId, groupId);
removeFromGroup(groupId) 
//run on QAS context
number groupId = 84129;
removeFromGroup(groupId)
Group_removeUser(userId, groupId) 
//run on QAS context
number groupId = 17146562;
number userId = QAS_getCurrentQAS().UserResourceId;
Group_removeUser(userId, groupId)
questionnaireAnswerSheetExists(qnaireId[, userId]) 
number qnaireId = 619;
number userId = 5895442;
questionnaireAnswerSheetExists(qnaireId, userId);

//run on QAS context
number qnaireId = 619;
questionnaireAnswerSheetExists(qnaireId);
QAS_exists(qnaireId, userId) 
number qnaireId = 11560690;
number userId = 12702700;
QAS_exists(qnaireId, userId);

//run on QAS context
number qnaireId = 11560690;
number userId = QAS_getCurrentQAS().UserResourceId;
QAS_exists(qnaireId, userId);
createUserProjectQuestionnaire(qnaireId[, assignCurrentUser, useExisting]) 
number qnaireId = 619;

createUserProjectQuestionnaire(qnaireId);

//run on QAS context
number qnaireId = 619;
bool assignCurrentUser = true;
createUserProjectQuestionnaire(qnaireId, assignCurrentUser);

//run on QAS context
number qnaireId = 619;
bool assignCurrentUser = true;
bool useExisting = true;
createUserProjectQuestionnaire(qnaireId, assignCurrentUser, useExisting);
new QAS(qnaireId, userId) 
number qnaireId = 11560690;
number userId = -1;// force no user
new QAS(qnaireId, userId).Save();

//run on QAS context
number qnaireId = 11560690;
number userId = 0;// use current user 
new QAS(qnaireId, userId).Save();

QAS_getByUserResourceId(userId, qnaireId, createIfNone) 

//run on QAS context
number qnaireId = 11560690;
number userId = 0;// use current user
bool createIfNone = false;	
QAS_getByUserResourceId(userId, qnaireId, createIfNone)[0].Id;
createResourceProjectQuestionnaire(qnaireId[, assignCurrentUser, useExisting]) 
number qnaireId = 619;
createResourceProjectQuestionnaire(qnaireId);

//run on QAS context
number qnaireId = 619;
bool assignCurrentUser = true;
createResourceProjectQuestionnaire(qnaireId, assignCurrentUser);

//run on QAS context
number qnaireId = 619;
bool assignCurrentUser = true;
bool useExisting = true;
createResourceProjectQuestionnaire(qnaireId, assignCurrentUser, useExisting);
new QAS(qnaireId, userId) 
number qnaireId = 11560690;
number userId = -1;// force no user
new QAS(qnaireId, userId).Save();

//run on QAS context
number qnaireId = 11560690;
number userId = 0;// use current user 
new QAS(qnaireId, userId).Save();

QAS_getByUserResourceId(userId, qnaireId, createIfNone) 

//run on QAS context
number qnaireId = 11560690;
number userId = 0;// use current user
bool createIfNone = false;	
QAS_getByUserResourceId(userId, qnaireId, createIfNone)[0].Id;
groupExists(groupId) 
number groupId = 84129;
groupExists(groupId);
//true/false

groupExists(qualifiedName) 

string qualifiedName = "My project\\My group";
groupExists(qualifiedName);
//true/false
Group_getGroupByResourceId(groupId) 
number groupId = 17146562;
Group_getGroupByResourceId(groupId);
//return group object if found or empty if not found

Group_getGroupByName(qualifiedName) 

string qualifiedName = "My project\\My group";
Group_getGroupByName(qualifiedName); 
//return group object if found or empty if not found
isMemberOfGroup(userId, groupId) 
number userId = 5895442;
number groupId = 84129;
isMemberOfGroup(userId, groupId)

isMemberOfGroup(userId, groupName) 

number userId = 5895442;
string groupName = "My project\\My group";
isMemberOfGroup(userId, groupName);

isMemberOfGroup(groupId) 

//run on QAs context
number groupId = 84129;
isMemberOfGroup(groupId)

isMemberOfGroup(groupName) 

//run on QAs context
string groupName = "My project\\My group";
isMemberOfGroup(groupName)
Group_isMemberOfGroup(userId, groupId) 
number userId = 12702700;
number groupId = 17146562;
Group_isMemberOfGroup(userId, groupId);



number userId = 12702700;
string groupName = "My project\\My group"; 
number groupId  = Group_getGroupByName(groupName)[GROUP_RESOURCE_ID];
Group_isMemberOfGroup(userId, groupId);

//run on QAs context
number userId = QAS_getCurrentQAS().UserResourceId;
number groupId = 17146562;
Group_isMemberOfGroup(userId, groupId);

//run on QAs context
number userId = QAS_getCurrentQAS().UserResourceId;
string groupName = "My project\\My group"; 
number groupId  = Group_getGroupByName(groupName)[GROUP_RESOURCE_ID];
Group_isMemberOfGroup(userId, groupId);
rebuildGroup(groupId) 
number groupId = 84129;
rebuildGroup(groupId);
Group_rebuildGroup(groupId,parallelBuild) 
number groupId = 17146562;
bool parallelBuild = true;
Group_rebuildGroup(groupId, parallelBuild);
Tabulation_saveAsReport(name, parentId, permissionGroups[, overwrite]) 
DCS_use(16749647);
string name = "Report Test";
number parentId = 17148135;
number groupId1 = 84129;
number groupId2 = 84130;
array permissionGroups = {{groupId1, "Write"}, {groupId2, "FullControl"}};
bool overwrite = true;
createCrossDiagram ({"Q1"},{"Q2"});
Tabulation_saveAsReport(name, parentId, permissionGroups, overwrite);
Tabulation.SaveAsReport(name, parentId, permissionGroups, overwrite) 
string name = "Report Test";
number parentId = 17148135;
number groupId1 = 17146562;
number groupId2 = 17146563;
Dictionary permissionGroups = {groupId1: "Write", groupId2: "FullControl"};
bool overwrite = true;
TabulationDiagramParameter p = new TabulationDiagramParameter ();
Tabulation t = new Tabulation();
p.DataCache = 16749647;
t.CreateCrossDiagram ({"Q1"},{"Q2"}, p);
t.SaveAsReport(name, parentId, permissionGroups, overwrite);
New class Tabulation
updateGroupPermission(resourceId, permissionGroups) 
number resourceId = 17148446;
number groupId1 = 84129;
number groupId2 = 84130;
array permissionGroups = {{groupId1, "Write"}, {groupId2, "FullControl"}};
updateGroupPermission(resourceId, permissionGroups);
updateGroupResourceIdPermission(resourceId, permissionGroups) 
number resourceId = 17148446;
number groupId1 = 17146562;
number groupId2 = 17146563;
Dictionary permissionGroups = {groupId1: "Write", groupId2: "FullControl"};
updateGroupResourceIdPermission(resourceId, permissionGroups);
sendMailTemplateFromResource(parentId, toEmail, alias, mailTemplateId[, fromEmail, callbackMethod]) 
number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
sendMailTemplateFromResource(parentId, toEmail, alias, mailTemplateId)




number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
EmailAccount fromEmail = new EmailAccount("panel");
sendMailTemplateFromResource(parentId, toEmail, alias, mailTemplateId, fromEmail)



number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
EmailAccount fromEmail = new EmailAccount("panel");
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
sendMailTemplateFromResource(parentId, toEmail, alias, mailTemplateId, fromEmail, callbackMethod)
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod) 
number mailTemplateId = 17148149;
bool isTest = false;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
string fromEmail = empty;
object callbackMethod = empty;
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod)

number mailTemplateId = 17148149;
bool isTest = false;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
string fromEmail = "panel@...";
object callbackMethod = empty;
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod)

number mailTemplateId = 17148149;
bool isTest = false;
string toEmail = "email@...";
string alias = "Alias";
number parentId = 17148159;
string fromEmail = "panel@...";
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod)
New method EmailTemplate_send
sendMailTemplate(toEmail, alias, mailTemplateId) 
//run on QAS context
number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
sendMailTemplate(toEmail, alias, mailTemplateId)


sendMailTemplate(toEmail, alias, mailTemplateId, fromEmail, callbackMethod) 

//run on QAS context
number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
EmailAccount fromEmail = new EmailAccount("panel");
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
sendMailTemplate(toEmail, alias, mailTemplateId, fromEmail, callbackMethod)
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias) 
//run on QAS context
number mailTemplateId = 17148149;
bool isTest = false;
string toEmail = "email@...";
string alias = "Alias";
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias)

EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod) 

//run on QAS context
number mailTemplateId = 17148149;
bool isTest = false;
string toEmail = "email@...";
string alias = "Alias";
number parentId = empty;
string fromEmail = "panel@...";
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod)
New method EmailTemplate_send
sendTestMailTemplate(toEmail, alias, mailTemplateId[, fromEmail, callbackMethod]) 
//run on QAS context
number mailTemplateId = 6465;
string toEmail = "email@...";
string alias = "Alias";
EmailAccount fromEmail = new EmailAccount("panel");
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
sendTestMailTemplate(toEmail, alias, mailTemplateId, fromEmail, callbackMethod)
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias[, parentId, fromEmail, callbackMethod]) 
//run on QAS context
number mailTemplateId = 17148149;
bool isTest = true;
string toEmail = "email@...";
string alias = "Alias";
number parentId = empty;
string fromEmail = "panel@...";
object callbackMethod = function (string subject, string message){
	subject = "Test" + getRandomNumber(0,10); 
	return {subject, message};
};
EmailTemplate_send(mailTemplateId, isTest, toEmail, alias, parentId, fromEmail, callbackMethod)
New method EmailTemplate_send
getProjectQuestionnaireName([qnaireId]) 
number qnaireId = 619;
getProjectQuestionnaireName(qnaireId);








//run on QAS context
getProjectQuestionnaireName();
getProjectQuestionnaireNameByResourceId(qnaireId) 
number qnaireId = 11560690;
getProjectQuestionnaireNameByResourceId(qnaireId);

Resource_getResourceName(qniareId) 

number qnaireId = 11560690;
Resource_getResourceName(qnaireId);

Questionnaire_current().QualifiedName 

//run on QAS context 
Questionnaire_current().QualifiedName;











New method Questionnaire_current
setReportStyleSheetId(reportStyleSheetId) 
DCS_use(16749647);
number reportStyleSheetId = 11060624;
setReportStyleSheetId(getResourceIdFromGuid (getResourceGuid(reportStyleSheetId)));
createCrossDiagram({"Q1"}, {"Q2"});
Tabulation.StyleSheet = value 
number reportStyleSheetId = 11060624;
TabulationDiagramParameter p = new TabulationDiagramParameter();
p.DataCacheId = 16749647;
Tabulation t = new Tabulation();
t.StyleSheet = new ReportStyleSheet(reportStyleSheetId);
t.CreateCrossDiagram({"Q1"}, {"Q2"}, p);
New Tabulation class
New ReportStyleSheet class
setUserProjectQuestionnaireUserId(userId) 
//Run on QAS context
number userId = 5895442;
setUserProjectQuestionnaireUserId(userId);
QAS.UserResourceId = value 
// run on QAS context
number userId = 12702700;
QAS qas = QAS_getCurrentQAS();
qas.UserResourceId = userId;
qas.Save();
getUserProjectQuestionnaireUserId() 
//Run on QAS context
getUserProjectQuestionnaireUserId();//5895442
QAS.UserResourceId 
// run on QAS context
QAS_getCurrentQAS().UserResourceId;//12702700

User.ResourceId 

// run on QAS context
User_getQasUser().ResourceId;//12702700
setRPQUserId(userId) 
//Run on QAS context
number userId = 5895442;
setRPQUserId(userId);
QAS.UserResourceId = value 
// run on QAS context
number userId = 12702700;
QAS qas = QAS_getCurrentQAS();
qas.UserResourceId = userId;
qas.Save();
addJournal(resourceId, userId, journalType, content) 
number userId = 5895442;
number resourceId = 17148446;
string journalType  = "Comment";
string content = "xxx";
addJournal(resourceId, userId, journalType, content);
new ResourceJournalEntry (resourceId, journalType, content).Save() 
number resourceId = 17148446;
string journalType  = "Comment";
string content = "xxx";
new ResourceJournalEntry (resourceId, journalType, content).Save();
getTimezone([userId]) 
number userId = 5895442;
getTimezone(userId);

// run on QAS context
getTimezone();
User.TimezoneId 
number userId = 12702700;
User_getUserByResourceId(userId).TimezoneId;

// run on QAS context
User_getQasUser().TimezoneId;
setTimezone([userId,] timezoneId) 
number userId = 5895442;
number timezoneId = 40;
setTimezone(userId, timezoneId);



// run on QAS context
number timezoneId = 40;
setTimezone(timezoneId);
User.TimezoneId = value 
number userId = 12702700;
number timezoneId = 40;
User user = User_getUserByResourceId(userId);
user.TimezoneId = timezoneId;
user.Save();

// run on QAS context
number timezoneId = 40;
User user = User_getQasUser();
user.TimezoneId = timezoneId;
user.Save();
setUserRoleId(userId, resourceTemplateId) 
number userId = 5895442;
number resourceTemplateId = 6;
setUserRoleId(userId, resourceTemplateId);
setResourceTemplateResourceId(userId, resourceTemplateId) 
number userId = 12702700;
number resourceTemplateId = 1847;
setResourceTemplateResourceId(userId, resourceTemplateId);

User.ResourceTemplateResourceId = value 

number userId = 12702700;
number resourceTemplateId = 1847;
User_getUserByResourceId(userId).ResourceTemplateResourceId = resourceTemplateId;
getUserRoleId(userId) 
number userId = 5895442;
getUserRoleId(userId);//6
getResourceTemplateResourceId(userId) 
number userId = 12702700;
getResourceTemplateResourceId(userId);//1847

User.ResourceTemplateResourceId 

number userId = 12702700;
User_getUserByResourceId(userId).ResourceTemplateResourceId;//1847
isMemberOfSampleRule([userId,] sampleRuleId) 
number sampleRuleId = 125991;	
number userId = 5895442;
isMemberOfSampleRule(userId, sampleRuleId);

//run on QAS context
number sampleRuleId = 125991;
isMemberOfSampleRule(sampleRuleId);
User_isMemberOfSampleRule(userId, sampleRuleId) 
number sampleRuleId = 125991;	
number userId = 12702700;	
User_isMemberOfSampleRule(userId, sampleRuleId);

//run on QAS context	
number sampleRuleId = 125991 ;	
number userId = QAS_getCurrentQAS().UserResourceId;
User_isMemberOfSampleRule(userId, sampleRuleId);
New method User_isMemberOfSampleRule
EmailTemplate.PrimaryKey 
string name = "test";
number parentId = 17148446;
EmailTemplate e = new EmailTemplate (name, parentId);
e.Save();
print(e.PrimaryKey);//6468
EmailTemplate.ResourceId 
string name = "test";
number parentId = 17148446;
EmailTemplate e = new EmailTemplate (name, parentId);
e.Save();
print(e.ResourceId);//17148467
UserQuarantine.QuarantineResourceId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.QuarantineResourceId;//1
UserQuarantine.QuarantineResourceId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.QuarantineResourceId;//15550519
User.PrimaryKey 
User user = User_getLoggedInUser();
user.PrimaryKey;//5895442
User.ResourceId 
User user = User_getLoggedInUser();
user.ResourceId;//12702700
getQuestionnaireTemplateId(qualifiedName) 
string qualifiedName = "Common resources\\Panel Questionnaire Template";
getQuestionnaireTemplateId(qualifiedName);//536
new QuestionnaireTemplate(qualifiedName).Id 
string qualifiedName = "Common resources\\Panel Questionnaire Template";
new QuestionnaireTemplate(qualifiedName).Id;//11560689
New class QuestionnaireTemplate
getProjectQuestionnaireId(qualifiedName) 
string qualifiedName = "Common resources\\Ad Hoc 178";
getProjectQuestionnaireId(qualifiedName);//619
new Questionnaire(qualifiedName).Id 
string qualifiedName = "Common resources\\Ad Hoc 178";
new Questionnaire(qualifiedName).Id;//11560690
New class Questionnaire
getReturnToProjectQuestionnaireId() 
// run on QAS context
getReturnToProjectQuestionnaireId();//619
GetReturnToQuestionnaireId() 
// run on QAS context
GetReturnToQuestionnaireId();//11560690
New method GetReturnToQuestionnaireId
getReportStyleSheetIdByName(qualifiedName) 
string qualifiedName = "Common resources\\Tabulation Standard Report Stylesheet";
getReportStyleSheetIdByName(qualifiedName);//45
new ReportStyleSheet(qualifiedName).Id 
string qualifiedName = "Common resources\\Tabulation Standard Report Stylesheet";
new ReportStyleSheet(qualifiedName).Id;//11060624
New class ReportStyleSheet
getReportStyleSheetId() 
DCS_use(16749647);
number reportStyleSheetId = 11060624;
setReportStyleSheetId(getResourceIdFromGuid (getResourceGuid(reportStyleSheetId)));
createCrossDiagram({"Q1"}, {"Q2"});
getReportStyleSheetId();//45
Tabulation.StyleSheet 
number reportStyleSheetId = 11060624;
TabulationDiagramParameter p = new TabulationDiagramParameter();
p.DataCacheId = 16749647;
Tabulation t = new Tabulation();
t.StyleSheet = new ReportStyleSheet(reportStyleSheetId);
t.CreateCrossDiagram({"Q1"}, {"Q2"}, p);
t.StyleSheet;//11060624
New class Tabulation
New class ReportStyleSheet
getResourceIdFromGuid(guid) 
string guid = "xxx";
getResourceIdFromGuid(guid);//619
getResourceUniqueIdFromGuid(guid) 
string guid = "xxx";
getResourceUniqueIdFromGuid(guid);//11560690
getResourceGuid(Resource_Type_, resourceId) 
number resourceId = 619;
getResourceGuid(Resource_Type_Questionnaire, resourceId);
getResourceGuid(resourceId) 
number resourceId = 11560690;
getResourceGuid(resourceId);
This function is obsolete with 2 parameters, only implemented for questionnaire and PQ, others resource type will throw error
task[TASK_CASE_NUMBER] 
string taskName = "test";
number parentId = 17148446;
string taskDescription = "Test";
number resourceTemplateId = 2072;
array t = Task_new(taskName, parentId, taskDescription, resourceTemplateId);
Task_save(t);
print(t[TASK_CASE_NUMBER]);//62
task[TASK_RESOURCE_ID] 
string taskName = "test";
number parentId = 17148446;
string taskDescription = "Test";
number resourceTemplateId = 2072;
array t = Task_new(taskName, parentId, taskDescription, resourceTemplateId);
Task_save(t);
print(t[TASK_RESOURCE_ID]);//17148474
getCurrentUserId() 
getCurrentUserId();//5895442
User_getCurrentUser() 
User_getCurrentUser().ResourceId;//12702700
getUserIdFromResourceId(guid) 
string guid = "xxx";
getUserIdFromResourceId(guid);//5895442
getResourceUniqueIdFromGuid(guid) 
string guid = "xxx";
getResourceUniqueIdFromGuid(guid);//12702700
createUser(userResourceTemplateId) 
number resourceTemplateId = 1;
createUser(resourceTemplateId);//5895442
User_new(userResourceTemplateId) 
number resourceTemplateId = 1842;
User user = User_new(resourceTemplateId);
user.ParentResourceId = 17148446;
user.Save();
getRPQUserId() 
//run on QAS context
getRPQUserId();//5895442
QAS.UserResourceId 
//run on QAS context
QAS_getCurrentQAS().UserResourceId;//12702700

User.ResourceId 

//run on QAS context
User_getQasUser().ResourceId;//12702700
User.ResourceTemplateId 
User user = User_getLoggedInUser();
user.ResourceTemplateId;//1
User.ResourceTemplateResourceId 
User user = User_getLoggedInUser();
user.ResourceTemplateResourceId;//1842
UserQuarantine.AddedByUserId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.AddedByUserId;//5895442
UserQuarantine.AddedByUserResourceId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.AddedByUserResourceId;//12702700
New property UserQuarantine.AddedByUserResourceId
UserQuarantine.RemovedByUserId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.RemovedByUserId;//5895442
UserQuarantine.RemovedByUserResourceId 
number userId= 12706043;
array quarantineHistory = Quarantine_getUserHistory(userId);
UserQuarantine q = quarantineHistory[0];
q.RemovedByUserResourceId;//12702700
New property UserQuarantine.RemovedByUserResourceId
Quarantine_getUserIdsOfQuarantined(quarantineIdList) 
array quarantineIdList = {15550518,15550519};
Quarantine_getUserIdsOfQuarantined(quarantineIdList);
//{5895442,5898785,...}
Quarantine_GetUserResourceIdsOfQuarantined(quarantineIdList) 
array quarantineIdList = {15550518,15550519};
Quarantine_GetUserResourceIdsOfQuarantined(quarantineIdList);
//{12702700,12706043,..}
New method Quarantine_GetUserResourceIdsOfQuarantined
User.CreatedByUserId 
User user = User_getLoggedInUser();
user.CreatedByUserId;//5895442
User.CreatedByUserResourceId 
User user = User_getLoggedInUser();
user.CreatedByUserResourceId;//12702700
New property User.CreatedByUserResourceId
User.ModifiedByUserId 
User user = User_getLoggedInUser();
user.ModifiedByUserId;//5895442
User.ModifiedByUserResourceId 
User user = User_getLoggedInUser();
user.ModifiedByUserResourceId;//12702700
New property User.ModifiedByUserResourceId
SampleRule.QuestionnaireId 
number groupId = 17146562;
array a = SampleRule_getByGroupResourceId(groupId);
SampleRule s = a[0];
print(s.QuestionnaireId );//619
SampleRule.QuestionnaireResourceId 
number groupId = 17146562;
array a = SampleRule_getByGroupResourceId(groupId);
SampleRule s = a[0];
print(s.QuestionnaireResourceId );//11560690
SampleRule.GroupId 
number qnaireId = 11560690;
array a = SampleRule_getByQuestionnaireResourceId(qnaireId);
SampleRule s = a[0];
print(s.GroupId);//84129
SampleRule.GroupResourceId 
number qnaireId = 11560690;
array a = SampleRule_getByQuestionnaireResourceId(qnaireId);
SampleRule s = a[0];
print(s.GroupResourceId);//17146562
getResourceUniqueIdFromTaskCaseNumber(caseNumber) Obsolete
Task_getTaskByCaseNumber(caseNumber) 
number caseNumber = 62;
Task_getTaskByCaseNumber(caseNumber);
Task_getTaskByResourceId(taskId) 
number taskId = 17148474;
Task_getTaskByResourceId(taskId);
createTask(taskName, parentId, responsibleId, taskDescription, resourceTemplateId) 
string taskName = "test";
number parentId = 17148446;
string taskDescription = "Test";
number resourceTemplateId = 13;
number responsibleId = 5895442;
createTask(taskName, parentId, responsibleId, taskDescription, resourceTemplateId);
Task_new(taskName, parentId, taskDescription, resourceTemplateId) 
string taskName = "test";
number parentId = 17148446;
string taskDescription = "Test";
number resourceTemplateId = 2072;
array t = Task_new(taskName, parentId, taskDescription, resourceTemplateId);
t[TASK_RESPONSIBLE_RESOURCE_ID] = 5895442;
Task_save(t);
setResourceTemplateId(resourceId, resourceTemplateId) 
number resourceId = 17146562;
number resourceTemplateId = 7;
setResourceTemplateId(resourceId, resourceTemplateId);
setResourceTemplateResourceId(resourceId, resourceTemplateId) 
number resourceId = 17146562;
number resourceTemplateId = 2066;
setResourceTemplateResourceId(resourceId, resourceTemplateId);
getResourceTemplateId(resourceId) 
number resourceId = 17146562;
getResourceTemplateId(resourceId)//7
getResourceTemplateResourceId(resourceId) 
number resourceId = 17146562;	
getResourceTemplateResourceId(resourceId);//2066
getResourceTemplateType(resourceTemplateId) 
number resourceTemplateId = 7;
getResourceTemplateType(resourceTemplateId);
//2 GroupResourceTemplate
ResourceTemplateHelper.GetTemplate(resourceTemplateId).ResourceTemplateType 
number resourceTemplateId = 2066;
ResourceTemplateHelper h = new ResourceTemplateHelper ();
h.GetTemplate(resourceTemplateId).ResourceTemplateType;
//2 GroupResourceTemplate
User_getRoleIdByName(resourceTemplateName) 
string resourceTemplateName = "Consultant";
User_getRoleIdByName(resourceTemplateName);//1

getRoleIdByName(resourceTemplateName) 

string resourceTemplateName = "Consultant";
getRoleIdByName(resourceTemplateName);//1
User_getRoleResourceIdByName(resourceTemplateName) 
string resourceTemplateName = "Consultant";
User_getRoleResourceIdByName(resourceTemplateName);//1842

ResourceTemplateHelper.GetTemplate(resourceTemplateName, ResourceType).ResourceId 

string resourceTemplateName = "Consultant";
ResourceTemplateHelper h = new ResourceTemplateHelper ();
h.GetTemplate(resourceTemplateName, Resource_Type_User).ResourceId//1842
new function User_getRoleResourceIdByName
getResourceTemplateIdByName(resourceTemplateName) 
string resourceTemplateName = "Standard Group";
getResourceTemplateIdByName(resourceTemplateName);//7
ResourceTemplateHelper.GetTemplate(resourceTemplateName, ResourceType).ResourceId 
string resourceTemplateName = "Standard Group";
ResourceTemplateHelper h = new ResourceTemplateHelper ();
h.GetTemplate(resourceTemplateName, Resource_Type_Group).ResourceId//2066
ActivityHistory.OtherUserId 
array userId = {12702700};
ActivityHistorySearch search = new ActivityHistorySearch(userId);
search.SearchForCati = true;
ActivityHistory history = search.Execute();
history.SetCurrent(0);
print(history.OtherUserId);//5898785
ActivityHistory.OtherUserResourceId 
array userId = {12702700};
ActivityHistorySearch search = new ActivityHistorySearch(userId);
search.SearchForCati = true;
ActivityHistory history = search.Execute();
history.SetCurrent(0);
print(history.OtherUserResourceId);
new property ActivityHistory.OtherUserResourceId
ActivityHistory.ToUserId 
array userId = {12702700};
ActivityHistorySearch search = new ActivityHistorySearch(userId);
search.SearchForCati = true;
ActivityHistory history = search.Execute();
history.SetCurrent(0);
print(history.ToUserId);//5895442
Missing
Order.UserId 
number orderId = 65;
new Order(orderId).UserId;//5895442
Order.UserResourceId 
number orderId = 65;
new Order(orderId).UserResourceId;
new Property Order.UserResourceId
PanelStatistics.TotalEarnedPointsBySurvey() 
array  QnaireResourceTemplateId = {15525200};
array bulkmailResourceTemplateId = {20940};
number groupId  = 15571185;
array From = DateTime_getByYMD (2021,1,1);
array To = DateTime_getByYMD (2021,1,2);
number groupBy = 3;
PanelStatistics p = new PanelStatistics (QnaireResourceTemplateId, bulkmailResourceTemplateId, groupId, From, To, groupBy, 0);
Dictionary d = p.TotalEarnedPointsBySurvey();
//Return a dictionary where the keys are questionnaire id  {"2345": 160, "2355": 60, "2360": 70}
Return a dictionary where the keys are questionnaire resource id Change return result from id to resource id


Timereg_getByResourceIds()

Return a dictionary where the keys were user ids

Return a dictionary where the keys are user resource ids

Change return result from id to resource id


Timereg_getByResource()

Return a dictionary where the keys were user ids

Return a dictionary where the keys are user resource ids

Change return result from id to resource id


Retrieved from "http://wiki.catglobe.com/index.php?title=ConversionMethods&oldid=240894"