Extended properties
Extended properties are used to control features of the Thinkwise Platform when the settings for those features have not yet been formalized in the Software Factory model.
The parameters below can be used as extended properties in the Software Factory and Intelligent Application Manager. Some extended properties work for each application, other properties will influence the total GUI. A few properties only work when set in the global settings, they need to be loaded before the GUI is shown. These properties are marked as global exclusive.
Application specific parameters can also be specified in the global configuration and will then be used by all applications.
| Parameter | Description | Options | Scope |
|---|---|---|---|
| AllowChangePassword | Determines if users with RDBMS login are allowed to change their password Note: only available for SQL Server now. | Yes No | |
| AllowNullMandCheckbox | Mandatory fields without a default value will be represented as null in the Grid and Form while adding a new row. | Yes No | Application |
| AllowProcessFlowsInLookupDialogs | By default, process flows cannot be executed in a lookup. With this property, a process flow is allowed access to a lookup, provided all process actions are allowed in a lookup. Forbidden process actions are: Manual, Close document, Open document, Activate document, and Zoom in on detail. | Yes No | |
| AllowWildcards | Allows the use of wildcards * and ? in search and filter fields, including the combined filter. | Yes No | Application |
| AnalyticsEnabled | Enable or disable Matamo analytics JavaScript. | Yes No | |
| AnalyticsWebsiteID | Matamo Website ID. | 2 | |
| Animations | Animation Quick Bar when expanding groups. | Yes No | |
| ApplyConditionalLayout | Determines on which controls conditional layout is applied. | None Grid Form GridAndForm GridAndFormEdit | Application |
| Authentication | The authentication type to use when connecting to the application database. | MSWindows - Integrated security for SQL Server RDBMS - Database username and password Kerberos - Integrated security for IBM i and SQL Server | Application |
| AutoExpandGroups | Controls whether or not pivot grids will attempt to maintain the expanded state of groups when dimensions are changed. This feature does not work as intended, and is therefore opt-in. | Yes No | Application |
| AutoLimitColumnSelection | Activates still experimental feature to limit the select clause in SQL queries to those columns that are in use by visible components on the screen. Version 2018.1 and higher. | Yes No | Application |
| BreadcrumbInPrintPreview | Yes No | Application | |
| BringGUIToFront | Whether the GUI should claim focus on startup or stay in background. | Yes No | Global exclusive |
| CachePath | A custom path where the GUI stores a cache of the application definition to increase the startup time. This also applies to images (only in the Web GUI) and reports (Windows and Web GUI) stored in the database for 2020.2 and up. The default location is the Cache folder with the GUI directory. The specified directory requires rights to write files. This property also affects the previewer's cache folder. | Directory location, like: C:/Cache/Project/ | Global |
| CCSID | Universal GUI Indicium Indicium Basic Sets the CCSID (Code Page) of IBM i DB2 Jobs. When not filled or 0, the default server code page is used. | 37 - legacy default 1140 - 37 + euro sign ‚¬ | |
| ClearReportDataSource | Universal GUI Indicium Indicium Basic The name of the default datasource to be used on the server where Clear Reports is installed. The datasource needs to be added on the server and can be used if credentials cannot be parsed, for instance when Kerberos is used. | ||
| ClearReportPort | Universal GUI Indicium Indicium Basic The port of the server where Clear Reports is installed. | Application | |
| ClearReportServer | Universal GUI Indicium Indicium Basic The server where Clear Reports is installed. | Application | |
| ClearReportUri | Universal GUI Indicium Indicium Basic The path to the server where Clear Reports is installed. | Application | |
| CombinedFilterDelay | Delays in milliseconds after typing before the grid starts a combined filter search. | 250 (minimum) | Application |
| CombinedFilterEqualTo | Uses an Equal to condition in the combined filter query when the default filter condition is Equal to. | Yes No | Application |
| ConditionalLayout- LookupBehaviour | Uses data or translated value for conditional formatting conditions. | transl data | Application |
| CountNullValues | Counts null values in grid summaries. | Application | |
| CRReportZoom | Changes the default zoom level crystal reports are opened with. | 1 for 100% 2 for 200% etc. | Application |
| CustomDateMask | Specifies a custom date mask used by the GUI to display date values. If no CustomDateTimeMask is specified, this mask is also used for the date part of datetime values. | See: standard, custom, e.g.: dd-MM-yy | Application |
| CustomDateTimeMask | Specifies a custom datetime mask used by the GUI to display datetime values. Separate the date and the time part of the mask using the '|' character. | See: standard, custom, e.g.: dd-MM-yy|H:mm:ss | Application |
| CustomTimeMask | Specifies a custom time mask used by the GUI to display time values. If no CustomDateTimeMask is specified, this mask is also used for the time part of datetime values. | See: standard, custom, e.g.: H:mm:ss | Application |
| DefaultDir | The location used by the file chooser when a file has to be selected for the first time. | Path to location | Application |
| DeleteAppointmentTaskScheduler | In the Resource Scheduler, this extended property links a task that has to be executed when an appointment is deleted using the Delete key. | The name of the task that has to be executed. | Global |
| DevReportZoom | Changes the default zoom level devexpressreports are opened with. | 1 for 100% 2 for 200% etc. | Application |
| DisableFilterOnDetails | Disables the option to filter on details in the Combined Filter. | Yes No | Application |
| DisableZoomIn | When 'yes', disables zooming in by double clicking on a tab header or grid row. | Yes No | |
| EmbedImagesInHtml | Embeds images in the HTML control using Base64 encoding. | Yes No | Application |
| EnableDetail- StartEmptyWithFilter | Application | ||
| EnablePaging | Reads out data from the database in pages. | Yes No | Application |
| EnableRefreshAll- AfterExecute | Application | ||
| EnterEditorBehavior | Defines the cursor/selection behavior of a cell in the grid when it receives the keyboard focus in edit mode. | SelectAll CursorOnEnd | Application |
| ExecutionMode | Application | ||
| ExportConditional- Formatting | Export conditional formatting when the file format supports this, for instance, Excel. | Yes No | Application |
| ExportCopyTo- ClipboardOnly | Only export columns with CopyToClipboard = true by default. The user is able to select additional fields using the advanced export. | Yes No | Application |
| ExportFilenameFormat | Sets the default filename (optional extension) for export files. | Use {0} for the plural translation and {1} for the current DateTime, e.g.: {0} - {1:yyyyMMdd} Default: {0}.xls See: string format | Application |
| ExportIDDefault | Sets the initial state for exporting to datavalues instead of displayvalues. | Yes No | |
| FloatingDocumentSize | Sets the start size for floating documents. | The default size is 900 x 700 | |
| FocusableFormButtons | |||
| FocusCombinedFilter- OnStartEmptyWithFilter | |||
| FocusSelectedField | When opening the filterform, this determines whether the focus is set to the selectedIndex of the form you came from or to the first editable field. | Yes No | Application |
| FormAlignmentOfNumbers | Alignment of all numeric fields in forms, regardless of the domain (the domain setting Alignment only affects grids). | left right | Application |
| FormProgressBar | Displays a progress bar in forms. | Yes No | Application |
| ForceRecompile | Universal GUI Indicium This extended property accepts a comma-separated list of table/view names and forces the SQL Server to always recompile the query plan for the specified tables/views. This could fix performance issues. Since Indicium uses parameterized queries, the SQL Server sometimes reuses existing query plans when it shouldn't, leading to the queries taking much longer than necessary. Note that forcing recompilation of the query plan causes a small performance hit as well, so only use it when there is a performance issue and this measure makes a noticeable difference. | Global | |
| GDIObjectLimit | Specifies a limit for the number of GDI objects in use which when exceeded will block new controls from being created. | Any positive integer 0 = unlimited Default: 8000 | |
| GMapAPIKey | |||
| HideAsyncTaskPopup | When this parameter is set to 'yes', then the async task will run in the background. The running task popup will no longer be shown when the user starts an async task. | Yes No | Global |
| HideDocumentTabHeaders | Indicates whether the document tabheaders should be shown. Not needed on a single document application without quickbar. | Yes No | |
| HideOfflineTasksReadonlyParameters | Hides all read-only task parameters when offline. This way, you don't have to create a duplicate offline available task that does not contain these read-only task parameters. | - | Application |
| HideOpenDocuments | Only available for Universal GUI. Hides the open documents that are shown on top of the sidebar or tile menu. | - | Global |
| HostedInAzure | Universal GUI Indicium Indicates whether the GUI is hosted in Azure. DevExpress reporting requires this to be true running in Azure. | Yes No | |
| IgnoreDiacritics | Whether the GUI should ignore diacritics when using the combined filter. Note that this setting is only supported for NVARCHAR (DB2: VARGRAPHIC, Oracle: NVARCHAR2) columns. | Yes No | Application |
| IsolationLevel | Universal GUI Indicium Indicium Basic The isolation level that is used for the database connection. | ReadUncommitted ReadCommitted RepeatableRead Serializable Snapshot | Application |
| KeepAddingInGrid | Restores the cursor to the add row after inserting a new record in the grid. This enables continuous adding new rows. | Yes No | |
| KeepAliveSession | The interval in ms used by the GUI in an open browser(tab) to poll to the web-server to keep the current user session alive. This interval should be less than the Session timeout of IIS. | Default: 300000 (5 minutes) 0 = off | |
| LargeRibbonEditButton | Lets the Edit button of the ribbon show up as a large button. | Yes No | |
| LogoffUrl | URL to go to after logoff. | ||
| LogSeverity | Use this parameter in combination with the WriteLogToFile parameter. It determines the log level. Info is the most detailed level. | Error Warning Info | Global |
| LookupDialogModal | If 'no', then the lookup dialog won't block the UI when the source of the lookup dialog is not in edit mode. | Yes No | |
| LookupDialogSize | Sets the default size for all lookup dialogs. | The default size is 900 x 480 | |
| MapQuestApiUri | Licence Uri to be able to use the Maps component. | Request a key here: MapQuest Developer | Application |
| MaxNoOfRecords | Maximum number of records to display. | 250 | Application |
| MergedMenus | |||
| MonitorProcess | Forces a memory flush after starting up the GUI and closing a screen to decrease apparent memory usage in the Windows Task Manager. | ||
| MSWordConnVarName | Connection variable name for Word reports. | TSFTOWORD_CONN | Application |
| MSWordMacroName | Macro to run for Word reports. | /mTSFReport_0 | Application |
| MSWordSQLVarName | SQL variable name for Word reports. | TSFTOWORD_SQL | Application |
| MultiselectParameterID | Universal GUI Indicium ID of the parameter to use as the multiselect parameter when executing a task for multiple selected rows. The parameter needs to be of type XML and PopupForEachRow should be disabled. | ||
| NoApplicationsDE/ENG/NL | Custom text of the message shown when the IAM user has no rights to a single GUI Application in German/English/Dutch. | ||
| NoAsyncReportPreload | Prevents a dummy Crystal Reports report from being preloaded asynchronously so that no SMApiAgent.dll error message is shown. | Yes No | |
| NoClaimableApplicationMessageENG | Allows IAM users to set a customized message to let their users know if all of their applications are already in use. If this parameter is not used, the default error message will be "All applications for this user are currently in use." | String-value of the desired custom message for no claimable applications. | Global |
| OAuthRedirectURI | Changes the standard OAuth login connector redirect URI (http://localhost/oauth-callback). | A redirect URI | Application |
| PageSize | Size of pages shown in the Web GUI grids. | 0 25 | Application |
| PrefilterLookupBehaviour | Uses data or translated value for prefilter conditions. | transl data | Application |
| PreviewerToolbarVisible | Specifies whether the top toolbar in a previewer component is visible. | Yes No | |
| PreviewerWebCacheAgeDays | Number of days that documents, loaded with the web previewer, should be cached. 0 or lower will not disable the cache, but will clean all documents when the screen containing the previewer is closed. | ||
| QuickbarDisplay | Determines the initial state of the Quickbar. The option 'opened' will cause the default behavior (visible quickbar), 'closed' will collapse the quickbar but leave it expandable, and 'hidden' will remove the quickbar entirely. | opened closed hidden | |
| RefreshLookupsOn- TabSwitch | Refreshes lookup data when switching between detail tab pages. | ||
| RefreshOnTabSwitch | Refreshes data when switching between detail tab pages. | Yes No | |
| RepeatOfflineTasks | Repeats an offline available task after execution. The task should be marked as Offline executable. This setting allows the user, for example, to scan an entire store stock very quickly with a barcode scanner. | Yes No | Application |
| ReportContentLocale | Crystal Reports Influences the display format of dates and decimals within the report without a custom format. | System - System language settings are used. For an ASP GUI, this will be the language of the web-server. User - Language of the user is used. English/ENG: American English format is used for everyone e.g., 02/13/2015. Dutch/NL: Dutch format is used for everyone e.g., 13-02-2015. German/DE: German format is used for everyone e.g., 13.02.2015. | |
| RibbonDisplay | Determines the initial state of the Ribbon. The option 'opened' will cause the default behavior (visible ribbon) and 'closed' will collapse the ribbon but leave it expandable. | opened closed | |
| RowNotFoundAction | Determines the action performed by the GUI when an inserted or updated row cannot be found due to the filters which are active on the subject. | None ShowInfoMessage - Shows information with a button which performs the FilterRow behavior FilterRow - attempts to remove active filters and add a filter on the PK of the row. | Application |
| RunAsyncTasksInSequence | Allows asynchronous task or report execution to commence only after the currently running asynchronous task or report has been completed. Note: only available for Windows applications for now. | Yes No | Application |
| SchedulerPeriodInYears | Sets the period to look ahead from the current date in the Scheduler component to a number of years. Note that displaying many appointments in the future may decrease the performance. | 2, 3, 4, or 5. Default: 1. | Global |
| Session.[session_variable] | Universal GUI Indicium Indicium Basic Add session variables. A guid session variable is available by default to uniquely identify a user session. You can use the value of a session variable in your SQL business logic or prefilters using the SESSION_CONTEXT function, e.g. select session_context(n'guid'). | Application | |
| ShowButtonbarIndicator | Shows or hides extra icon with tooltip on buttonbars to indicate the type of buttonbar, e.g., task, report or prefilter. | Yes No | Application |
| ShowColumnHeaderMenu | |||
| ShowContextColumns | Shows foreign key fields to parent in child forms. | Yes No | Application |
| ShowCopyButton | Shows or hides the Copy button. | Yes No | Application |
| ShowMessageNoCurrent- RowInParent | Shows the no_current row message for parent rows: "The selected row is no longer present". | Yes No | Application |
| ShowNavigationButtons | Shows or hides the Navigation buttons underneath the form. | Yes No | Application |
| ShowPrefiltersInTitle | Shows active prefilters in the document title. | Yes No | Application |
| ShowTitleActiveChart | Shows the cube title in the active graph. | Yes No | Application |
| ShowVerticalGridlines | Draws vertical grid lines when grid line color is set. | Yes No | Application |
| ShutdownProcedure | A shutdown procedure for each application when the GUI is closed. | The name of the stored procedure | Application |
| SmallDetailTiles | Allows the user to make detail tiles smaller in size instead of the default medium-sized tiles in Windows and Web. | Yes No | Global |
| SQLStringCase | Case of the cursor-, col-, ref- and task parameters in stored procedures. | upper lower | Application |
| SsrsPreferDefault- DisplayMode | When this parameter is specified as true, the Windows GUI is instructed not to open SSRS reports in the print layout mode when previewing. | Yes No | Application |
| SsrsReportServer | Universal GUI Indicium Indicium Basic Specifies the location of the SSRS Server to use for remote SSRS reports inside an application. | Application | |
| StartupProcedure | A startup procedure for each application that is started. | The name of the stored procedure. | Application |
| Theme | Non-default theme to load. Useful when developing new themes. | theme id | Application |
| TilesMenuBackgroundScaling | Scaling for the tiles menu background image. By default the image stretches. The 'Centered' option keeps the image in the center but it does not scale. The 'Tiled' option keeps the image in the top left corner and does not scale. Tiled does repeat the background, so you might see multiple images when the screen gets too large. | Centered Tiled | Application |
| Translate | Shows translation for all transl_objects. | Yes No | |
| UniformTabHeaderAreaColor | Overrides default behavior of Windows GUI to auto-derive the tab header background area color by always using the modeled document background color instead. | Yes No | |
| UsageTimeout | Duration in minutes the user may work in the current session. | Default: 0 | |
| UseAllowNavigation- AsRights | Handles "Allow Navigation" of a subject as rights to deny any form of navigation to another row. Default the grid keeps navigating. | Yes No | Application |
| UseAlternateRowColor | Toggles alternative row color in the grids of an application. | Yes No | Application |
| UseCubeHorizontalScrollbar | Sets the horizontal scrollbar of the cube to scroll over the whole width instead of the cells. | Yes No | Application |
| UseCurrentRowBreadcrumb | Shows the current row of the focused table in the breadcrumb bar. | Yes No | Application |
| UseExportLayouts | Uses layout concept when exporting, so hidden fields are not exported. | Yes No | Application |
| UseISOweekgroupintervals | Uses the ISO standard week numbering system. | Yes No | Application |
| UseManualIconSizeTabHeader | Use the manual height set for document and tab headers as icon size and not as padding for the tabs. | Yes No | Application |
| UseOnlyLockedPrefilterForRefresh | Apply only locked prefilters after an automatic refresh. When changed to No, all prefilters are applied after an automatic refresh. | Yes No | Application |
| UserObjectLimit | Specifies a limit for the number of user objects in use, which when exceeded will block new controls from being created. | Any positive integer, or zero if the number of user objects should be ignored. Default: 8000 | Global exclusive |
| UseUsrLibl | Universal GUI Indicium Indicium Basic Sets connection string LibraryList using [database], USRLIBL for IBM i DB2 connections. | Yes No | Application |
| WebGuiURL | Specifies the Web GUI base URL so a deep link URL can also be created in the Windows GUI. In the Web GUI this feature is available by default. (see: Sharing a record). | Format: https:///. | |
| WriteLogToFile | To enable the DevExpress logging. The log file can be found in folder {Application}/Logs/. This parameter must be combined with a setting for the LogSeverity parameter. | Yes No | Global |