Forsta logo Forsta Plus // Docs

SOAP API Docs

    • Forsta Plus XML SOAP Web Services
      • LogOn
        • Methods
          • LogOnUser
      • Authoring (deprecated)
        • Methods
          • AddProject
          • DeleteQuestionnaire
          • DeleteRouting
          • DeleteProject
          • DuplicateProject
          • ExportSurvey
          • ExportSurveyLayout
          • ExportSurveyWithHTMLRemoved
          • ExportSurvey
          • ExportWeightModel
          • ExportWeightModels
          • ExportTranslation
          • GetBenchmarkProjectIds
          • GetConditionBranch
          • GetCustomProjectInfoField
          • GetDatabaseLastCompiled
          • GetExternalAnswers
          • GetFilteredQuestionnaire
          • GetForm
          • GetFormByName
          • GetFormsInLoop
          • GetLoopStructure
          • GetNode
          • GetNodes
          • GetPredefinedList
          • GetPredefinedLists
          • GetProjectEmailObjects
          • GetProjectInfo
          • GetProjectList
          • GetProjectListByCreator
          • GetProjectListByCreatedDate
          • GetProjectListByKeywords
          • GetProjectListByProjectName
          • GetQuestionnaire
          • GetQuota
          • GetQuotas
          • GetRouting
          • GetSurveyStatus
          • ImportSurvey
          • ImportTranslation
          • ProjectExists
          • SetCustomProjectInfoField
          • SetPanelLink
          • SetSurveyStatus
          • Update
        • Definitions
          • AllowIgnoreDialingCommand
          • AnswerBase
          • AnswerButtonsMode
          • AnswerListType
          • AnswerRequiredType
          • AssignRequestValues
          • BaseTelephoneCommand
          • BenchmarkFormType
          • Block
          • BlockType
          • CallBlock
          • CommandText
          • ConfirmitProjectSourceType
          • Condition
          • CustomNavigationType
          • CustomResource
          • CustomTable
          • DatabaseType
          • DialCommand
          • DialMode
          • Directive
          • DirectiveDataType
          • Email
          • EmailObject
          • ExternalLookup
          • ExternalLookupType
          • ExpandLoopRefOption
          • FlexFallbackStrategy
          • Folder
          • FormBase
          • FormReference
          • FormText
          • GridForm
          • Grid3DForm
          • HandlingOfUndefinedPrecodes
          • HandlingOfInvalidNumericData
          • HandlingOfOversizedTexts
          • HangupCommand
          • Hierarchy
          • HierarchyElement
          • HierarchyUIMode
          • IncludeExclude
          • IncludeExcludeWithPrecodes
          • InfoForm
          • InlineSurveyCookieType
          • LangSpecString
          • LanguageString
          • Loop
          • LowerLimitDataType
          • MaskOnQuestion
          • MultiForm
          • Node
          • NodeType
          • OpenForm
          • Page
          • PoetReadFilter
          • PredefinedList
          • PredefinedScriptBase
          • Project
          • ProjectInfo
          • ProjectList
          • ProjectListToken
          • ProjectType
          • Questionnaire
          • QuestionnaireNode
          • QuestionnaireNodeFlexSupport
          • Quota
          • RandomCategorySelection
          • ReadFilter
          • ReadFilterSimple
          • Redirect
          • Root
          • SchemaSourceType
          • Script
          • SingleForm
          • SqlDbType
          • StateType
          • StatusType
          • SurveyApprovalState
          • SurveyLogicModeType
          • SurveySchema
          • Stop
          • StopDataType
          • SurveyStatusType
          • Telephone
          • TelephoneCommandType
          • TranslationStatus
          • TraverseOrderType
          • UpperLimitDataType
          • VariableDataType
          • WebMeasurementUnitType
      • Capi
        • Methods
          • AssignInterviewersToProject
          • AssignInterviewerToProjects
          • DeleteInterviewer
          • GetAllInterviewerUserIds
          • GetAssignedInterviewerUserIds
          • GetInternalIdByUserId
          • GetSynchronizationLog
          • InsertInterviewer
          • SendIndividualMessages
          • SendMessageToAllInterviewers
          • SendMessageToInterviewers
          • UpdateInterviewer
          • ValidateKey
        • Definitions
          • ColumnFilters
          • DateTimeFilter
          • IntegerFilter
          • MessageContent
          • MessageToInterviewer
          • Operator
          • SynchronizationLog
          • SynchronizationStatus
          • SynchronizationType
      • CommunityPanel
        • Methods
          • CreatePanelist
          • DeleteData
          • DeletePanelist
          • GetAllJobs
          • GetAllMatrices
          • GetAllPanelRules
          • GetAllPortals
          • GetData
          • GetDataGeneral
          • GetJobs
          • GetLinkedSurveyIds
          • GetMatrices
          • GetPanelistId
          • GetPanelRules
          • GetPanelVariables
          • GetRoutersList
          • GetRouterSurveysList
          • GetRuleSets
          • GetSurveyList
          • GetSurveyListGeneral
          • GetSurveyUrl
          • GetTopNLinkedSurveyIds
          • GetUpdateProfileSurveyUrl
          • ImportMatrix
          • RegisterSurveyInRouter
          • UnregisterSurveyFromRouter
          • UpdateData
          • UpdateDataGeneral
          • UpdatePanelVariables
          • UpdateSurveyHistoryVariables
        • Definitions
          • AggregatingFunction
          • ArithmeticType
          • Binary
          • BinaryArithmetic
          • BinaryComparison
          • BinaryLogic
          • Case
          • CaseWhenThen
          • Categorization
          • Category
          • CategoryAnswer
          • CategoryNotAnswered
          • CategoryField
          • CategoryFormElements
          • CategoryFunction
          • CategoryTotal
          • CodeMask
          • CodeWeight
          • ComparisonOperatorType
          • ComparisonType
          • ConfirmitData
          • ConfirmitDbType
          • CyclicDimension
          • DatabaseType
          • DataLevel
          • DateAdd
          • DateDiff
          • DatePart
          • DateTimeResolution
          • DayOfWeek
          • DayOfWeekType
          • DeleteStatement
          • Dimension
          • ErrorInfo
          • ErrorMessage
          • ExpressionList
          • FieldCategorization
          • FromClause
          • Function
          • FunctionType
          • GenericSqlFunction
          • GenericSqlFunctionType
          • GroupByTypes
          • HierarchyMask
          • JoinProjects
          • LanguageString
          • LevelInfo
          • ListType
          • LocaleString
          • LocaleStringSimple
          • LogicType
          • NameSourceType
          • OrderByClause
          • OrderByTypes
          • OverriddenFields
          • PeriodType
          • ProjectActivationState
          • ProjectRegistrationDefinition
          • QueryConstant
          • QueryField
          • QueryForm
          • QueryHierarchyLevel
          • QueryProject
          • QuestionCategorization
          • Record
          • ResponseToken
          • RouterDefinition
          • SelectClause
          • SelectStatement
          • SimpleDimension
          • SimpleTransferDef
          • SnowflakeDimension
          • SortOrder
          • SubQuerySettings
          • SurveyListColumns
          • SurveyListFilter
          • SurveyListParameters
          • SurveyQuery
          • SystemVariables
          • TextForCategory
          • TimeseriesDimension
          • TransferDef
          • TransferDefBase
          • TransferField
          • TransferForm
          • TransferLevel
          • TransferResult
          • TypeConvertion
          • Unary
          • UnaryType
          • UnitType
          • UpdateClause
          • UpdateStatement
          • Variable
          • VariableType
          • WeightingType
          • WhereClause
          • XmlExpressionWrapper
      • DatabaseDesigner
        • Methods
          • CreateDbRelation
          • CreateHierarchy
          • CreateSchema
          • CreateTable
          • CreateUserdefinedColumn
          • DeleteAllContent
          • DeleteContent
          • GenerateTable
          • GetContent
          • GetHierarchies
          • GetHierarchyByGuid
          • GetHierarchyById
          • GetHierarchyRelationsByGuid
          • GetHierarchyRelationsById
          • GetRelation
          • GetSchemaGuid
          • GetSchemaName
          • GetTableIds
          • GetTableSchemaInfoFromSchemaGuid
          • GetTableSchemaInfoFromSchemaId
        • Definitions
          • BrowseListDirection
          • DatabaseContent
          • DatabaseContentRow
          • DatabaseContentUserdefinedColumn
          • WSDbColumn
          • WSDbRelation
          • WsDbTable
          • WsDbTableLang
          • WSHierarchy
          • WSHierarchyRelation
          • WsTableSchema
      • DataTransfer
        • Methods
          • DeleteData
          • DeleteRespondents
          • GetChangedData
          • GetData
          • GetDataGeneral
          • GetRespondents
          • GetRespondentsGeneral
          • UpdateData
          • UpdateDataGeneral
          • UpdateRespondents
          • UpdateRespondentsGeneral
        • Definitions
          • ConfirmitData
          • ConfirmitDataResult
          • DatabaseType
          • DataLevel
          • ErrorInfo
          • ErrorMessage
          • Record
          • RespondentConfirmitDataResult
          • RespondentDataTransferDef
          • RespondentDataTransferDefBase
          • RespondentToken
          • RespondentTransferResult
          • ResponseToken
          • SurveyDataTransferDef
          • SurveyDataTransferDefBase
          • TransferResult
          • TransferVariableCollection
          • Variable
          • VariableType
      • PanelCredit
        • Methods
          • AddCreditToPanelist
          • DeleteAllCreditsFromPanelist
          • DeleteAllCreditsFromPanelistPerSurvey
          • DeleteAllCreditsFromSurvey
          • DeleteCreditFromPanelist
          • GetAllCreditsFromPanel
          • GetAllCreditsFromPanelBetween
          • GetAllCreditsFromPanelist
          • GetAllCreditsFromPanelistBetween
          • GetAllCreditsFromPanelistPerSurvey
          • GetAllCreditsFromSurvey
          • GetAllCreditsFromSurveyBetween
          • GetCreditBalanceFromPanelist
          • GetCredits
          • GetCreditsWithCustomVariables
          • GetTopNCreditsFromPanel
          • GetTopNCreditsFromPanelist
          • GetTopNCreditsFromPanelistPerSurvey
          • GetTopNCreditsFromSurvey
          • SetCreditToPanelist
          • SetCreditToPanelistWithCustomVariables
          • SetCreditToSecondaryPanelist
        • Definitions
          • DatabaseType
          • PanelistCredit
      • QuotaManagement
        • Methods
          • AdjustQuotaTarget
          • AdjustTestQuotaTarget
          • DeleteQuotaRows
          • GetQuotaList
          • GetQuotaNames
          • RecalculateQuota
          • SynchronizeQuota
          • UpdateQuotaList
          • UpdateTestQuotaList
        • Definitions
          • DatabaseType
          • QuotaLimitPriority
          • QuotaList
          • QuotaMode
          • QuotaRow
      • SampleManagement
        • Methods
          • AddExternalSurveyLinks
          • AddMatrix
          • AddSamplingJob
          • DeleteMatrix
          • DeleteSamplingJob
          • DeleteSamplingJobRun
          • ExecuteJob
          • GetLastSamplingJobRun
          • GetMatrix
          • GetSamplingJob
          • GetSamplingJobByJobNumber
          • GetSamplingJobRun
          • GetSamplingJobRunNumberByTaskId
          • GetSurveyLinksStatus
          • RemoveSamplingJobRunFromPanel
          • UpdateMatrix
          • UpdateSamplingJob
          • UploadSamplingJobRun
        • Definitions
          • CustomCode
          • Dimension
          • DimensionType
          • EmailObject
          • ExecutionSettings
          • JobFilter
          • JobFilterType
          • PropertyExclusion
          • PropertyValue
          • ReportDimension
          • ReportSegment
          • SamplingJob
          • SamplingJobRunReport
          • SamplingMatrix
          • SamplingState
          • Segment
          • SegmentWeight
          • SubSample
          • SubSampleReport
          • SurveyLinkStatus
          • SurveyStatus
          • UploadSettings
      • SurveyData
        • Methods
          • ConstructWhereClause
          • DeleteAllRespondents
          • DeleteData
          • DeleteRespondents
          • ExecuteQuery
          • ExecuteQueryGeneral
          • GetChangedData
          • GetData
          • GetDataByProject
          • GetDataByProjectGeneral
          • GetDataGeneral
          • GetInterviewProgressStats
          • GetLevelByName
          • GetLevelByNameGeneral
          • GetRespondentEmailLogByTask
          • GetRespondentEmailLogByTaskGeneral
          • GetRespondentEmailLogByTime
          • GetRespondentEmailLogByTimeGeneral
          • GetRespondentEmailLogByUniqueKey
          • GetRespondentEmailLogByUniqueKeyGeneral
          • GetRespondents
          • GetRespondentsGeneral
          • GetRespondentsTokenized
          • GetRespondentsTokenizedGeneral
          • GetTransactionStatus
          • IsRespondentUniqueKey
          • RemoveRespondentUniqueKey
          • SetRespondentUniqueKey
          • UpdateData
          • UpdateDataGeneral
          • UpdateExistingRespondents
          • UpdateExistingRespondentsGeneral
          • UpdateExistingRespondentsGeneralWithCatiScheduling
          • UpdateExistingRespondentsWithCatiScheduling
          • UpdateRespondents
          • UpdateRespondentsGeneral
          • UpdateRespondentsGeneralWithCatiScheduling
          • UpdateRespondentsWithCatiScheduling
        • Definitions
          • AggregatingFunction
          • ArithmeticType
          • Binary
          • BinaryArithmetic
          • BinaryComparison
          • BinaryLogic
          • Case
          • CaseWhenThen
          • Categorization
          • Category
          • CategoryAnswer
          • CategoryField
          • CategoryFormElements
          • CategoryFunction
          • CategoryNotAnswered
          • CategoryTotal
          • CatiScheduling
          • CodeMask
          • CodeWeight
          • ComparisonOperatorType
          • ComparisonType
          • ConfirmitData
          • ConfirmitDataResult
          • ConfirmitDbType
          • CyclicDimension
          • DatabaseType
          • DataLevel
          • DateAdd
          • DateDiff
          • DatePart
          • DateTimeResolution
          • DayOfWeek
          • DayOfWeekType
          • DeleteStatement
          • Dimension
          • ErrorInfo
          • ErrorMessage
          • ExpressionList
          • FieldCategorization
          • FromClause
          • Function
          • FunctionType
          • GenericSqlFunction
          • GenericSqlFunctionType
          • GroupByTypes
          • HierarchyMask
          • JoinProjects
          • LanguageString
          • LevelInfo
          • ListType
          • LocaleString
          • LocaleStringSimple
          • LogicType
          • NameSourceType
          • OrderByClause
          • OrderByTypes
          • OverriddenFields
          • PeriodType
          • ProjectActivationState
          • ProjectRegistrationDefinition
          • QueryConstant
          • QueryField
          • QueryForm
          • QueryHierarchyLevel
          • QueryProject
          • QuestionCategorization
          • Record
          • RespondentConfirmitDataResult
          • RespondentSystemVariables
          • RespondentToken
          • RespondentTransferDef
          • RespondentTransferResult
          • ResponseToken
          • RouterDefinition
          • SelectClause
          • SelectStatement
          • SimpleDimension
          • SimpleTransferDef
          • SnowflakeDimension
          • SortOrder
          • SubQuerySettings
          • SurveyQuery
          • SystemVariables
          • TextForCategory
          • TimeseriesDimension
          • TransferDef
          • TransferDefBase
          • TransferField
          • TransferForm
          • TransferLevel
          • TransferResult
          • TypeConvertion
          • Unary
          • UnaryType
          • UnitType
          • UpdateClause
          • UpdateStatement
          • Variable
          • VariableType
          • WeightingType
          • WhereClause
          • XmlExpressionWrapper
      • SurveyDeployer
        • Methods
          • CompileDB
          • DeployProject
          • DeployProjectWithDotNetSurvey
          • GenerateWI
          • GenerateWINet
          • GetTaskLogEntries
          • GetTaskPercentageCompleted
          • GetTaskStatus
          • LaunchSurvey
          • LaunchSurveyAt
          • LaunchSurveyAtWithQA
          • LaunchSurveyWithInstantAnalyticsReport
          • SendEmails
          • SendEmailsByEmailObject
          • SendEmailsByPanelEmailObject
          • SendEmailsExtended
        • Definitions
          • BodyFormat
          • DatabaseType
          • ExtendedKeyValuePair
          • GenerateDbOptions
          • GenerateWiOptions
          • LinkType
          • MailFormat
          • RespondentFilter
          • RespondentStatus
          • TaskLogEntry
          • TaskStatus
      • SurveyDesign
        • Methods
          • AddProject
          • DeleteQuestionnaire
          • DeleteRouting
          • DeleteProject
          • DuplicateProject
          • ExportSurvey
          • ExportSurveyLayout
          • ExportSurveyWithHTMLRemoved
          • ExportSurvey
          • ExportWeightModel
          • ExportWeightModels
          • ExportTranslation
          • GetBenchmarkProjectIds
          • GetConditionBranch
          • GetCustomProjectInfoField
          • GetDatabaseLastCompiled
          • GetExternalAnswers
          • GetFilteredQuestionnaire
          • GetForm
          • GetFormByName
          • GetFormsInLoop
          • GetLoopStructure
          • GetNode
          • GetNodes
          • GetPredefinedList
          • GetPredefinedLists
          • GetProjectEmailObjects
          • GetProjectInfo
          • GetProjectList
          • GetProjectListByCreator
          • GetProjectListByCreatedDate
          • GetProjectListByKeywords
          • GetProjectListByProjectName
          • GetQuestionnaire
          • GetQuota
          • GetQuotas
          • GetRouting
          • GetSurveyStatus
          • ImportSurvey
          • ImportTranslation
          • ProjectExists
          • SetCustomProjectInfoField
          • SetPanelLink
          • SetSurveyStatus
          • Update
        • Definitions
          • AllowIgnoreDialingCommand
          • AnswerBase
          • AnswerButtonsMode
          • AnswerListType
          • AnswerRequiredType
          • AssignRequestValues
          • BaseTelephoneCommand
          • BenchmarkFormType
          • Block
          • BlockType
          • CallBlock
          • CommandText
          • ConfirmitProjectSourceType
          • Condition
          • CustomNavigationType
          • CustomResource
          • CustomTable
          • DatabaseType
          • DialCommand
          • DialMode
          • Directive
          • DirectiveDataType
          • Email
          • EmailObject
          • ExpandLookup
          • ExpandLookupType
          • ExpandLoopRefOption
          • FlexFallbackStrategy
          • Folder
          • FormBase
          • FormReference
          • FormText
          • GridForm
          • Grid3DForm
          • HandlingOfUndefinedPrecodes
          • HandlingOfInvalidNumericData
          • HandlingOfOversizedTexts
          • HangupCommand
          • Hierarchy
          • HierarchyElement
          • HierarchyUIMode
          • IncludeExclude
          • IncludeExcludeWithPrecodes
          • InfoForm
          • InlineSurveyCookieType
          • LangSpecString
          • LanguageString
          • Loop
          • LowerLimitDataType
          • MaskOnQuestion
          • MultiForm
          • Node
          • NodeType
          • OpenForm
          • Page
          • PoetReadFilter
          • PredefinedList
          • PredefinedScriptBase
          • Project
          • ProjectInfo
          • ProjectList
          • ProjectListToken
          • ProjectType
          • Questionnaire
          • QuestionnaireNode
          • QuestionnaireNodeFlexSupport
          • Quota
          • RandomCategorySelection
          • ReadFilter
          • ReadFilterSimple
          • Redirect
          • Root
          • SchemaSourceType
          • Script
          • SingleForm
          • SqlDbType
          • StateType
          • StatusType
          • SurveyApprovalState
          • SurveyLogicModeType
          • SurveySchema
          • Stop
          • StopDataType
          • SurveyStatusType
          • Telephone
          • TelephoneCommandType
          • TranslationStatus
          • TraverseOrderType
          • UpperLimitDataType
          • VariableDataType
          • WebMeasurementUnitType
      • TaskManagement
        • Methods
          • GetTaskLogEntries
          • GetTaskPercentageCompleted
          • GetTaskStatus
          • SetRecurrencePattern
          • RespondentDataExport
          • RespondentDataExportDefault
          • SurveyDataExport
          • SurveyDataExportDefault
        • Definitions
          • DatabaseType
          • DataExportParameters
          • DecimalDelimiter
          • EmailingOptions
          • ExcelVersion
          • ExportFieldLabelSourceType
          • FileEncoding
          • FileTransferType
          • FileType
          • LoopHandling
          • LoopPosition
          • RecurrenceMode
          • RespondentDataExportParameters
          • RespondentFileType
          • ResponseFilter
          • TaskLogEntry
          • TaskRecurrencePattern
          • TaskStatus
          • TextFileFormat
          • TextInAnswerElementLabels
          • TextInQuestionLabels
SOAP API Docs current
  • CATI Docs
    • current
  • Custom Questions Docs
    • current
  • Public APIs
    • current
  • SOAP API Docs
    • current
  • Studio Docs
    • current
  • SOAP API Docs
  • Forsta Plus XML SOAP Web Services
  • CommunityPanel
  • Definitions
  • GenericSqlFunction

GenericSqlFunctionType

Fields

Name Data Type Description

Arguments

object[ ]

Type

GenericSqlFunctionType

Inherits Function

Copyright ©  Forsta logo. All rights reserved.