SQL Procedures & Functions
Show all
Hide all
Procedures
- ImpersonationProcedure
- PublishDownloadFileProcedure
- PublishIntegrationProcedure
- SavedSearchDeleteProcedure
- SavedSearchGetEditFieldsProcedure
- SavedSearchInfoSqlProcedure
- SavedSearchInsertUpdateProcedure
- SavedSearchSearchInfoSqlProcedure
- SavedSearchSearchProcedure
- SingleSignOnLoginProcedure
- SingleSignOnLoginProcedure (Advanced SSO)
- SingleSignOnLoginProcedure (AzureAD)
- SingleSignOnLoginProcedure (SAML)
SoftadminApi
- 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_Add
- 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.Parameter_Checkbox_Create
- SoftadminGuide.Parameter_Column_Create
- SoftadminGuide.Parameter_Columns_Create
- SoftadminGuide.Parameter_ColumnsWithOperator_Create
- SoftadminGuide.Parameter_Heading_Create
- SoftadminGuide.Parameter_SqlModuleName_Create
- SoftadminGuide.Parameter_Table_Create
- SoftadminGuide.Parameter_TableJoins_Create
- SoftadminGuide.Parameter_Text_Create
- SoftadminGuide.Parameter_UneditableText_Create
- SoftadminGuide.SqlModule_Create
- SoftadminGuide.SqlModule_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.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_GetRandomUnicodeString
- ADMIN_INITIALIZE
- ADMIN_LocalSetting_Update
- ADMIN_Log_AddLog
- ADMIN_Log_AddLogData
- ADMIN_MULTIROW_PARSE
- ADMIN_OBJECT_FIND
- ADMIN_Phrase_ClearCacheForConnectedObjects
- ADMIN_PhraseTranslation_Update
- ADMIN_Search_Delete
- ADMIN_Search_InsertUpdate
- ADMIN_String_Print
- ADMIN_User_CreatePasswordSalt
- ADMIN_User_InsertUpdate
- ADMINDEV_SCRIPTCONTENTS
- ADMINDEV_SCRIPTMETADATA
- ADMINDEV_ScriptTable
- ADMINDEV_ScriptTableConstraints
- ADMINDEV_ScriptTableIndexes
- ADMINEDITABLE_IMPERSONATEUSERS
- ADMINEDITABLE_Search_Delete
- ADMINEDITABLE_Search_GetEditFields
- ADMINEDITABLE_Search_InfoSQL
- ADMINEDITABLE_Search_InsertUpdate
- ADMINEDITABLE_Search_Search
- ADMINEDITABLE_Search_Search_InfoSQL
- ADMINEDITABLE_User_UpdatePassword
- ADMINEDITABLE_User_UpdatePasswordInfoSQL
- PUBLISHEDITABLE_GetFile
- PUBLISHEDITABLE_SingleSignOn
Functions
SoftadminApi
- SoftadminApi.Css_StyleSheet
- SoftadminApi.DeployLevel_IsDevelopment
- SoftadminApi.DeployLevel_IsProduction
- SoftadminApi.DeployLevel_IsStage
- SoftadminApi.Functions
- SoftadminApi.Icon_AsHtml
- SoftadminApi.Javascript_DropdownSetContentsScript
- SoftadminApi.JobsAreRunning
- SoftadminApi.LanguageId_Default
- SoftadminApi.LoginLinkInstance_Url
- SoftadminApi.LoginLinkStatic_Url
- SoftadminApi.MenuGroup_Name
- SoftadminApi.MenuItem_Name
- SoftadminApi.Phrase_Text
- SoftadminApi.Phrase_Texts
- SoftadminApi.Roles
- SoftadminApi.SavedSearch_GetEditFields
- SoftadminApi.SavedSearch_IsObsolete
- SoftadminApi.SavedSearch_Sql
- SoftadminApi.Setting_Value
- 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.Parameter_Column_CustomWhere_Datatype_Bit
- SoftadminGuide.Parameter_Column_CustomWhere_Datatype_Date
- SoftadminGuide.Parameter_Column_CustomWhere_Datatype_DateAndDatetime
- SoftadminGuide.Parameter_Column_CustomWhere_Datatype_Datetime
- SoftadminGuide.Parameter_Column_DefaultValueSql_Create
- SoftadminGuide.Parameter_MultiControl_Definition
- SoftadminGuide.ParseParameter_Columns
- SoftadminGuide.ParseParameter_Table_GetName
- SoftadminGuide.ParseParameter_Table_GetObjectId
- SoftadminGuide.ParseParameter_TableJoins
- SoftadminGuide.ReturnCode_NoLogging
- SoftadminGuide.Sql_QuoteName
- SoftadminGuide.Table_Alias
- SoftadminGuide.Table_Aliases
SoftadminSnippet
- SoftadminSnippet.BankId_PersonalNumber_IsValid
- 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.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.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.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_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_AllBitsTrue
- ADMIN_AnyBitTrue
- ADMIN_Convert_BigInt2Hex
- ADMIN_DataType_Parse
- ADMIN_EscapeHtml
- ADMIN_FormatName
- ADMIN_FormatNumeric
- ADMIN_Functions
- ADMIN_GenerateModulus10CheckDigit
- ADMIN_GenerateModulus10Checksum
- ADMIN_GetAgeInYears
- ADMIN_GetAppVar
- ADMIN_GetCss
- ADMIN_GetDefaultLanguageID
- ADMIN_GetEmailAddressByUserId
- ADMIN_GetNameByUserId
- ADMIN_GetNumberOfOccurrences
- ADMIN_GetPhrase
- ADMIN_GetRelatedTables
- ADMIN_GetTableColumns
- ADMIN_GetTableCreateScript
- ADMIN_HashBytes
- ADMIN_HashPassword
- ADMIN_InitCap
- ADMIN_IsBigint
- ADMIN_IsInt
- ADMIN_IsInteger
- ADMIN_IsModulus10Compliant
- ADMIN_IsNumeric
- ADMIN_IsUniqueidentifier
- ADMIN_IsValidEmailAddress
- ADMIN_IsValidOCRNumber
- ADMIN_IsValidOrganisationNumber
- ADMIN_IsValidSocialSecurityNumber
- ADMIN_Javascript_GetDropdownSetContentsScript
- ADMIN_LoginLinkInstance_Url
- ADMIN_LTrim
- ADMIN_MajorServerVersion
- ADMIN_Max_Float
- ADMIN_Max_Int
- ADMIN_MenuItem_Exists
- ADMIN_MenuItemUsesParameter
- ADMIN_METADATA
- ADMIN_Min_Float
- ADMIN_Min_Int
- ADMIN_NoBitTrue
- ADMIN_NUMBERSBETWEEN
- ADMIN_OrderBy_DeleteColumn
- ADMIN_OrderBy_GetColumn
- ADMIN_OrderBy_Join
- ADMIN_PadLeft
- ADMIN_PadRight
- ADMIN_ParseBigint
- ADMIN_ParseCSVFile
- ADMIN_ParseCSVRow
- ADMIN_ParseInt
- ADMIN_ParseStringOfIntegers
- ADMIN_PersonalIdentityNumber_GetDateOfBirth
- ADMIN_PersonalIdentityNumber_GetGender
- ADMIN_PhoneNumber_FormatAsE123
- ADMIN_PhoneNumber_IsValid
- ADMIN_QUERYSTRING
- ADMIN_ReduceWhitespace
- ADMIN_RemoveTrailingString
- ADMIN_ReplaceNewLine
- ADMIN_Roles
- ADMIN_RTF_CleanTemplate
- ADMIN_RTF_Escape
- ADMIN_RTF_Parse
- ADMIN_RTrim
- ADMIN_Search_GetEditFields
- ADMIN_Search_GetSQL
- ADMIN_Search_IsObsolete
- ADMIN_SplitString
- ADMIN_SplitText
- ADMIN_String_EscapeLikeWildcards
- ADMIN_String_StripAccents
- ADMIN_String_StripHTMLTag
- ADMIN_String_StripToAlphanumeric
- ADMIN_String_Truncate
- ADMIN_StripNonDigits
- ADMIN_StripSqlComments
- ADMIN_StripToUnsignedBigint
- ADMIN_StripToUnsignedInt
- ADMIN_TempTable_Exists
- ADMIN_Trim
- ADMIN_User_Functions
- ADMIN_User_HasFunction
- ADMIN_User_HasRole
- ADMIN_User_IsSoftadminAdministrator
- ADMIN_User_LanguageID
- ADMIN_User_RoleID
- ADMIN_ValidateEmailAddress
- ADMINEDITABLE_Search_UserCanDelete
- ADMINEDITABLE_Search_UserCanEdit