Multi-tenant formula restrictions

The namespaces, types, and methods that you can use in formulas are restricted in a multi-tenant environment. Only these are allowed:

  • System
  • Hansen
  • Hansen.*
  • InforClient
  • InforClient.*
  • System.Text
  • System.Text.*
  • System.IO.Path
  • System.Collections
  • System.Collections.*

Even within the allowed types, there are some exceptions. These methods are not permitted:

  • Hansen.Core.AccessControl.IAccessUser.AddAdministrator
  • Hansen.Core.AccessControl.IAccessUser.SetPassword
  • Hansen.Core.BatchProcessing.ITask
  • Hansen.Core.DataServices.*
  • Hansen.Core.Data.CDBProvider.*
  • Hansen.Core.Data.DBStmtAndAll
  • Hansen.Core.Data.Provider.SqlServer7.SqlServer7DataProvider.*
  • Hansen.Core.FileManagement.*
  • Hansen.Core.IEventHandler
  • Hansen.Core.Security.UserSecurityService.*
  • Hansen.Core.ServerApplication.CallExternalMethod
  • Hansen.Core.ServerApplication.FileManager
  • Hansen.Core.ServerApplication.FileMgtConfig
  • Hansen.Core.ServerApplication.GetProvider
  • Hansen.Core.ServerApplication.GetSharedFilesPath
  • Hansen.Core.ServerApplication.GetTenantId
  • Hansen.Core.ServerApplication.GetVirtualNameMap
  • Hansen.Core.ServerApplication.Initialize
  • Hansen.Core.ServerApplication.InitializeDeployment
  • Hansen.Core.ServerApplication.InitializeFileService
  • Hansen.Core.ServerApplication.InitializePaths
  • Hansen.Core.ServerApplication.InitializeTimeZone
  • Hansen.Core.ServerApplication.IsAssemblyLocked
  • Hansen.Core.ServerApplication.IsMultiTenant
  • Hansen.Core.ServerApplication.LoadAssembly
  • Hansen.Core.ServerApplication.LoadMonikerAssembly
  • Hansen.Core.ServerApplication.MonkConfig
  • Hansen.Core.ServerApplication.Path
  • Hansen.Core.ServerApplication.SharedFilesOverridePath
  • Hansen.Core.ServerApplication.SysConfig
  • Hansen.Core.ServerApplication.TenantID
  • Hansen.Core.ServerApplication.VirtualNameMappingFile
  • System.DateTime.Now (Use ServerApplication.GetDateNow instead.)
  • System.DateTime.Today (Use ServerApplication.GetDateToday instead.)

In addition, custom SQL is not allowed in formulas in a multi-tenant environment.