Difference between revisions of "CGS Constants list"

From Catglobe Wiki
Jump to: navigation, search
(Diagrams constants)
 
(31 intermediate revisions by 4 users not shown)
Line 1: Line 1:
=== Search type constants ===  
+
= CGScript Constants List =
 +
 
 +
=== Search type constants ===
 +
 
 
<source lang="sql">
 
<source lang="sql">
 
NAME_SEARCH_TYPE_ANYWHERE
 
NAME_SEARCH_TYPE_ANYWHERE
Line 7: Line 10:
 
</source>
 
</source>
  
 +
=== Resource access constant ===
 +
 +
<source lang="sql">
 +
RESOURCE_ACCESS_OBSERVER
 +
RESOURCE_ACCESS_MANAGER
 +
RESOURCE_ACCESS_ADMINISTRATOR
 +
</source>
 +
 +
=== Resource type constant ===
  
=== Resource type constant ===
 
 
<source lang="sql">
 
<source lang="sql">
 
Resource_Type_ResourceTemplate
 
Resource_Type_ResourceTemplate
Line 46: Line 57:
 
</source>
 
</source>
  
=== Resource access constant ===  
+
=== Resource access constant ===
 +
 
 
<source lang="sql">
 
<source lang="sql">
 
RESOURCE_ACCESS_OBSERVER
 
RESOURCE_ACCESS_OBSERVER
Line 53: Line 65:
 
</source>
 
</source>
  
=== Diagrams constants ===  
+
=== 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>
 +
 
 +
=== QuestionnaireStatus constant ===
 +
<source lang="sql">
 +
QUESTIONNAIRE_STATUS_CLOSED: 1
 +
QUESTIONNAIRE_STATUS_PAUSED: 2
 +
QUESTIONNAIRE_STATUS_ACTIVE: 3
 +
QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4
 +
</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">
 
<source lang="sql">
 
Diagram_ShowModeType_Percentage
 
Diagram_ShowModeType_Percentage
Line 63: Line 331:
 
Diagram_ChartType_Pie
 
Diagram_ChartType_Pie
 
Diagram_ChartType_Radar
 
Diagram_ChartType_Radar
--*** Direction Type
+
// Direction Type
 
Diagram_DirectionType_Vertical
 
Diagram_DirectionType_Vertical
 
Diagram_DirectionType_Horizontal
 
Diagram_DirectionType_Horizontal
--*** Back Plane Style
+
// Back Plane Style
 
Diagram_BackPlaneStyle_Rectangle
 
Diagram_BackPlaneStyle_Rectangle
 
Diagram_BackPlaneStyle_Ellipse
 
Diagram_BackPlaneStyle_Ellipse
Line 73: Line 341:
 
Diagram_BackPlaneStyle_SmoothEdgeRectangle
 
Diagram_BackPlaneStyle_SmoothEdgeRectangle
 
Diagram_BackPlaneStyle_NotSet
 
Diagram_BackPlaneStyle_NotSet
= Fill Type =
+
// 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>
 
</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><br/>Back to [[DATA]] page
  
Back to [[DATA]] page
+
[[Category:Functions]]

Latest revision as of 05:23, 18 March 2022

CGScript Constants List

Search type constants

NAME_SEARCH_TYPE_ANYWHERE
NAME_SEARCH_TYPE_END
NAME_SEARCH_TYPE_IDENTICAL
NAME_SEARCH_TYPE_START

Resource access constant

RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR

Resource type constant

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

Resource access constant

RESOURCE_ACCESS_OBSERVER
RESOURCE_ACCESS_MANAGER
RESOURCE_ACCESS_ADMINISTRATOR

Task constant

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

Task status constant

TASK_STATUS_NEEDACCEPTANCE
TASK_STATUS_INPROGRESS
TASK_STATUS_APPROVED
TASK_STATUS_AWAITINGAPPROVAL

User constant

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

Questionnaire constant

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

QuestionnaireStatus constant

QUESTIONNAIRE_STATUS_CLOSED: 1
QUESTIONNAIRE_STATUS_PAUSED: 2
QUESTIONNAIRE_STATUS_ACTIVE: 3
QUESTIONNAIRE_STATUS_OPEN_FOR_TEST: 4

CATI CGS constant

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

CATI list type constant

CATI_MAIN
CATI_ONGOING
CATI_APPOINTMENT 
CATI_FINISHED 
CATI_RETRY

QAS constant

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

Project constant

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

Bulk mail constant

BULKMAIL_OBJECT
BULKMAIL_NAME
BULKMAIL_PARENT_RESOURCE_ID
BULKMAIL_MAIL_TEMPLTE_ID
BULKMAIL_TEMPLATE_RESOURCE_ID

Group constant

GROUP_RESOURCE_ID
GROUP_NAME
GROUP_TEMPLATE_RESOURCE_ID
GROUP_PARENT_RESOURCE_ID
GROUP_TIME_REGISTRATION
GROUP_MAN_HOURS
GROUP_CALCULATED_MAN_HOURS

Folder constant

FOLDER_RESOURCE_ID
FOLDER_NAME
FOLDER_PARENT_RESOURCE_ID
FOLDER_TEMPLATE_RESOURCE_ID
FOLDER_TIME_REGISTRATION
FOLDER_TIME_BUDGET
FOLDER_MAN_HOURS
FOLDER_DESCRIPTION

Data cache - custom column constant

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

Ledger entry constant

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

Invoice constant

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

Diagrams constants

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

Diagrams Known Color constants

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

Table Diagram constants

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

Table Diagram style constants

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


Back to DATA page