IzendaSystemSetting table
Some configurable system settings are stored in IzendaSystemSetting table. These settings can also be changed directly inside this table without going through the UI.
| Name | Description | Default Value |
|---|---|---|
| WebAPIUrl | The url for Izenda Back-end | Blank - use setting from web server |
| FiscalYear | The start of fiscal year, in mm/dd format | 10/01 |
| LicenseExpiredWarningTrial | The number of days before trial license expires to notify user | 4 |
| DeploymentMode |
Integration modes
| 0 |
| AuthenticationBaseAddress | Deprecated 1.25.0 release | Blank |
| AuthValidateAccessTokenUrl | Access token validation path (prefixed by AuthenticationBaseAddress) | api/validateAccessToken |
| AuthGetAccessTokenUrl | Access token retrieval path (prefixed by AuthenticationBaseAddress) | api/getAccessToken |
| LicenseExpiredWarningPeriod | The number of days before trial license expires to notify user | 14 |
| CommonFilterSetting |
How to decide if two fields are the “same” to become common filters
| 0 |
| TracingType |
Which information to log, using bitmask check:
|
3 (011):
|
| LicenseWebAPIUrl | The license checker url | Site-specific |
| ExportConversionDelay | Delay time in seconds to wait for asynchronous items to be completely loaded or for a web page redirect to finish before exporting | 5 |
| WebUrl | The Front-end url, used for Exporting | Site-specific |
| SubscriptionJobInterval | Check subscriptions every x minutes | 1 |
| ApiSecretToken | The secret token to communicate with hosting API, in Integrated Front-end modes | Site-specific |
| ExportFileLocation | The location for exported files | C: |
| AllowDuplicateUser | Allow duplicated user names in multi-tenant mode or not | 1 |
| PageSize | The default print page size | A4 |
| SystemMode |
Tenant mode
| 0 |
| LostConnectionAllowPeriod | License checker maximum lost connection period, in minutes | 96 |
| CustomFunctionFilePath | Path to user custom functions json file | Blank |
| RefreshTokenPeriod | Refresh token every x minutes | 60 |
| ReportAdvancedMode |
Report mode
| 1 |
| EvoLicenseKey | License key for third-party EvoPDF | Site-specific |
| HasCreatePermission OnReportingDatabase |
Do accounts in connection strings have permission to create tables?
| 1 |
| Margin | Place-holder | |
| ExportNavigationTimeout | Navigation timeout for the exporting process, in seconds | 300 |
| LayoutSize | The number of report tiles per screen width, used for calculating export size | 12 |
| AuthRSAPublicKey | The Public key from the RSA key pair used for encrypting export requests on Integrated Front-end modes | Site-specific |
| Token Timeout | The number of minutes before inactive user’s token expires in standalone versions | 20 |
| StoredProcParamDelimiter | The delimiter which will be used to separate values for stored procedure input parameters which accept multiple values | , |
| CommandTimeout | Timeout used for all queries to the Izenda Configuration Database, in seconds | 500 |
| HelpSystemUrl | The URL link which is used when users click the Help Sysetm “?” icon on the Izenda header bar | http://www.izenda.com |
| InsertBatchSize | Limits large insert statements to smaller batches for the Izenda database | 10000 |
| ProvisionStaticDataStatus |
Status of provisioning map data
| Should be 2 |
| ImportFileSystemPath |
The directory to store uploaded file when importing report/dashboard definitions. Izenda supports 3 types of directory:
| IzendaImport |
| IsEnableDataCache | Whether data cache is enable or not | true |
| DataCacheTTL | Limit the lifespan in second for data caches | 600 |
| DataCacheEvictionInterval | Define the inteval to clear expired data caches | 600 |
| DataCacgeRefreshInterval | Define the interval to load new data for data caches | 200 |
| DataCacheRefreshDuration | Limit the time to run refresh data cache job | 100 |
| SystemCacheTTL | Limit the lifespan in second for system caches | 3600 |
| SystemCacheEvictionInterval | Define the inteval to clear expired system caches | 3600 |