SQL Functions
Show all
Hide all
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_DefaultValueSql_Create
- SoftadminGuide.Parameter_MultiControl_Definition
- SoftadminGuide.ParseParameter_Columns
- SoftadminGuide.ParseParameter_Table_GetName
- SoftadminGuide.ParseParameter_Table_GetObjectId
- SoftadminGuide.ParseParameter_TableJoins
- SoftadminGuide.ReturnCode_NoLogging
- 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.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_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.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_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_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_TimeIntervals
- ADMIN_Trim
- 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