Documentation
version
7.12.001
7.11.004
7.11.003
7.11.002
7.11.001
7.10.002
7.10.001
7.9.003
7.9.002
7.9.001
7.8.001
7.7.001
7.6.001
7.5.001
7.4.001
7.3.002
7.3.001
7.2.001
7.1.001
7.0.003
6.7.002
6.7.001
6.6.002
6.6.001
6.5.003
6.5.002
6.5.001
6.4.002
6.4.001
6.3.001
6.2.001
6.1.001
6.0.007
6.0.006
6.0.005
6.0.004
5.5.001
5.4.020
5.4.019
5.4.018
5.4.017
5.4.016
5.4.015
5.4.014
5.4.011
5.3.006
5.3.005
Components
Controls
SQL Functions
SQL Procedures
SQL Tables
JS Functions
Articles
Release Notes
SQL Functions
Show all
Hide all
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.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
SoftadminSnippet.DatabaseFileLink
SoftadminSnippet.DatabaseImage
SoftadminSnippet.Html_StripUnsafeTags
SoftadminSnippet.PageLink
SoftadminSnippet.PathPattern
SoftadminSnippet.PostbackButton
SoftadminSnippet.PostbackLink
SoftadminSnippet.SetPathParameter
SoftadminSnippet.TextToHtml
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.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.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.UniqueIdentifier_IsValid
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_GetDateOfMondayISOWeekOne
ADMIN_GetDatePart
ADMIN_GetDayOfWeek
ADMIN_GetDefaultLanguageID
ADMIN_GetDynamicDateInterval
ADMIN_GetEmailAddressByUserId
ADMIN_GetFirstDayOfMonth
ADMIN_GetFirstDayOfWeek
ADMIN_GetLastDayOfMonth
ADMIN_GetLastDayOfWeek
ADMIN_GetMonthName
ADMIN_GetMonthNameAtDate
ADMIN_GetNameByUserId
ADMIN_GetNumberOfDaysInMonth
ADMIN_GetNumberOfOccurrences
ADMIN_GetPhrase
ADMIN_GetRelatedTables
ADMIN_GetTableColumns
ADMIN_GetTableCreateScript
ADMIN_GetWeekdayName
ADMIN_GetWeekdayNameAtDate
ADMIN_GetWorkdayFollowing
ADMIN_GetWorkdayPreceding
ADMIN_GetYearAndISOWeek
ADMIN_HashBytes
ADMIN_HashPassword
ADMIN_InitCap
ADMIN_IsBigint
ADMIN_IsDate
ADMIN_IsDatetime
ADMIN_IsInt
ADMIN_IsInteger
ADMIN_IsLeapYear
ADMIN_IsModulus10Compliant
ADMIN_IsNumeric
ADMIN_IsUniqueidentifier
ADMIN_IsValidEmailAddress
ADMIN_IsValidOCRNumber
ADMIN_IsValidOrganisationNumber
ADMIN_IsValidSocialSecurityNumber
ADMIN_IsWorkday
ADMIN_Javascript_GetDropdownSetContentsScript
ADMIN_JoinString
ADMIN_JoinStringSorted
ADMIN_LoginLinkInstance_Url
ADMIN_LTrim
ADMIN_MajorServerVersion
ADMIN_Max_DateTime
ADMIN_Max_Float
ADMIN_Max_Int
ADMIN_MenuItem_Exists
ADMIN_MenuItemUsesParameter
ADMIN_METADATA
ADMIN_Min_DateTime
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_Regex_Escape
ADMIN_Regex_IsMatch
ADMIN_Regex_Unescape
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_TextEncoding_GetBytes
ADMIN_TextEncoding_GetString
ADMIN_TimeIntervals
ADMIN_Trim
ADMIN_User_Authenticate
ADMIN_User_Functions
ADMIN_User_HasFunction
ADMIN_User_HasRole
ADMIN_User_IsSoftadminAdministrator
ADMIN_User_LanguageID
ADMIN_User_RoleID
ADMIN_ValidateEmailAddress
ADMIN_WeekNumber
ADMINEDITABLE_Search_UserCanDelete
ADMINEDITABLE_Search_UserCanEdit
SoftadminUtil.BigInt_CanParse
SoftadminUtil.Date_CanParse
SoftadminUtil.DateTime_CanParse
SoftadminUtil.Int_CanParse
SoftadminUtil.Number_CanParse