SQL Procedures & Functions
Procedures
- ImpersonationProcedure
- PasswordPolicyFulfillsPolicyProcedure
- PreUpdatePasswordProcedure
- PublishDownloadFileProcedure
- PublishIntegrationProcedure
- SavedSearchDeleteProcedure
- SavedSearchGetEditFieldsProcedure
- SavedSearchInfoSqlProcedure
- SavedSearchInsertUpdateProcedure
- SavedSearchSearchInfoSqlProcedure
- SavedSearchSearchProcedure
- SingleSignOnActiveDirectorySignInProcedure
- SingleSignOnAzureSignInProcedure
- SingleSignOnLoginProcedure
- SingleSignOnOpenIdConnectSignInProcedure
- SingleSignOnSamlSignInProcedure
SoftadminApi
- SoftadminApi.AnnouncementBanner_Delete
- SoftadminApi.AnnouncementBanner_Insert
- SoftadminApi.AnnouncementBanner_Update
- SoftadminApi.AzureAppRole_Export
- SoftadminApi.AzureServiceBus_EnqueueMessage
- SoftadminApi.BankgiroFtp_SetAsProcessed
- SoftadminApi.Credentials_InsertUpdate
- SoftadminApi.Credentials_UpdateAccount
- SoftadminApi.Credentials_UpdateSecret
- SoftadminApi.DeployScript_Insert
- SoftadminApi.EnterpriseSearchIndex_Delete
- SoftadminApi.EnterpriseSearchIndex_InsertUpdate
- SoftadminApi.EnterpriseSearchIndex_UpdateSecurityGroup
- SoftadminApi.Event_Raise
- SoftadminApi.Event_Raise_Batch
- SoftadminApi.Job_ResumeOnWebServer
- SoftadminApi.Job_Suspend
- SoftadminApi.Log_LogDiagnostic
- SoftadminApi.Log_LogError
- SoftadminApi.LoginLinkInstance_Delete
- SoftadminApi.LoginLinkInstance_Insert
- SoftadminApi.LoginLinkInstance_InsertBatch
- SoftadminApi.Mail_Enqueue
- SoftadminApi.Multirow_Parse
- SoftadminApi.Notification_Dismiss
- SoftadminApi.Notification_DismissGroup
- SoftadminApi.Notification_Enqueue
- SoftadminApi.Notification_EnqueueBatch
- SoftadminApi.Phrase_Update
- SoftadminApi.Progress_SetStep
- SoftadminApi.Progress_SetTitle
- SoftadminApi.SavedSearch_Delete
- SoftadminApi.SavedSearch_InsertUpdate
- SoftadminApi.Setting_Update
- SoftadminApi.User_Delete
- SoftadminApi.User_InsertUpdate
- SoftadminApi.User_UpdatePassword
- SoftadminApi.User_UpdatePersonalNumber
SoftadminGuide
- SoftadminGuide.ExecutionLog_SetSummary
- SoftadminGuide.FieldGeneric_Checkbox
- SoftadminGuide.FieldGeneric_Heading
- SoftadminGuide.FieldGeneric_HeadingWithCheckbox
- SoftadminGuide.FieldGeneric_Textbox
- SoftadminGuide.FieldGeneric_UneditableText
- SoftadminGuide.FieldStandard_ChildTables
- SoftadminGuide.FieldStandard_Column
- SoftadminGuide.FieldStandard_Columns
- SoftadminGuide.FieldStandard_ColumnsWithOperator
- SoftadminGuide.FieldStandard_ExistingSqlObjectWarning
- SoftadminGuide.FieldStandard_MenuGroup
- SoftadminGuide.FieldStandard_MenuItem
- SoftadminGuide.FieldStandard_MenuSubgroup
- SoftadminGuide.FieldStandard_ParentTables
- SoftadminGuide.FieldStandard_SqlObjectName
- SoftadminGuide.FieldStandard_TableJoins
- SoftadminGuide.Generate_Calendar_Resource_Sql
- SoftadminGuide.Generate_Calendar_Weekday_Sql
- SoftadminGuide.Generate_Calendar_WeekSchedule_Sql
- SoftadminGuide.Generate_Delete_Sql
- SoftadminGuide.Generate_Dropdown_Sql
- SoftadminGuide.Generate_Grid_DynamicSql
- SoftadminGuide.Generate_Grid_StaticSql
- SoftadminGuide.Generate_Multipart_Sql
- SoftadminGuide.Generate_NewEdit_GetEditFields_Sql
- SoftadminGuide.Generate_NewEdit_InsertUpdate_Sql
- SoftadminGuide.Generate_Treeview_InsertUpdate_Sql
- SoftadminGuide.Generate_Treeview_Sql
- SoftadminGuide.Guide_SetFieldValueFromPopup
- SoftadminGuide.Link_Create
- SoftadminGuide.MenuItem_Create
- SoftadminGuide.SqlObject_Create
- SoftadminGuide.SqlObject_CreateOrAlter
- SoftadminGuide.TextTemplate_ReplacePlaceholders
SoftadminSnippet
- SoftadminSnippet.BankId_Identify
- SoftadminSnippet.BankId_Sign
- SoftadminSnippet.DeclareLink
- SoftadminSnippet.Element_SetContent
- SoftadminSnippet.Form
- SoftadminSnippet.IFrame
- SoftadminSnippet.Page_AllowAccess
- SoftadminSnippet.Page_Redirect
- SoftadminSnippet.Page_ReloadSnippets
- SoftadminSnippet.Page_ReplaceUrl
- SoftadminSnippet.Page_SetTitle
- SoftadminSnippet.Session_LogOut
- SoftadminSnippet.Session_SetVariable
SoftadminUtil
- SoftadminUtil.AutoLayout_ApproximateNodeDimensions
- SoftadminUtil.Csv_ParseFile
- SoftadminUtil.Csv_ParseText
- SoftadminUtil.P27_Camt_054_001_02_Parse
- SoftadminUtil.P27_Pain_001_001_03_Generate
- SoftadminUtil.P27_Pain_002_001_03_Parse
- SoftadminUtil.Password_CreateRandom
- SoftadminUtil.Password_FulfillsPolicy
- SoftadminUtil.String_Print
Deprecated
- ADMIN_Csv_ParseFile
- ADMIN_Csv_ParseText
- ADMIN_DBReindex
- ADMIN_GetFirstString
- ADMIN_INITIALIZE
- ADMIN_LocalSetting_Update
- ADMIN_Log_AddLog
- ADMIN_Log_AddLogData
- ADMIN_PhraseTranslation_Update
- ADMIN_Search_Delete
- ADMIN_Search_InsertUpdate
- ADMINDEV_SCRIPTCONTENTS
- ADMINDEV_SCRIPTMETADATA
- ADMINDEV_ScriptTable
- ADMINDEV_ScriptTableConstraints
- ADMINDEV_ScriptTableIndexes
SoftadminApi
Functions
SoftadminApi
- SoftadminApi.Color_FromName
- SoftadminApi.Css_StyleSheet
- SoftadminApi.DateRangeControl_CreateValue
- SoftadminApi.DateRangeControl_ParseValue
- SoftadminApi.DeployLevel_IsDevelopment
- SoftadminApi.DeployLevel_IsProduction
- SoftadminApi.DeployLevel_IsStage
- SoftadminApi.FileControl_CreateExistingFileToken
- SoftadminApi.Functions
- SoftadminApi.Icon_AsHtml
- SoftadminApi.Javascript_DropdownSetContentsScript
- SoftadminApi.JobsAreRunning
- SoftadminApi.Kpi_ComputeTrend
- SoftadminApi.LanguageId_Default
- SoftadminApi.LoginLinkInstance_Url
- SoftadminApi.LoginLinkStatic_Url
- SoftadminApi.MenuGroup_Name
- SoftadminApi.MenuItem_Name
- SoftadminApi.Phrase_Text
- SoftadminApi.Phrase_Texts
- SoftadminApi.Phrase_TranslationFromAlias
- SoftadminApi.Phrase_Translations
- SoftadminApi.Roles
- SoftadminApi.SavedSearch_GetEditFields
- SoftadminApi.SavedSearch_IsObsolete
- SoftadminApi.SavedSearch_Sql
- SoftadminApi.Setting_Value
- SoftadminApi.SyncEntity_RaiseChanged
- SoftadminApi.User_Authenticate
- SoftadminApi.User_Email
- SoftadminApi.User_FullName
- SoftadminApi.User_Functions
- SoftadminApi.User_HasAccessToMenuGroup
- SoftadminApi.User_HasAccessToMenuItem
- SoftadminApi.User_HasFunction
- SoftadminApi.User_HasRole
- SoftadminApi.User_IsSoftadminAdministrator
- SoftadminApi.User_LanguageId
- SoftadminApi.User_RoleId
SoftadminGuide
- SoftadminGuide.Field_Column_CustomWhere_Datatype_Bit
- SoftadminGuide.Field_Column_CustomWhere_Datatype_Date
- SoftadminGuide.Field_Column_CustomWhere_Datatype_DateAndDatetime
- SoftadminGuide.Field_Column_CustomWhere_Datatype_Datetime
- SoftadminGuide.Field_Column_DefaultValueSql
- SoftadminGuide.Field_Columns_DefaultValueSql
- SoftadminGuide.Field_MultiControl_Definition
- SoftadminGuide.Field_SqlObjectName_FromTable_DefaultValueSql
- SoftadminGuide.Link_Definition
- SoftadminGuide.LinkPassingField_Definition
- SoftadminGuide.MenuItem_Definition
- SoftadminGuide.MenuItemFieldTable_Definition
- SoftadminGuide.MenuItemName_Delete_DefaultValue
- SoftadminGuide.MenuItemName_Edit_DefaultValue
- SoftadminGuide.MenuItemName_New_DefaultValue
- SoftadminGuide.MenuItemName_Search_DefaultValue
- SoftadminGuide.MenuItemProcedureParameter_Definition
- SoftadminGuide.ParseField_ChildTables
- SoftadminGuide.ParseField_Columns
- SoftadminGuide.ParseField_ParentTables
- SoftadminGuide.ParseField_TableJoins
- SoftadminGuide.ParseField_Tables_AliasJson
- SoftadminGuide.ReturnCode_Abort
- SoftadminGuide.Sql_QuoteName
- SoftadminGuide.Table_Alias
- SoftadminGuide.Table_Aliases
- SoftadminGuide.Table_AllColumns
- SoftadminGuide.Table_BitColumns
- SoftadminGuide.Table_ColumnDataType
- SoftadminGuide.Table_Columns
- SoftadminGuide.Table_DateColumns
- SoftadminGuide.Table_PrimaryKeyColumns
- SoftadminGuide.Table_PrimaryKeyInfo
- SoftadminGuide.Table_TextColumns
SoftadminSnippet
- SoftadminSnippet.BankId_PersonalNumber_IsValid
- SoftadminSnippet.BankId_StartButton
- SoftadminSnippet.DatabaseFileLink
- SoftadminSnippet.DatabaseImage
- SoftadminSnippet.Html_StripUnsafeTags
- SoftadminSnippet.PageLink
- SoftadminSnippet.PathPattern
- SoftadminSnippet.PostbackButton
- SoftadminSnippet.PostbackLink
- SoftadminSnippet.SetPathParameter
- SoftadminSnippet.TextToHtml
SoftadminUtil
- SoftadminUtil.Binary_Hash
- SoftadminUtil.Bit_AllTrue
- SoftadminUtil.Bit_AnyTrue
- SoftadminUtil.Chart_Scale_LinearInteger
- SoftadminUtil.Compression_Compress
- SoftadminUtil.Compression_Expand
- SoftadminUtil.Date_Range
- SoftadminUtil.Date_YearAndWeekNumber
- SoftadminUtil.DatePeriod_Boundaries
- SoftadminUtil.DatePeriod_Intervals
- SoftadminUtil.DateTime_FromDateAndTime
- SoftadminUtil.Datetime_Range
- SoftadminUtil.Day_DayOfWeek
- SoftadminUtil.Email_IsValidEmailAddress
- SoftadminUtil.Email_ValidateEmailAddresses
- SoftadminUtil.Email_ValidateEmailAddressesOfType
- SoftadminUtil.Email_ValidateEmailAddressOfType
- SoftadminUtil.Html_CodeTag
- SoftadminUtil.Html_CodeTags
- SoftadminUtil.Html_ConvertToText
- SoftadminUtil.Html_Escape
- SoftadminUtil.Html_StripUnsafeTags
- SoftadminUtil.Image_IsJpeg
- SoftadminUtil.Image_IsPng
- SoftadminUtil.Mod10_Checksum
- SoftadminUtil.Mod10_ChecksumDigit
- SoftadminUtil.Mod10_IsCompliant
- SoftadminUtil.Month_FirstDay
- SoftadminUtil.Month_LastDay
- SoftadminUtil.Month_NameFromDate
- SoftadminUtil.Month_NameFromOrdinal
- SoftadminUtil.Month_NumberOfDays
- SoftadminUtil.Number_Format
- SoftadminUtil.Number_ParseList
- SoftadminUtil.Number_Range
- SoftadminUtil.OcrNumber_Generate
- SoftadminUtil.OcrNumber_IsValid
- SoftadminUtil.OrganisationNumber_IsValid
- SoftadminUtil.P27_Camt_CreditNotification_Definition
- SoftadminUtil.P27_Camt_CreditNotificationDetails_Definition
- SoftadminUtil.P27_Camt_DebitNotification_Definition
- SoftadminUtil.P27_Pain_Payment_Definition
- SoftadminUtil.P27_Pain_PaymentStatus_Definition
- SoftadminUtil.Password_Hash
- SoftadminUtil.Password_Verify
- SoftadminUtil.Person_FormatName
- SoftadminUtil.PersonalIdentityNumber_DateOfBirth
- SoftadminUtil.PersonalIdentityNumber_Gender
- SoftadminUtil.PersonalIdentityNumber_IsValid
- SoftadminUtil.PersonalIdentityNumber_Normalize
- SoftadminUtil.PhoneNumber_FormatAsE123
- SoftadminUtil.PhoneNumber_IsValid
- SoftadminUtil.Regex_Escape
- SoftadminUtil.Regex_IsMatch
- SoftadminUtil.Regex_Unescape
- SoftadminUtil.RTF_CleanTemplate
- SoftadminUtil.RTF_Escape
- SoftadminUtil.RTF_Parse
- SoftadminUtil.String_CountOccurrences
- SoftadminUtil.String_EscapeLikeWildcards
- SoftadminUtil.String_Join
- SoftadminUtil.String_LTrim
- SoftadminUtil.String_PadLeft
- SoftadminUtil.String_PadRight
- SoftadminUtil.String_ReduceWhitespace
- SoftadminUtil.String_RemoveTrailingString
- SoftadminUtil.String_ReplaceNewLine
- SoftadminUtil.String_RTrim
- SoftadminUtil.String_Split
- SoftadminUtil.String_StripAccents
- SoftadminUtil.String_StripHtmlTag
- SoftadminUtil.String_StripNonDigits
- SoftadminUtil.String_StripToAlphanumeric
- SoftadminUtil.String_SubstringStartingAt
- SoftadminUtil.String_Trim
- SoftadminUtil.String_Truncate
- SoftadminUtil.TempTable_Exists
- SoftadminUtil.TextEncoding_BytesToString
- SoftadminUtil.TextEncoding_StringToBytes
- SoftadminUtil.Week_FirstDay
- SoftadminUtil.Week_LastDay
- SoftadminUtil.Weekday_NameFromDate
- SoftadminUtil.Weekday_NameFromOrdinal
- SoftadminUtil.Workday_Following
- SoftadminUtil.Workday_IsWorkday
- SoftadminUtil.Workday_Preceding
- SoftadminUtil.Year_AgeFromDates
- SoftadminUtil.Year_DateOfMondayOfWeekOne
- SoftadminUtil.Year_IsLeapYear
Deprecated
- ADMIN_Convert_BigInt2Hex
- ADMIN_EscapeHtml
- ADMIN_FormatName
- ADMIN_FormatNumeric
- ADMIN_GenerateModulus10CheckDigit
- ADMIN_GenerateModulus10Checksum
- ADMIN_GetAgeInYears
- ADMIN_GetAppVar
- ADMIN_GetCss
- ADMIN_GetDefaultLanguageID
- ADMIN_GetNumberOfOccurrences
- ADMIN_GetPhrase
- ADMIN_InitCap
- ADMIN_LoginLinkInstance_Url
- ADMIN_Max_Float
- ADMIN_Max_Int
- ADMIN_Min_Float
- ADMIN_Min_Int
- ADMIN_ParseCSVFile
- ADMIN_ParseCSVRow
- ADMIN_PersonalIdentityNumber_GetDateOfBirth
- ADMIN_PersonalIdentityNumber_GetGender
- ADMIN_PhoneNumber_FormatAsE123
- ADMIN_PhoneNumber_IsValid
- ADMIN_QUERYSTRING
- ADMIN_ReduceWhitespace
- ADMIN_RemoveTrailingString
- ADMIN_ReplaceNewLine
- ADMIN_RTF_CleanTemplate
- ADMIN_RTF_Escape
- ADMIN_RTF_Parse
- ADMIN_Search_IsObsolete
- ADMIN_SplitText
- ADMIN_String_EscapeLikeWildcards
- ADMIN_TempTable_Exists
- ADMIN_ValidateEmailAddress