Catglobe Wiki - User contributions [en]

SetResource

2018-07-27T05:05:43Z

Tungocman:

[[Category:Resource_Functions]]

{{HelpFiles}} __NOTOC__

It is used to set the resource used in
getBoolConstant,
getBooleanConstant,
getNumberConstant,
getStringConstant,
getDateTimeConstant,
getSingleConstant,
getSingleConstantSelectedText,
getMultiConstant,
getMultiConstantSelectedTexts,
if none is given as parameter
'''REALLY SHOULD REMOVE THAT FUNCTION, SINCE PROBABLY NOONE EVER USED IT'''

== Syntax ==

setResource(string resourceGUID);

== Arguments ==
''resourceGUID'': string.

== Return type ==
Empty

== Example ==

<source lang="javascript">
setResource("F04731D2-23A7-4877-BE75-6E8C027E3B4E");
</source>

SetResource

2018-07-27T05:05:29Z

Tungocman:

[[Category:Resource_Functions]]

{{HelpFiles}} __NOTOC__

It is used to set the resource used in
getBoolConstant,
getBooleanConstant,
getNumberConstant,
getStringConstant,
getDateTimeConstant,
getSingleConstant,
getSingleConstantSelectedText,
getMultiConstant,
getMultiConstantSelectedTexts,
if none is given as parameter
''REALLY SHOULD REMOVE THAT FUNCTION, SINCE PROBABLY NOONE EVER USED IT''

== Syntax ==

setResource(string resourceGUID);

== Arguments ==
''resourceGUID'': string.

== Return type ==
Empty

== Example ==

<source lang="javascript">
setResource("F04731D2-23A7-4877-BE75-6E8C027E3B4E");
</source>

SetResource

2018-07-27T05:03:41Z

Tungocman:

[[Category:Resource_Functions]]

{{HelpFiles}}

It is used to set the resource used in
getBoolConstant,
getBooleanConstant,
getNumberConstant,
getStringConstant,
getDateTimeConstant,
getSingleConstant,
getSingleConstantSelectedText,
getMultiConstant,
getMultiConstantSelectedTexts,
if none is given as parameter
''REALLY SHOULD REMOVE THAT FUNCTION, SINCE PROBABLY NOONE EVER USED IT''

== Syntax ==

setResource(string resourceGUID);

== Arguments ==
''resourceGUID'': string.

== Return type ==
Empty

== Example ==

<source lang="javascript">
setResource("F04731D2-23A7-4877-BE75-6E8C027E3B4E");
</source>

PushDiagramsToViewer

2018-07-27T05:00:25Z

Tungocman:

[[Category:General_Functions]]
{{HelpFiles}}
__NOTOC__

PLEASE UPDATE ME FOR MORE DETAIL ABOUT THE USAGE OF THIS FUNCTION!

Below is the discussion about the meaning of this function:

Q: Can you show me more info about this function PushDiagramsToViewer()?

A: It just updates the session information with the report elements. This allows you to run a workflow one place and view the diagrams in some other process (for the same session ofcourse)
Otherwise it is normally only done when using the cgs prompt

Q: When this line is excuted, it auto makes all current viewers in other processes update the diagrams immediately. it is the meaning of this function?

A: It just updates the session info... You ofcourse still need to refresh the browser showing TabulationResultViewer.aspx to see the new diagrams

== Syntax ==

pushDiagramsToViewer ();

== Arguments ==

Empty

== Return type ==
Empty

PushDiagramsToViewer

2018-07-27T04:58:03Z

Tungocman:

[[Category:General_Functions]]
{{HelpFiles}}
__NOTOC__

= pushDiagramsToViewer =

== Syntax ==

pushDiagramsToViewer ();

== Arguments ==

Empty

== Return type ==
Empty

PushDiagramsToViewer

2018-07-27T04:57:32Z

Tungocman:

[[Category:General_Functions]]
{{HelpFiles}}
_NOTOC_

= pushDiagramsToViewer =

== Syntax ==

pushDiagramsToViewer ();

== Arguments ==

Empty

== Return type ==
Empty

Stringjoin

2018-07-27T04:18:12Z

Tungocman:

[[Category:String_Functions]]
{{HelpFiles}}

==== stringjoin ====

Join list of strings in an array of strings with the specified separator

'''Syntax'''

stringjoin(string separator, array stringsToJoin)

'''Arguments'''

separator: is string
stringsToJoin: is an array

'''Return type'''

string
'''Example'''

<source lang="javascript">
print(stringjoin(" <=> ",{1,2,"bbbbb",4,5}));

// result: 1<=>2<=>bbbbb<=>4<=>5
</source>
 '''Availability'''

Version 5.8

GetUserProjectQuestionnaireResourceId

2018-07-27T04:03:13Z

Tungocman:

[[Category:Questionnaire_Functions]]
====getUserProjectQuestionnaireResourceId====

Gets the unique id of the current questionnaire answer sheet context.

'''Syntax'''

getUserProjectQuestionnaireResourceId()

'''Arguments'''

none

'''Return type'''

string

'''Example'''

string s = getUserProjectQuestionnaireResourceId();

print(s); // ee25f04c-2f65-457a-bc64-5d00627397a9

'''Availability'''

Version 5.0
__NOTOC__

LocalizedString class

2018-07-13T03:46:23Z

Tungocman:

{{CGscriptClass_Template
|Name=<nowiki>LocalizedString</nowiki>
|Description=<nowiki>Represents translation of a string.</nowiki>
|Constructors=
{{CGscriptConstructors_Template|Description=<nowiki>Create a new translatable text</nowiki>}}
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=Dictionary|Name=<nowiki>dictionary</nowiki>|Description=<nowiki>Dictionary with existing values</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>defaultIsocode</nowiki>|Description=<nowiki>If given use this isocodes value in the dictionary as the default</nowiki>}}
|Description=<nowiki>Create a new translatable text based on existing dictionary</nowiki>}}
|Methods=
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>GetSpecificTranslation</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>isocode</nowiki>|Description=<nowiki>Isocode for language. Use empty for default text</nowiki>}}
|Description=<nowiki>Get the translation for given isocode or null</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>GetTranslation</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>isocode</nowiki>|Description=<nowiki>Isocode for language. Use empty for default text</nowiki>}}
|Description=<nowiki>Get the best matching translation for given isocode</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>GetTranslationForLoggedInUser</nowiki>|Description=<nowiki>Get the best matching translation for the current user</nowiki>}}
{{CGscriptMethods_Template|ReturnType=bool|Name=<nowiki>RemoveTranslation</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>isocode</nowiki>|Description=<nowiki>Isocode for language. Use empty for default text</nowiki>}}
|Description=<nowiki>Remove a specific translation</nowiki>}}
{{CGscriptMethods_Template|ReturnType=Empty|Name=<nowiki>SetTranslation</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>isocode</nowiki>|Description=<nowiki>Isocode for language. Use empty for default text</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>s</nowiki>|Description=<nowiki>New translation</nowiki>}}
|Description=<nowiki>Set a specific translation</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Description=<nowiki>The string representation of the object.</nowiki>}}
|Properties=
{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Description=<nowiki>Get information about this class.</nowiki>}}
}}

Questionnaire new

2018-07-13T03:44:03Z

Tungocman:

{{HelpFiles}}
_NOTOC_

= Questionnaire_new =

To create a new questionnaire object.

=== Syntax ===

array Questionnaire_new(string questionnaireName, number questionnaireResourceTemplateResourceId, number questionnaireTemplateResourceId, number layoutResourceId, number questionnaireParentResourceId)

=== Arguments ===

- questionnaireName : the name of new questionnaire.

- questionnaireResourceTemplateResourceId : questionnaire resource template resource id

- questionanireTemplateResourceId : existing questionnaire template resource id.

- layoutResourceId : layout resource id.

- questionnaireParentResourceId : parent resource id of questionnaire.

=== Return type ===

array,

{| width="651" class="tableintopic" style="border: 1px solid rgb(1, 1, 1); border-collapse: collapse;" border="1" cellspacing="0" cellpadding="2"
|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" bgcolor="#bfbfbf" |
'''Index'''

| width="120" style="border: 1px solid rgb(1, 1, 1);" bgcolor="#bfbfbf" |
'''Data type'''

| width="183" style="border: 1px solid rgb(1, 1, 1);" bgcolor="#bfbfbf" |
'''Value'''

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_OBJECT_TYPE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Questionnaire object

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_RESOURCE_ID]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
0

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_NAME]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Entered value

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_RESOURCE_TEMPLATE_RESOURCE_ID]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Entered value

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_PARENT_RESOURCE_ID]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Entered value

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_TEMPLATE_RESOURCE_ID]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Entered value

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_TIME_REGISTRATION]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
boolean

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Depends on Questionnaire Resource Template settings

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_COMPLETED]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
bool (read only)

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
FALSE

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNAIRE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
bool

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
FALSE

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_USE_OLD_VIEWER]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
bool

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
TRUE

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_ALIAS]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
""

Default:

- Disabled

- Enabled when [QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNNAIRE] = true

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_LAYOUT_RESOURCE_ID]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Entered value

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_TIME_ESTIMATE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
""

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_STATUS]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
1

**Constant:

1 : QUESTIONNAIRE_STATUS_CLOSED

2: QUESTIONNAIRE_STATUS_PAUSED

3: QUESTIONNAIRE_STATUS_ACTIVE

4: QUESTIONNAIRE_STATUS_OPEN_FOR_TEST

 

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_TARGET]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
0

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_CATI_OUTCOME_SET]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
""

Only can be changed when there's no Cati contact

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_AUTOMATIC_RELEASE_DATE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
datetime array

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Mindate

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_DEVELOPMENT_START_DATE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
datetime array

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Mindate

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_AUTOMATIC_CLOSE_DATE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
datetime array

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Maxdate

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_DEVELOPMENT_END_DATE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
datetime array

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Maxdate

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE _MAN_HOURS]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
number

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
0

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE _DESCRIPTION]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
Default is same with questionnaire name, if description is empty

|- align="left" valign="top"
| width="348" style="border: 1px solid rgb(1, 1, 1);" |
[QUESTIONNAIRE_DEFAULT_LANGUAGE]

| width="120" style="border: 1px solid rgb(1, 1, 1);" |
string

| width="183" style="border: 1px solid rgb(1, 1, 1);" |
The default language of questionnaire in iso code

|}

 '''Example'''

array a= Questionnaire_new("new questionnaire",34409965,34822447 , 34779240,34775455 );

'''Availability'''

Version 5.8
[[Category:Questionnaire Functions]]

UpdateGroupPermission

2018-06-01T02:34:37Z

Tungocman:

[[Category:Resource_Functions]]
{{HelpFiles}}

====updateGroupPermission====

Updates the group permissions of a specific resource.

'''Syntax'''

updateGroupPermission(''resourceUniqueId, permissions'')

'''Arguments'''

''resourceUniqueId'': Is a numeric (non-decimal) expression. It is the UniqueId of a resource.

''permissions''<nowiki>: Is an array of the following format: {{groupId1, permission1}, {groupId2, permission2}, …}</nowiki>

'' groupId''i: a numeric (non-decimal) expression. It is the id of a group.

'' permission''i: a string expression. It is the permission for the ith group. It must have one of these value:

“None” or 0: Remove access from resource

“Read”

“Write”

“FullControl”

'''Return type'''

empty

'''Examples'''

<nowiki>array permissions = {{3, "FullControl"}, {4, "Read"}};</nowiki>

updateGroupPermission(2188468, permissions);

'''Availability'''

Version 4.8
__NOTOC__

UpdateGroupResourceIdPermission

2018-06-01T02:33:51Z

Tungocman: /* Arguments */

[[Category:Resource_Functions]]
{{HelpFiles}}

= updateGroupResourceIdPermission =

Grant groups have permission to a resource

== Syntax ==

updateGroupResourceIdPermission(resourceRId, groupPermission);

== Arguments ==
''resourceRId'': number. Resource Id of a resource

''groupPermission'': Dictionary for group permission. EX: {groupRId1: permission, groupRId2: permission}.

Permission constant:

* Resource_Permission_None or 0: Remove access from resource

* Resource_Permission_Read

* Resource_Permission_Write

* Resource_Permission_FullControl

== Return type ==
Empty

== Example ==

<source lang="javascript">
//grant permission for group to a resource
number resourceRId = 11088827;
number groupRId1 = 15596764;
number groupRId2 = 15085949;
number groupRId3 = 11051956;
Dictionary groupPermission = {
groupRId1: Resource_Permission_Read,
groupRId2: Resource_Permission_Write,
groupRId3: Resource_Permission_FullControl
};
updateGroupResourceIdPermission(resourceRId, groupPermission);
</source>

Access of the resource before grant

[[File:Access_before_grant.png]]

Access of the resource after grant

[[File:Access_after_grant.png]]

UpdateUserPermission

2018-06-01T02:33:16Z

Tungocman:

[[Category:Resource_Functions]]
{{HelpFiles}}

====updateUserPermission====

Updates the user permissions of a specific resource.

'''Syntax'''

updateUserPermission(''resourceUniqueId, permissions'')

'''Arguments'''

''resourceUniqueId'': Is a numeric (non-decimal) expression. It is the UniqueId of a resource.

''permissions''<nowiki>: Is an array of the following format: {{</nowiki>''useId1, permission1}, {userId2, permission2}, …''}

'' userId'': a numeric (non-decimal) expression. It is the id of a user.

'' permission'': a string expression. It is the permission for the the user. It must have one of the following values:

“None” or 0: Remove access from resource

“Read”

"Write”

"FullControl”

'''Return type'''

empty

'''Examples'''

<nowiki>array permissions = {{3, "FullControl"}, {4, "Read"}};</nowiki>

updateUserPermission(2188468, permissions);

'''Availability'''

Version 4.8
__NOTOC__

UpdateUserPermission

2018-06-01T02:32:51Z

Tungocman:

[[Category:Resource_Functions]]
{{HelpFiles}}

====updateUserPermission====

Updates the user permissions of a specific resource.

'''Syntax'''

updateUserPermission(''resourceUniqueId, permissions'')

'''Arguments'''

''resourceUniqueId'': Is a numeric (non-decimal) expression. It is the UniqueId of a resource.

''permissions''<nowiki>: Is an array of the following format: {{</nowiki>''useId1, permission1}, {userId2, permission2}, …''}

'' userId'': a numeric (non-decimal) expression. It is the id of a user.

'' permission'': a string expression. It is the permission for the the user. It must have one of the following values:

“None” or 0: Remove access from resource

“Read”:

"Write”

"FullControl”

'''Return type'''

empty

'''Examples'''

<nowiki>array permissions = {{3, "FullControl"}, {4, "Read"}};</nowiki>

updateUserPermission(2188468, permissions);

'''Availability'''

Version 4.8
__NOTOC__

Resource isInheritAccess

2018-05-31T11:27:15Z

Tungocman: Created page with "= Resource_isInheritAccess = UPDATE ME PLEASE! Category:Resource_Functions __NOTOC__"

= Resource_isInheritAccess =

UPDATE ME PLEASE!

[[Category:Resource_Functions]]
__NOTOC__

Resource setInheritAccess

2018-05-31T11:26:19Z

Tungocman: Created page with "= Resource_setInheritAccess = UPDATE ME PLEASE! Category:Resource_Functions __NOTOC__"

= Resource_setInheritAccess =

UPDATE ME PLEASE!

[[Category:Resource_Functions]]
__NOTOC__

SelectMultiDictionaryReadOnly

2018-04-26T03:51:03Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == SelectMultiDictionaryReadOnly where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== SelectMultiDictionaryReadOnly where expression ==

UPDATE ME PLEASE

SelectMultiDictionary

2018-04-26T03:50:25Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == SelectMultiDictionary where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== SelectMultiDictionary where expression ==

UPDATE ME PLEASE

SelectDictionaryReadOnly

2018-04-26T03:49:43Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == SelectDictionaryReadOnly where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== SelectDictionaryReadOnly where expression ==

UPDATE ME PLEASE

SelectDictionary

2018-04-26T03:48:53Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == SelectDictionary where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== SelectDictionary where expression ==

UPDATE ME PLEASE

SelectMultiColumnReadOnly

2018-04-26T03:48:06Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == SelectMultiColumnReadOnly where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== SelectMultiColumnReadOnly where expression ==

UPDATE ME PLEASE

ExplainFreeText Where

2018-04-26T03:47:11Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == ExplainFreeText where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== ExplainFreeText where expression ==

UPDATE ME PLEASE

Sum Where

2018-04-26T03:44:09Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions == Sum where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]

== Sum where expression ==

UPDATE ME PLEASE

Min Where

2018-04-26T03:43:20Z

Tungocman:

[[Category:Functions_Used_in_where_Expressions]]

== Min where expression ==

UPDATE ME PLEASE

Max Where

2018-04-26T03:43:00Z

Tungocman:

[[Category:Functions_Used_in_where_Expressions]]

== Max where expression ==

UPDATE ME PLEASE

Max Where

2018-04-26T03:42:15Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions {{_NOTOC_}} == Max where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]
{{_NOTOC_}}

== Max where expression ==

UPDATE ME PLEASE

Min Where

2018-04-26T03:38:46Z

Tungocman:

[[Category:Functions_Used_in_where_Expressions]]
{{_NOTOC_}}

== Min where expression ==

UPDATE ME PLEASE

Min Where

2018-04-26T03:38:02Z

Tungocman: Created page with "Category:Functions_Used_in_where_Expressions {{HelpFiles}}{{_NOTOC_}} == Min Where expression == UPDATE ME PLEASE"

[[Category:Functions_Used_in_where_Expressions]]
{{HelpFiles}}{{_NOTOC_}}

== Min Where expression ==

UPDATE ME PLEASE

UpdateGroupResourceIdPermission

2018-03-23T04:16:48Z

Tungocman:

[[Category:Resource_Functions]]
{{HelpFiles}}

= updateGroupResourceIdPermission =

Grant groups have permission to a resource

== Syntax ==

updateGroupResourceIdPermission(resourceRId, groupPermission);

== Arguments ==
''resourceRId'': number. Resource Id of a resource

''groupPermission'': Dictionary for group permission. EX: {groupRId1: permission, groupRId2: permission}.

Permission constant:

* Resource_Permission_Read

* Resource_Permission_Write

* Resource_Permission_FullControl

== Return type ==
Empty

== Example ==

<source lang="javascript">
//grant permission for group to a resource
number resourceRId = 11088827;
number groupRId1 = 15596764;
number groupRId2 = 15085949;
number groupRId3 = 11051956;
Dictionary groupPermission = {
groupRId1: Resource_Permission_Read,
groupRId2: Resource_Permission_Write,
groupRId3: Resource_Permission_FullControl
};
updateGroupResourceIdPermission(resourceRId, groupPermission);
</source>

Access of the resource before grant

[[File:Access_before_grant.png]]

Access of the resource after grant

[[File:Access_after_grant.png]]

RegexReplace class

2017-12-22T18:43:33Z

Tungocman:

{{CGscriptClass_Template
|Name=<nowiki>RegexReplace</nowiki>
|Description=<nowiki>A regexp engine for replacing values</nowiki>
|Constructors=
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>exp</nowiki>|Description=<nowiki>Regular expression to use. See .NET documentation of what is possible for Regex class</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>isSingleLine</nowiki>|Description=<nowiki>True = Specifies single-line mode. Changes the meaning of the dot (.) so it matches every character (instead of every character except newline). False = Multiline mode. Changes the meaning of ^ and $ so they match at the beginning and end, respectively, of any line, and not just the beginning and end of the entire string.</nowiki>}}
|Description=<nowiki>Create a new replacer.</nowiki>}}
|Methods=
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>Replace</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>input</nowiki>|Description=<nowiki>Input string to search</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=<nowiki>replacement</nowiki>|Description=<nowiki>Replace all matches with this string</nowiki>}}
|Description=<nowiki>Replace matches with given string</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>Replace</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>input</nowiki>|Description=<nowiki>Input string to search</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=Function|Name=<nowiki>replacement</nowiki>|Description=<nowiki>Call this function once for every match, it must return the value to insert at the matched location. Gets each group as a seperate parameter. If using named captures, the names are mapped to parameter names.</nowiki>}}
|Description=<nowiki>Replace matches by return value from Function</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Description=<nowiki>The string representation of the object.</nowiki>}}
|Properties=
{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Description=<nowiki>Get information about this class.</nowiki>}}
}}

[[Category:Classes]]

Dictionary isDictionary

2017-06-05T08:10:09Z

Tungocman:

{{HelpFiles}}

=== Dictionary_isDictionary ===

Check object is dictionary

=== Syntax ===

Dictionary_isDictionary(param);

=== Arguments ===

param: any type

=== Return type ===

bool

=== Examples ===

<source lang="javascript">
Dictionary_isDictionary(1);
// false
Dictionary_isDictionary({"A":true});
// true
</source> __NOTOC__
[[Category:General_Functions]]

QAS exists

2017-06-05T08:09:15Z

Tungocman:

{{HelpFiles}}

==== QAS_exists ====

Checks if answer sheet exists by its user resource id and questionnaire resource id.

'''Syntax'''

QAS_exists(''pqRsId, userRsId'')

'''Arguments'''

''pqRsId: number. Is the project questionnaire resource id which is being checked if the user has answer sheet.''

''userRsId: number. Is the user resource id which is being checked in regards to finding whether he has answer sheet for the questionnaire.''

'''Return type'''

bool

'''Examples'''

<source lang="javascript">
number qRsId=15532172;
number uRsId=15498958;
bool a = QAS_exists(qRsId,uRsId);
print(a);
</source>
[[Category:Questionnaire_Functions]]

CGS Constants list

2017-06-05T08:08:07Z

Tungocman:

= CGScript Constants List =

=== Search type constants ===

<source lang="sql">
NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_END
NAME_SEARCH_TYPE_IDENTICAL
NAME_SEARCH_TYPE_START
</source>

=== Resource access constant ===

<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
</source>

=== Resource type constant ===

<source lang="sql">
Resource_Type_ResourceTemplate
Resource_Type_User
Resource_Type_Group
Resource_Type_ReportTemplate
Resource_Type_Project
Resource_Type_Folder
Resource_Type_QuestionnaireTemplate
Resource_Type_Attachment
Resource_Type_Questionnaire
Resource_Type_Report
Resource_Type_MessageTemplate
Resource_Type_Image
Resource_Type_Layout
Resource_Type_Product
Resource_Type_MessageFolder
Resource_Type_EmailAccount
Resource_Type_Diagram
Resource_Type_Asset
Resource_Type_WorkFlow
Resource_Type_QuestionnaireScript
Resource_Type_TabulationScript
Resource_Type_LayoutTemplate
Resource_Type_Coding
Resource_Type_Task
Resource_Type_System
Resource_Type_DataCacheSpecification
Resource_Type_TaskSet
Resource_Type_PaperQuestionnaire
Resource_Type_SampleRequest
Resource_Type_BulkMail
Resource_Type_Function
Resource_Type_DCSExport
Resource_Type_TestCase
Resource_Type_BulkSms
</source>

=== Resource access constant ===

<source lang="sql">
RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR
</source>

=== Task constant ===

<source lang="sql">
TASK_RESOURCE_ID
TASK_CASE_NUMBER
TASK_NAME
TASK_PARENT_RESOURCE_ID
TASK_TEMPLATE_RESOURCE_ID
TASK_TIME_REGISTRATION
TASK_COMPLETED
TASK_TESTCASE
TASK_RESPONSIBLE_RESOURCE_ID
TASK_SUPERVISOR_RESOURCE_ID
TASK_OBSERVER
TASK_OBSERVER_INHERIT_ACCESS
TASK_STATUS
TASK_ACCEPTANCE_DEADLINE
TASK_COMPLETION_DEADLINE
TASK_APPROVAL_DEADLINE
TASK_ACTUAL_START_DATE
TASK_ACTUAL_END_DATE
TASK_APPROVED_DATE
TASK_MAN_HOURS
TASK_DESCRIPTION
</source>

=== Task status constant ===

<source lang="sql">
TASK_STATUS_NEEDACCEPTANCE
TASK_STATUS_INPROGRESS
TASK_STATUS_APPROVED
TASK_STATUS_AWAITINGAPPROVAL
</source>

=== User constant ===

<source lang="sql">
USER_RESOURCE_ID
USER_NAME
USER_TEMPLATE_RESOURCE_ID
USER_PASSWORD
USER_TIME_REGISTRATION
USER_MAN_HOURS
USER_CALCULATED_MAN_HOURS
USER_PHONE_NUMBER
USER_ACCESS_EXPIRATION
USER_PROTECTED_UNTIL
USER_LANGUAGE
USER_CULTURE
USER_EMAIL
USER_FIRST_NAME
USER_MIDDLE_NAME
USER_LAST_NAME
USER_CURRENCY
USER_DISCOUNT
USER_POINT_BALANCE
USER_TIMEZONE
USER_ADDRESS
USER_CITY
USER_ZIPCODE
USER_REGION
USER_COUNTRY
USER_POSTBOX
USER_WEBSITE
USER_DELETED
USER_DISABLED
USER_MASK
</source>

=== Questionnaire constant ===

<source lang="sql">
QUESTIONNAIRE_OBJECT_TYPE
QUESTIONNAIRE_RESOURCE_ID
QUESTIONNAIRE_NAME
QUESTIONNAIRE_RESOURCE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_PARENT_RESOURCE_ID
QUESTIONNAIRE_TEMPLATE_RESOURCE_ID
QUESTIONNAIRE_TIME_REGISTRATION
QUESTIONNAIRE_COMPLETED
QUESTIONNAIRE_DISPLAY_IN_MY_QUESTIONNAIRE
QUESTIONNAIRE_USE_OLD_VIEWER
QUESTIONNAIRE_ALIAS
QUESTIONNAIRE_LAYOUT_RESOURCE_ID
QUESTIONNAIRE_TIME_ESTIMATE
QUESTIONNAIRE_STATUS
QUESTIONNAIRE_TARGET
QUESTIONNAIRE_CATI_OUTCOME_SET
QUESTIONNAIRE_AUTOMATIC_RELEASE_DATE
QUESTIONNAIRE_DEVELOPMENT_START_DATE
QUESTIONNAIRE_AUTOMATIC_CLOSE_DATE
QUESTIONNAIRE_DEVELOPMENT_END_DATE
QUESTIONNAIRE_MAN_HOURS
QUESTIONNAIRE_DESCRIPTION
</source>

=== CATI CGS constant ===

<source lang="sql">
CATI_OBJECT_TYPE
CATI_CONTACT_ID
CATI_CONTACT_INTERVIEWER_USER_RESOURCE_ID
CATI_CONTACT_START_DATE
CATI_CONTACT_END_DATE
CATI_CONTACT_OUTCOME_STATUS_ID
CATI_CONTACT_OUTCOME_STATUS_AS_TEXT
CATI_CONTACT_DESCRIPTION
</source>

=== CATI list type constant ===

<source lang="sql">
CATI_MAIN
CATI_ONGOING
CATI_APPOINTMENT
CATI_FINISHED
CATI_RETRY
</source>

=== QAS constant ===

<source lang="sql">
QAS_OBJECT_TYPE
QAS_ID
QAS_QUESTIONNAIRE_RESOURCE_ID
QAS_USER_RESOURCE_ID
QAS_TEST
QAS_STATUS
QAS_COMPLETED
QAS_STARTDATE
QAS_ENDDATE
QAS_GUID
QAS_CATI_APPOINTMENT
QAS_CATI_LIST_TYPE
QAS_CATI_TIMES_CALLED
</source>

=== Project constant ===

<source lang="sql">
PROJECT_RESOURCE_ID
PROJECT_NAME
PROJECT_TEMPLATE_RESOURCE_ID
PROJECT_TIME_REGISTRATION
PROJECT_COMPLETED
PROJECT_PARENT_RESOURCE_ID
PROJECT_CODE
PROJECT_PROPOSE_CODE
PROJECT_CLIENT_REF_NO
PROJECT_TIME_BUDGET
PROJECT_CALCULATED_MAN_HOURS
PROJECT_PLANNED_START_DATE
PROJECT_ACTUAL_START_DATE
PROJECT_PLANNED_END_DATE
PROJECT_ACTUAL_END_DATE
</source>

=== Bulk mail constant ===

<source lang="sql">
BULKMAIL_OBJECT
BULKMAIL_NAME
BULKMAIL_PARENT_RESOURCE_ID
BULKMAIL_MAIL_TEMPLTE_ID
BULKMAIL_TEMPLATE_RESOURCE_ID
</source>

=== Group constant ===

<source lang="sql">
GROUP_RESOURCE_ID
GROUP_NAME
GROUP_TEMPLATE_RESOURCE_ID
GROUP_PARENT_RESOURCE_ID
GROUP_TIME_REGISTRATION
GROUP_MAN_HOURS
GROUP_CALCULATED_MAN_HOURS
</source>

=== Folder constant ===

<source lang="sql">
FOLDER_RESOURCE_ID
FOLDER_NAME
FOLDER_PARENT_RESOURCE_ID
FOLDER_TEMPLATE_RESOURCE_ID
FOLDER_TIME_REGISTRATION
FOLDER_TIME_BUDGET
FOLDER_MAN_HOURS
FOLDER_DESCRIPTION
</source>

=== Data cache - custom column constant ===

<source lang="sql">
CUSTOM_COLUMN_TYPE_NUMBER
CUSTOM_COLUMN_TYPE_BOOLEAN
CUSTOM_COLUMN_TYPE_STRING
CUSTOM_COLUMN_DATA_TYPE
CUSTOM_COLUMN_TEXT
CUSTOM_COLUMN_NAME
CUSTOM_COLUMN_OPTIONS
CUSTOM_COLUMN_OPTION_EXPRESSION
CUSTOM_COLUMN_OPTION_VALUE
CUSTOM_COLUMN_OPTION_TEXT
</source>

=== Ledger entry constant ===

<source lang="sql">
LEDGER_ENTRY_ID
LEDGER_RESOURCE_ID
LEDGER_ENTRY_NAME
LEDGER_ENTRY_DESCRIPTION
LEDGER_ENTRY_UNIT
LEDGER_ENTRY_COST
LEDGER_ENTRY_CURRENCY_ID
LEDGER_ENTRY_EXCHANGE_RATE
LEDGER_ENTRY_AMOUNT_SELECTED_CURRENCY
LEDGER_ENTRY_AMOUNT_DEFAULT_CURRENCY
</source>

=== Invoice constant ===

<source lang="sql">
INVOICE_RESOURCE_ID
INVOICE_PART
INVOICE_PARENT_RESOURCE_ID
INVOICE_TEMPLATE_RESOURCE_ID
INVOICE_SUBMITTED
INVOICE_REVENUE_TYPE
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
INVOICE_ADDRESS_TO
INVOICE_EARNER
INVOICE_REFERENCE
INVOICE_INVOICE_DATE
INVOICE_DUE_DATE
INVOICE_PAID_DATE
INVOICE_SUBMITTED_DATE
INVOICE_LEDGER
INVOICE_TOTAL
// Address to constant
INVOICE_CUSTOMER
INVOICE_REPRESENTATIVE
</source>

=== Diagrams constants ===

<source lang="sql">
Diagram_ShowModeType_Percentage
Diagram_ShowModeType_Absolute
Diagram_ShowModeType_Both
Diagram_ChartType_Table
Diagram_ChartType_Line
Diagram_ChartType_Bar
Diagram_ChartType_Pie
Diagram_ChartType_Radar
// Direction Type
Diagram_DirectionType_Vertical
Diagram_DirectionType_Horizontal
// Back Plane Style
Diagram_BackPlaneStyle_Rectangle
Diagram_BackPlaneStyle_Ellipse
Diagram_BackPlaneStyle_Circle
Diagram_BackPlaneStyle_CutEdgeRectangle
Diagram_BackPlaneStyle_SmoothEdgeRectangle
Diagram_BackPlaneStyle_NotSet
// Fill Type
Diagram_FillType_NoFill
Diagram_FillType_SolidFill
// HAlignment
Diagram_HAlignment_Center
Diagram_HAlignment_Left
Diagram_HAlignment_Right
Diagram_HAlignment_NotSet
// VAlignment
Diagram_VAlignment_Center
Diagram_VAlignment_Top
Diagram_VAlignment_Bottom
Diagram_VAlignment_NotSet
// Visibility
Diagram_Visibility_True
Diagram_Visibility_Visible
Diagram_Visibility_NotVisible
Diagram_Visibility_False
Diagram_Visibility_NotSet
// Fill constant
DIAGRAM_FILL_STYLE_COLOR
DIAGRAM_FILL_STYLE_TYPE
DIAGRAM_FILL_STYLE_INHERIT
// Font constant
DIAGRAM_FONT_STYLE_FACE
DIAGRAM_FONT_STYLE_SIZE
DIAGRAM_FONT_STYLE_COLOR
DIAGRAM_FONT_STYLE_BOLD
DIAGRAM_FONT_STYLE_ITALIC
DIAGRAM_FONT_STYLE_UNDERLINE
DIAGRAM_FONT_STYLE_INHERIT
</source>

=== Diagrams Known Color constants ===

<source lang="sql">
Diagram_KnownColor_ActiveBorder
Diagram_KnownColor_ActiveCaption
Diagram_KnownColor_ActiveCaptionText
Diagram_KnownColor_AppWorkspace
Diagram_KnownColor_Control
Diagram_KnownColor_ControlDark
Diagram_KnownColor_ControlDarkDark
Diagram_KnownColor_ControlLight
Diagram_KnownColor_ControlLightLight
Diagram_KnownColor_ControlText
Diagram_KnownColor_Desktop
Diagram_KnownColor_GrayText
Diagram_KnownColor_Highlight
Diagram_KnownColor_HighlightText
Diagram_KnownColor_HotTrack
Diagram_KnownColor_InactiveBorder
Diagram_KnownColor_InactiveCaption
Diagram_KnownColor_InactiveCaptionText
Diagram_KnownColor_Info
Diagram_KnownColor_InfoText
Diagram_KnownColor_Menu
Diagram_KnownColor_MenuText
Diagram_KnownColor_ScrollBar
Diagram_KnownColor_Window
Diagram_KnownColor_WindowFrame
Diagram_KnownColor_WindowText
Diagram_KnownColor_Transparent
Diagram_KnownColor_AliceBlue
Diagram_KnownColor_AntiqueWhite
Diagram_KnownColor_Aqua
Diagram_KnownColor_Aquamarine
Diagram_KnownColor_Azure
Diagram_KnownColor_Beige
Diagram_KnownColor_Bisque
Diagram_KnownColor_Black
Diagram_KnownColor_BlanchedAlmond
Diagram_KnownColor_Blue
Diagram_KnownColor_BlueViolet
Diagram_KnownColor_Brown
Diagram_KnownColor_BurlyWood
Diagram_KnownColor_CadetBlue
Diagram_KnownColor_Chartreuse
Diagram_KnownColor_Chocolate
Diagram_KnownColor_Coral
Diagram_KnownColor_CornflowerBlue
Diagram_KnownColor_Cornsilk
Diagram_KnownColor_Crimson
Diagram_KnownColor_Cyan
Diagram_KnownColor_DarkBlue
Diagram_KnownColor_DarkCyan
Diagram_KnownColor_DarkGoldenrod
Diagram_KnownColor_DarkGray
Diagram_KnownColor_DarkGreen
Diagram_KnownColor_DarkKhaki
Diagram_KnownColor_DarkMagenta
Diagram_KnownColor_DarkOliveGreen
Diagram_KnownColor_DarkOrange
Diagram_KnownColor_DarkOrchid
Diagram_KnownColor_DarkRed
Diagram_KnownColor_DarkSalmon
Diagram_KnownColor_DarkSeaGreen
Diagram_KnownColor_DarkSlateBlue
Diagram_KnownColor_DarkSlateGray
Diagram_KnownColor_DarkTurquoise
Diagram_KnownColor_DarkViolet
Diagram_KnownColor_DeepPink
Diagram_KnownColor_DeepSkyBlue
Diagram_KnownColor_DimGray
Diagram_KnownColor_DodgerBlue
Diagram_KnownColor_Firebrick
Diagram_KnownColor_FloralWhite
Diagram_KnownColor_ForestGreen
Diagram_KnownColor_Fuchsia
Diagram_KnownColor_Gainsboro
Diagram_KnownColor_GhostWhite
Diagram_KnownColor_Gold
Diagram_KnownColor_Goldenrod
Diagram_KnownColor_Gray
Diagram_KnownColor_Green
Diagram_KnownColor_GreenYellow
Diagram_KnownColor_Honeydew
Diagram_KnownColor_HotPink
Diagram_KnownColor_IndianRed
Diagram_KnownColor_Indigo
Diagram_KnownColor_Ivory
Diagram_KnownColor_Khaki
Diagram_KnownColor_Lavender
Diagram_KnownColor_LavenderBlush
Diagram_KnownColor_LawnGreen
Diagram_KnownColor_LemonChiffon
Diagram_KnownColor_LightBlue
Diagram_KnownColor_LightCoral
Diagram_KnownColor_LightCyan
Diagram_KnownColor_LightGoldenrodYellow
Diagram_KnownColor_LightGray
Diagram_KnownColor_LightGreen
Diagram_KnownColor_LightPink
Diagram_KnownColor_LightSalmon
Diagram_KnownColor_LightSeaGreen
Diagram_KnownColor_LightSkyBlue
Diagram_KnownColor_LightSlateGray
Diagram_KnownColor_LightSteelBlue
Diagram_KnownColor_LightYellow
Diagram_KnownColor_Lime
Diagram_KnownColor_LimeGreen
Diagram_KnownColor_Linen
Diagram_KnownColor_Magenta
Diagram_KnownColor_Maroon
Diagram_KnownColor_MediumAquamarine
Diagram_KnownColor_MediumBlue
Diagram_KnownColor_MediumOrchid
Diagram_KnownColor_MediumPurple
Diagram_KnownColor_MediumSeaGreen
Diagram_KnownColor_MediumSlateBlue
Diagram_KnownColor_MediumSpringGreen
Diagram_KnownColor_MediumTurquoise
Diagram_KnownColor_MediumVioletRed
Diagram_KnownColor_MidnightBlue
Diagram_KnownColor_MintCream
Diagram_KnownColor_MistyRose
Diagram_KnownColor_Moccasin
Diagram_KnownColor_NavajoWhite
Diagram_KnownColor_Navy
Diagram_KnownColor_OldLace
Diagram_KnownColor_Olive
Diagram_KnownColor_OliveDrab
Diagram_KnownColor_Orange
Diagram_KnownColor_OrangeRed
Diagram_KnownColor_Orchid
Diagram_KnownColor_PaleGoldenrod
Diagram_KnownColor_PaleGreen
Diagram_KnownColor_PaleTurquoise
Diagram_KnownColor_PaleVioletRed
Diagram_KnownColor_PapayaWhip
Diagram_KnownColor_PeachPuff
Diagram_KnownColor_Peru
Diagram_KnownColor_Pink
Diagram_KnownColor_Plum
Diagram_KnownColor_PowderBlue
Diagram_KnownColor_Purple
Diagram_KnownColor_Red
Diagram_KnownColor_RosyBrown
Diagram_KnownColor_RoyalBlue
Diagram_KnownColor_SaddleBrown
Diagram_KnownColor_Salmon
Diagram_KnownColor_SandyBrown
Diagram_KnownColor_SeaGreen
Diagram_KnownColor_SeaShell
Diagram_KnownColor_Sienna
Diagram_KnownColor_Silver
Diagram_KnownColor_SkyBlue
Diagram_KnownColor_SlateBlue
Diagram_KnownColor_SlateGray
Diagram_KnownColor_Snow
Diagram_KnownColor_SpringGreen
Diagram_KnownColor_SteelBlue
Diagram_KnownColor_Tan
Diagram_KnownColor_Teal
Diagram_KnownColor_Thistle
Diagram_KnownColor_Tomato
Diagram_KnownColor_Turquoise
Diagram_KnownColor_Violet
Diagram_KnownColor_Wheat
Diagram_KnownColor_White
Diagram_KnownColor_WhiteSmoke
Diagram_KnownColor_Yellow
Diagram_KnownColor_YellowGreen
Diagram_KnownColor_ButtonFace
Diagram_KnownColor_ButtonHighlight
Diagram_KnownColor_ButtonShadow
Diagram_KnownColor_GradientActiveCaption
Diagram_KnownColor_GradientInactiveCaption
Diagram_KnownColor_MenuBar
Diagram_KnownColor_MenuHighlight
</source>

=== Table Diagram constants ===

<source lang="sql">
TableDiagram_AllTable
TableDiagram_ColumnHeader
TableDiagram_ColumnHeaderLevel1
TableDiagram_ColumnHeaderLevel2
TableDiagram_ColumnHeaderLevel3
TableDiagram_RowHeader
TableDiagram_RowHeaderLevel1
TableDiagram_RowHeaderLevel2
TableDiagram_RowHeaderLevel3
TableDiagram_AbsoluteColumn
TableDiagram_AbsoluteColumnHeader
TableDiagram_AbsoluteColumnValue
TableDiagram_PercentageColumn
TableDiagram_PercentageColumnHeader
TableDiagram_PercentageColumnValue
TableDiagram_TotalColumn
TableDiagram_TotalColumnHeader
TableDiagram_TotalColumnValue
TableDiagram_TotalRow
TableDiagram_TotalRowHeader
TableDiagram_TotalRowValue
TableDiagram_AnswerRow
TableDiagram_AnswerRowAlternate
TableDiagram_VarianceRow
TableDiagram_VarianceRowHeader
TableDiagram_VarianceRowValue
TableDiagram_AverageRow
TableDiagram_AverageRowHeader
TableDiagram_AverageRowValue
TableDiagram_StdDevRow
TableDiagram_StdDevRowHeader
TableDiagram_StdDevRowValue
TableDiagram_StdErrorRow
TableDiagram_StdErrorRowHeader
TableDiagram_StdErrorRowValue
TableDiagram_MedianRow
TableDiagram_MedianRowHeader
TableDiagram_MedianRowValue
TableDiagram_QuantilesRow
TableDiagram_QuantilesRowHeader
TableDiagram_QuantilesRowValue
TableDiagram_PercentileRow
TableDiagram_PercentileRowHeader
TableDiagram_PercentileRowValue
TableDiagram_SignificanceRow
TableDiagram_SignificanceRowHeader
TableDiagram_SignificanceRowValue
TableDiagram_CountAnswerRow
TableDiagram_CountAnswerRowHeader
TableDiagram_CountAnswerRowValue
TableDiagram_TotalRespondentRow
TableDiagram_TotalRespondentRowHeader
TableDiagram_TotalRespondentRowValue
TableDiagram_WeightRow
TableDiagram_WeightRowHeader
TableDiagram_WeightRowValue
TableDiagram_QuestionHeader
</source>

=== Table Diagram style constants ===

<source lang="sql">
TABLE_DIAGRAM_STYLE_FILL,
TABLE_DIAGRAM_STYLE_DECIMAL
TABLE_DIAGRAM_STYLE_FONT
TABLE_DIAGRAM_STYLE_VALIGN
TABLE_DIAGRAM_STYLE_HALIGN
TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER
TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER
TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER
TABLE_DIAGRAM_STYLE_BORDER_STYLE
</source> Back to [[DATA]] page

[[Category:Functions]]

SetPhoneNumber

2017-06-05T08:06:29Z

Tungocman:

{{HelpFiles}}

<h4> setPhoneNumber </h4>
Sets the phone number of the current questionnaire answer sheet’s user
Syntax
setPhoneNumber(phone_number_type, new_phone_number, country_code)
Arguments
phone_number_type. Is a numeric (non-decimal) expression. It must be one of the built-in constants:
PhoneNumber_Type_NotIdentified,
PhoneNumber_Type_Home1,
PhoneNumber_Type_Home2,
PhoneNumber_Type_Mobile1,
PhoneNumber_Type_Mobile2,
PhoneNumber_Type_Business1,
PhoneNumber_Type_Business2,
PhoneNumber_Type_HomeFax,
PhoneNumber_Type_BusinessFax
new_phone_number: Is a string expression
country_code: Is a numeric (non-decimal) expression.
Return type
empty
Examples
setPhoneNumber(PhoneNumber_Type_Home1, "212277", 358);
Availability
Version 4.8 

[[Category:General_Functions]]

SetPhoneNumber

2017-06-05T08:05:50Z

Tungocman:

SelectMultiColumn

2017-06-05T08:04:45Z

Tungocman:

==== selectMultiColumn ====

Returns an array of row values for a column.

'''Syntax'''

selectMultiColumn(''columnName'')

'''Arguments'''

''columnName:'' Is the name of a column in the data table.

'''Return type'''

array

'''Examples'''

''//print all Id and UserId to the console''

''print(selectMultiColumn(Id,UserId) where (true));''

''//result: {{1,111},{2,112},{3,113},{4,114}}''

'''Availability'''

Version 5.8 __NOTOC__
[[Category:Functions_Used_in_where_Expressions]]

Replacement tags

2017-06-05T08:03:34Z

Tungocman:

=== Replacement tags ===

__NOTOC__
There exists a tag system which makes it possible for us, to insert replacement values directly in texts (question, subquestion, answer option) without using text replacement conditions. These tags are replaced by the answer the respondent gave in an earlier question of the same questionnaire.

An example could be:

''<nowiki>”You have answered that your favorite soft drink is {{FavoriteSoftdrink.Text}}.”</nowiki>''

Which could result in a text like:

''”You have answered that your favorite soft drink is Cherry Coke”''

The logic for text replacement tags are as follows:

Q_Label should in the following be replaced by the question that replacement texts are to be collected from. How the replacement tags are to be used depends on which question type the tag refers to. Examples of all are presented below:

==== '''Single''' ====

<nowiki>{{Q_label}}: is replaced with the text of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label.value}}: is replaced with the value of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label.text}}: is replaced with the text of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label.openvalue}}: is replaced with the open text part of the respondent's chosen answer option (if such a value exists)</nowiki>

<nowiki>{{Q_label.index}}: is replaced with the index of the respondent's chosen answer option</nowiki>

==== '''Multi''' ====

<nowiki>{{Q_label[AnswerOption_index]}}: is replaced with the text of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label[AnswerOption_index].value}}: is replaced with the value of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label[AnswerOption_index].text}}: is replaced with the text of the respondent's chosen answer option</nowiki>

<nowiki>{{Q_label[AnswerOption_index].openvalue}}: is replaced with the open text part of the respondent's chosen answer option (if such a value exists)</nowiki>

<nowiki>{{Q_label[AnswerOption_index].index}}: is replaced with the index of the respondent's chosen answer option</nowiki>

==== '''Single Grid''' ====

<nowiki>{{Q_label[grid_index]}}: is replaced with the text of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index].value}}: is replaced with the value of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index].text}}: is replaced with the text of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index].index}}: is replaced with the index of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>** grid_index should be replaced with the index of the subquestion the users wants the text replacement based on. The first subquestion is always indexed with 0, next one is 1 and so on.</nowiki>

==== Multi Grid ====

<nowiki>{{Q_label[grid_index][AnswerOption_index]}}: is replaced with the text of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index][AnswerOption_index].value}}: is replaced with the value of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index][AnswerOption_index].text}}: is replaced with the text of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>{{Q_label[grid_index][AnswerOption_index].index}}: is replaced with the index of the respondent's chosen answer option on the specified sub question</nowiki>

<nowiki>** grid_index should be replaced with the index of the subquestion the users wants the text replacement based on. The first subquestion is always indexed with 0, next one is 1 and so on.</nowiki>

==== '''Text, Open, Multimedia, Scale, Numeric''' ====

<nowiki>{{Q_label}}: is replaced with the respondent's actual answer</nowiki>

==== '''Open - closed answer''' ====

<nowiki>{{Q_label[option_index]}}: return true/false, get status checked of closed answer options</nowiki>

==== '''Scale Grid, Text Grid''' ====

<nowiki>{{Q_label[grid_index]}}: is replaced with the respondent's actual answer to the specified sub question</nowiki>

==== '''CGScript''' ====

<nowiki>{{Script;}}: CGScript can also be run in text by placing them in the {{}} brackets. </nowiki>
[[Category:Questionnaire_module]]

PhoneNumber isValid

2017-06-05T08:02:09Z

Tungocman:

{{HelpFiles}}

==== PhoneNumber_isValid ====

Validate a phone number. returns true if the phone number is valid, otherwise return false

'''Syntax'''

PhoneNumber_isValid(phoneNumber, countryCode, phonenumberType)

'''Arguments'''

''phoneNumber'': Is a string expression which is a phone number.

''countryCode'': Is a number expression which is a country Code.

''phonenumberType'': Is a numeric (non-decimal) expression.

{| border="1"
|-
! '''RESOURCE'''
! '''LAND LINE'''
! '''MOBILE'''
|-
| rowspan="7" | '''USER'''
| NotIdentified = 0
|
|-
| Home1 = 1
| Mobile1 = 3
|-
| Home2 = 2
| Mobile2 = 4
|-
| Business1 = 5
|
|-
| Business2 = 6
|
|-
| HomeFax = 7
|
|-
| BusinessFax =8
|
|-
| rowspan="4" | '''GROUP'''
| Main1 = 9
|
|-
| Main2 = 10
|
|-
| Fax1 = 11
|
|-
| Fax2 = 12
|
|}

'''Return type'''

bool

'''Example''' <source lang="javascript">
string phoneNumber = "22222222";
number countryCode = 45;
number phonenumberType = 0;
bool b =PhoneNumber_isValid(phoneNumber,countryCode,phonenumberType);
print(b);
</source>
[[Category:General_Functions]]

Tabulation getAvailableFonts

2017-06-05T07:59:39Z

Tungocman:

{{HelpFiles}}

=== Tabulation_getAvailableFonts ===

To find available fonts.

=== Syntax ===

Tabulation_getAvailableFonts();

=== Return type ===

return a list of font names.

=== Examples ===

<source lang="javascript">
print(Tabulation_getAvailableFonts());
//result:
{Agency FB,Aharoni,Algerian,Andalus,Angsana New,AngsanaUPC,Aparajita,Arabic Typesetting,Arial,Arial Black,Arial Narrow,Arial Rounded MT Bold,Arial Unicode MS,Vladimir Script,Vrinda,Webdings,Wide Latin,Wingdings}
</source> __NOTOC__
[[Category:Using CGScript with the Tabulation Module]]

Tabulation setTotalAnswerText

2017-06-05T07:58:00Z

Tungocman:

{{HelpFiles}}

=== Tabulation_setTotalAnswerText ===

Set the text for the total answers row, which is one of the statistical rows that can be shown for tables. If this function is not used then the label for the row will just be the default value "Total answers".

'''Syntax'''

Tabulation_setTotalAnswersText(text)

'''Arguments'''

*text: is string

'''Return value'''

empty

'''Example'''

''Tabulation_setCountAnswer(true);''

''createFrequenceDiagram("Multi");''

''//Result:''

[[File:GetTotalAnswerText-Multi.jpg]]

''Tabulation_setTotalAnswerText("Total answers text");''

''createFrequenceDiagram("Multi");''

''//Result:''

[[File:SetTotalAnswerText.jpg]]

{{note}}

This script should be paired with script [[Tabulation setCountAnswer]].

'''Availability'''

Version 5.8.1
[[Category:Text_setting_functions]]

Tabulation getTotalColumnVisibility

2017-06-05T07:56:08Z

Tungocman:

== Tabulation_getTotalColumnVisibility ==

Return variable true/false equivalent Show/hide the total column.

'''Syntax'''

Tabulation_getTotalColumnVisibility();

'''Return type'''

Boolean

'''Examples'''

''Tabulation_setTotalColumnVisibility(false);' print(Tabulation_getTotalColumnVisibility()); // Result: False''

''Tabulation_setTotalColumnVisibility(true);' print(Tabulation_getTotalColumnVisibility()); // Result: True''

'''Availability'''

Version 5.8

[[Category:Using CGScript with the Tabulation Module]]

Tabulation getStartingPageNumber

2017-06-05T07:55:36Z

Tungocman:

{{HelpFiles}}

==== Tabulation_getStartingPageNumber ====

Sets the starting page number for the pdf report

'''Syntax'''

Tabulation_setStartingPageNumber()

'''Arguments'''

none

'''Return value'''

''number'' start page number

{{note}} ''This function should be paired with function [http://wiki.catglobe.com/index.php/Tabulation_setShowResultAsPdf Tabulation_setShowResultAsPdf].''

'''Availability'''

 Version 6.0
[[Category:Using CGScript with the Tabulation Module]]

Tabulation setStartingPageNumber

2017-06-05T07:54:26Z

Tungocman:

{{HelpFiles}}

==== Tabulation_setStartingPageNumber ====

Set the starting page number for the PDF report.

'''Syntax'''

Tabulation_setStartingPageNumber(''8'')

'''Arguments''' int pagenumber

=== '''Examples''' ===

<source lang="javascript">

//Starting page number of the PDF report can be set:
//Needs a DCS

Tabulation_setStartingPageNumber(8);
</source>

 {{note}} ''This function should be paired with function [http://wiki.catglobe.com/index.php/Tabulation_setShowResultAsPdf Tabulation_setShowResultAsPdf].''
''The pagenumber can be shown in the pdf by inserting $p in a paragraph. $P (capital P) shows the total number of pages.

'''Availability'''

Version 6.0
[[Category:Using CGScript with the Tabulation Module]]

Tabulation setExcludedSortOrderHorizontal

2017-06-05T07:53:37Z

Tungocman:

=== Tabulation_setExcludedSortOrderHorizontal ===
Exclude some axis options from the the horizontal sorting

=== Syntax ===

Tabulation_setExcludedSortOrderHorizontal(axisArray);

=== Arguments ===

axisArray: an array which contains some axis options that will be excluded from the the horizontal sorting

=== Return type ===

empty

=== Examples ===

DCS_use(15560370);

Tabulation_setExcludedSortOrderHorizontal({"Viet Nam","Don't know"});

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHigh);

createCrossDiagram({"Q1"},{"Q1_Single"});

//result: 
[[File:SetExcludedHorizontal.jpg]]
__NOTOC__
[[Category:Using CGScript with the Tabulation Module]]

Tabulation addPagebreak

2017-06-05T07:50:17Z

Tungocman:

{{HelpFiles}}

=== Tabulation_addPagebreak ===

Insert a page break

=== Syntax ===

Tabulation_addPagebreak();

=== Return type ===

Empty.

=== Examples ===

<source lang="javascript">
Tabulation_addParagraph(new TabulationParagraph(paragraphStyle,"Page 1",textStyle));
createCrossDiagram({"Q0"}, {"PB_Gender"});
Tabulation_addPagebreak();
Tabulation_addParagraph(new TabulationParagraph(paragraphStyle,"Page 2",textStyle));
createCrossDiagram({"Q0"}, {"PB_Region"});
</source> __NOTOC__

//Result: [[File:AddPagebreak1.jpg]]

[[File:AddPagebreak2.jpg]]
[[Category:Using CGScript with the Tabulation Module]]

Tabulation addPagebreak

2017-06-05T07:49:42Z

Tungocman:

{{HelpFiles}}

=== Tabulation_addPagebreak ===

Insert a page break

=== Syntax ===

Tabulation_addPagebreak();

=== Return type ===

Empty.

=== Examples ===

<source lang="javascript">
Tabulation_addParagraph(new TabulationParagraph(paragraphStyle,"Page 1",textStyle));
createCrossDiagram({"Q0"}, {"PB_Gender"});
Tabulation_addPagebreak();
Tabulation_addParagraph(new TabulationParagraph(paragraphStyle,"Page 2",textStyle));
createCrossDiagram({"Q0"}, {"PB_Region"});
</source> __NOTOC__

//Result: [[File:AddPagebreak1.jpg]]

[[File:AddPagebreak2.jpg]]
[Category:Using CGScript with the Tabulation Module]

CreateStackCrossDiagram

2017-01-24T09:29:36Z

Tungocman:

__NOTOC__
[[Category:Diagram/report_generating_CGScript_functions]]
Creates a stack cross diagram from the axis names specified as string arrays for rows and columns. A unique id is returned when a diagram is added.

==Syntax ==

createStackCrossDiagram(rowAxisNames, {columnAxisNames});

==Arguments==

rowAxisNames: An array expression. This array contains the names of the axes which are used for the rows in the stack cross diagram;

columnAxisNames: An array expression. This array contains the names of the axes which are used for the columns in the stack cross diagram.

{{note}}A limit of 2 rows and 2 columns is set at the moment. If an array (rowAxisNames or columnAxisNames) containing two axes, We will have multi-level diagrams.

==Return type==

number;

==Examples==

<source lang="javascript">
DCS_use(15321022);
number table1 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{"QA2a_Januar","D_QA4"}});
print(table1); //Result: 1
number table2 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{"QA2a_Januar"},{"D_QA4"}});
print(table2); //Result: 2
number table3 = createStackCrossDiagram({}, {{"QA2a_Januar","D_QA4"}});
print(table3); //Result: 3
number table4 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{}});
print(table4); //Result: 4
</source> Result:

[[File:StackCrossDiagramFn.jpg]]

CreateStackCrossDiagram

2017-01-24T09:28:44Z

Tungocman:

__NOTOC__
[[Category:Diagram/report_generating_CGScript_functions]]
=createStackCrossDiagram=

Creates a stack cross diagram from the axis names specified as string arrays for rows and columns. A unique id is returned when a diagram is added.

==Syntax ==

createStackCrossDiagram(rowAxisNames, {columnAxisNames});

==Arguments==

rowAxisNames: An array expression. This array contains the names of the axes which are used for the rows in the stack cross diagram;

columnAxisNames: An array expression. This array contains the names of the axes which are used for the columns in the stack cross diagram.

{{note}}A limit of 2 rows and 2 columns is set at the moment. If an array (rowAxisNames or columnAxisNames) containing two axes, We will have multi-level diagrams.

==Return type==

number;

==Examples==

<source lang="javascript">
DCS_use(15321022);
number table1 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{"QA2a_Januar","D_QA4"}});
print(table1); //Result: 1
number table2 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{"QA2a_Januar"},{"D_QA4"}});
print(table2); //Result: 2
number table3 = createStackCrossDiagram({}, {{"QA2a_Januar","D_QA4"}});
print(table3); //Result: 3
number table4 = createStackCrossDiagram({"QA1","D_Age_Group"}, {{}});
print(table4); //Result: 4
</source> Result:

[[File:StackCrossDiagramFn.jpg]]

User:Tungocman

2016-12-15T04:52:09Z

Tungocman:

{{Getting Started Guide}}
=Man Tu's Wall=
Email: Man@Maysunshine.vn

==My Working Pages==
*[[:Category:Getting_Started_Guide]] and its rediect pages: [[Getting_Started_Guide]] and [[Quick_Start_Guide]]
*[[Exception_Handling]]
*[[Release_Notes_version_595]]
*[[Release_Notes_version_6.0]]

==My Templates==
*[[Template:CGscriptClass_Template]]
*[[Template:CGscriptConstructors_Template]]
*[[Template:CGscriptMethods_Template]]
*[[Template:CGscriptParameters_Template]]
*[[Template:CGscriptTypeColors_Template]]
*[[Template:Documentation|Template:Documentation]] (Documentation template for templates)
*[[Template:Cquote]] (Center quote)
*[[Template:TOC]]
*[[Template:Sidebar]]
*[[Template:Sidebar with collapsible lists]]

User:Tungocman

2016-12-15T04:51:46Z

Tungocman: /* My Favorite Pages */

{{Getting Started Guide}}
=Man Tu's Wall=
Email: Man@Maysunshine.vn

==My Working Pages==
*[[:Category:Getting_Started_Guide]] and its rediect pages: [[Getting_Started_Guide]] and [[Quick_Start_Guide]]
*[[Exception_Handling]]
*[[Release_Notes_version_595]]
*[[Release_Notes_version_6.0]]

==My Favorite Pages==

==My Templates==
*[[Template:CGscriptClass_Template]]
*[[Template:CGscriptConstructors_Template]]
*[[Template:CGscriptMethods_Template]]
*[[Template:CGscriptParameters_Template]]
*[[Template:CGscriptTypeColors_Template]]
*[[Template:Documentation|Template:Documentation]] (Documentation template for templates)
*[[Template:Cquote]] (Center quote)
*[[Template:TOC]]
*[[Template:Sidebar]]
*[[Template:Sidebar with collapsible lists]]