Skip to main content

Extended properties

Introduction to extended properties

Extended properties are settings for features in the Thinkwise Platform that have not yet been formalized in the Software Factory model. You can use the parameters below as extended properties in the Software Factory and Intelligent Application Manager.

Extended properties in the Software Factory

In the Software Factory, you can use extended properties in a runtime configuration. This way, you can configure multiple environments for an application. For more information about runtime configurations, see Runtime configurations.

To add an extended property to a runtime configuration:

menu Maintenance > Runtime configurations > tab Extended properties

  1. Add the extended property.
  2. Enter a value.
  3. Universal GUI If necessary, clear the checkbox Expose to front-end. Disabling this setting will exclude the extended property from the user interface. APIs, for example, do not need GUI information.

Extended properties in IAM

A few properties only work when set in IAM since they need to be loaded before the GUI is shown. In the list of available extended properties, these are marked as global.

To add an extended property to a global configuration in IAM:

menu Settings > Global configurations > tab Extended properties

  1. Add the extended property.
  2. Enter a value.
note

If you specify application-specific parameters in the Global configurations, they will be used by all applications.

Available extended properties

In the table below, the options Yes and No have the following alternatives:

  • Yes
    • true
    • 1
  • No
    • false
    • 0

The options highlighted in bold represent the default settings.

ParameterDescriptionOptionsScope
AllowChangePasswordDetermines if users with RDBMS login are allowed to change their password
Note: only available for SQL Server now.
Yes
No
AllowNullMandCheckboxMandatory fields without a default value will be represented as null in the Grid and Form while adding a new row.Yes
No
Application
AllowProcessFlowsInLookupDialogsBy 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
AllowWildcardsAllows the use of wildcards * and ? in find, search and filter fields.Yes
No
Application
AnalyticsEnabledEnable or disable Matamo analytics JavaScript.Yes
No
AnalyticsWebsiteIDMatamo Website ID.2
AnimationsAnimation Quick Bar when expanding groups.Yes
No
ApplyConditionalLayoutAvailable as a Conditional layout--
AuthenticationThe 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
AutoExpandGroupsControls 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 therefore, it is an opt-in.Yes
No
Application
AutoLimitColumnSelectionActivates still experimental feature to limit the select clause in SQL queries to those columns used by visible components on the screen. Version 2018.1 and higher.Yes
No
Application
BreadcrumbInPrintPreviewWhen enabled and a breadcrumb navigation path is available, it will be included in the print preview and printout of charts and cubes (pivot tables).Yes
No
Application
BringGUIToFrontWhether the GUI should claim focus on startup or stay in background.Yes
No
Global exclusive
CachePathA 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
CCSIDUniversal 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 ‚¬
ClearReportDataSourceUniversal GUI Indicium Indicium Basic The name of the default data source to be used on the server where Clear Reports is installed. The data source needs to be added on the server and can be used if credentials cannot be parsed, for instance when Kerberos is used.
ClearReportPortUniversal GUI Indicium Indicium Basic The port of the server where Clear Reports is installed.Application
ClearReportServerUniversal GUI Indicium Indicium Basic The server where Clear Reports is installed.Application
ClearReportUriUniversal GUI Indicium Indicium Basic The path to the server where Clear Reports is installed.Application
CombinedFilterDelayDelays in milliseconds after typing in the Search field before the grid starts the search.250 (minimum)Application
CombinedFilterEqualToUses an Equal to condition in the Search field instead of Contains.Yes
No
Application
ConditionalLayout-
LookupBehaviour
Uses data or translated value for conditional layout conditions.transl
data
Application
CountNullValuesCounts null values in grid summaries.Application
CRReportZoomChanges the default zoom level crystal reports are opened with.1 for 100%
2 for 200% etc.
Application
CustomDateMaskSpecifies a custom date mask the GUI uses to show 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
CustomDateTimeMaskSpecifies a custom datetime mask the GUI uses to show 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
CustomTimeMaskSpecifies a custom time mask the GUI uses to show 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
DefaultDirThe location used by the file chooser when a file has to be selected for the first time.Path to locationApplication
DeleteAppointmentTaskSchedulerIn 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
DevReportZoomChanges the default zoom level devexpressreports are opened with.1 for 100%
2 for 200% etc.
Application
DisableKeyboardForAutoCompleteComboUniversal GUI When 'False', a keyboard will appear when opening a lookup with a Combo control on a mobile device.True
False
Application
DisableFilterOnDetailsDisables the option to filter on details with the Search field.Yes
No
Application
DisableGridRowHeightSafeguardsUniversal GUI Overrides the default row height safeguards for usability and layout in the grid.
Note: When you disable these safeguards, it becomes your responsibility to ensure that all the content in the grid fits well and looks nice. The setting also affects the values at the bottom of the grid. You might need to adjust the height to make sure you can clearly see these values. Check this carefully when testing this setting.
Yes
No
Application
DisableZoomInWhen 'Yes', disables zooming in by double clicking on a tab header or grid row.Yes
No
Application
EmbedImagesInHtmlEmbeds images in the HTML control using Base64 encoding.Yes
No
Application
EnableDetailStartEmptyWithFilterOpens the detail without retrieving data and sets the focus on the filter pop-up.Yes
No
Application
EnablePagingReads out data from the database in pages.Yes
No
Application
EnterEditorBehaviorDefines the cursor/selection behavior of a cell in the grid when it receives the keyboard focus in edit mode.SelectAll
CursorOnEnd
Application
ExecutionMode- Developer: This mode provides extra options that are accessible in the Developer tab of the ribbon.
- EndUser: This mode hides developer-specific functionality.
Developer
EndUser
Global
ExportConditional-
Formatting
Export conditional layout when the file format supports this, for instance, Excel.Yes
No
Application
ExportCopyTo-
ClipboardOnly
Only export columns with CopyToClipboard = true by default. The user can select additional fields using the advanced export.Yes
No
Application
ExportFilenameFormatSets 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
ExportIDDefaultSets the initial state for exporting to datavalues instead of displayvalues.Yes
No
FloatingDocumentSizeSets the start size (height x width) for floating documents in pixels, for example, '200 x 400'.The default size is 900 x 700 pixels
FocusableFormButtonsSets the focus on the buttons.Yes
No
Global
FocusCombinedFilterOnStartEmptyWithFilterSets the focus on the Search field (if available) when opening a screen or detail. No data is retrieved and the option Start empty with filter is activated for the main subject or EnableDetailStartEmptyWithFilter in activated for a detail subject.Yes
No
Global
FocusSelectedFieldWhen opening the filter form, 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
FormAlignmentOfNumbersAlignment of all numeric fields in forms, regardless of the domain (the domain setting Alignment only affects grids).left
right
Application
FormProgressBarWindows GUI Shows a progress bar in forms. You can apply conditional layouts to the progress bar.Yes
No
Application
ForceRecompileUniversal 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
GDIObjectLimitSpecifies 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
GridEditUpdateUsingRefreshOptionWindows GUI When editing in a grid with auto-edit enabled, values are updated when a user edits data based on the data on the active row by default. To update using the Refresh behavior instead (menu User interface > Subjects > tab Default/Variants > tab Settings > tab Performance > group Refresh), set this parameter to 'yes'. Note that this property is present only for backward compatibility.Yes
No
Global
HideAsyncTaskPopupWhen this parameter is enabled, the async task will run in the background. The running task pop-up will no longer be shown when the user starts an async task.Yes
No
Global
HideDocumentsOfInactiveApplicationWindows GUI Hides open documents when you switch to another application in IAM. When you return to your previous application, the open documents will become visible again. Documents hidden in this way still occupy their full memory footprint.Yes
No
Global
HideDocumentTabHeadersIndicates whether the document tab headers should be shown. Not needed on a single document application without quickbar.Yes
No
HideMenuImageUploadUniversal GUI Hides columns with the domain control Image Upload from the overflow menu in the card list.Yes
No
Application
HideOfflineTasksReadonlyParametersUniversal GUI Hides all read-only task parameters when offline. This way, you do not need to create a duplicate offline available task without the read-only task parameters.Yes
No
Application
HostedInAzureUniversal GUI Indicium Windows GUI Web GUI Indicates whether the GUI is hosted in Azure. DevExpress reporting requires this to be enabled when running in Azure.Yes
No
IgnoreDiacriticsIgnore diacritics when using Search.
- GUI support for SQL server (NVARCHAR), DB2 (VARGRAPHIC), Oracle (NVARCHAR2).
- Indicium support for SQL server (NVARCHAR, VARCHAR, TEXT, CHAR, NTEXT, NCHAR).
Yes
No
Application
IndiciumIncludeApplicationIdInCacheWindows GUI Indicium Basic Prevents a problem with changed file storage folders in IAM. See Troubleshooting file storageYes
No
Global
IndiciumModelContainsFileStorageFoldersWindows GUI Indicium Basic Prevents a problem with changed file storage folders in IAM. See Troubleshooting file storageYes
No
Global
IndiciumRequestTimeoutWindows GUI Indicium Basic The interval in milliseconds of the timeout for Windows - Indicium Basic connections.Default: 100
Infinite: -1
IsolationLevelUniversal GUI Indicium Indicium Basic The isolation level that is used for the database connection.ReadUncommitted
ReadCommitted
RepeatableRead
Serializable
Snapshot
Application
KeepAddingInGridRestores the cursor to the add row after inserting a new record in the grid. This enables continuous adding new rows.Yes
No
KeepAliveSessionThe 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
KeyBindingsSpecifies keyboard navigation. Choose Classic for navigation as in the Windows GUI. The default value, Modern, uses the standard Universal navigation. See Keyboard shortcuts.Classic
Modern
Application
LargeRibbonEditButtonLets the Edit button of the ribbon show up as a large button.Yes
No
LogoffUrlURL to go to after logoff.
LogSeverityUse this parameter in combination with the WriteLogToFile parameter. It determines the log level. Info is the most detailed level.Error
Warning
Info
Global
LookupDialogModalWindows GUI If 'no', then the lookup dialog will not block the UI when the source of the lookup dialog is not in edit mode.Yes
No
LookupDialogSizeSets the default size for all lookup dialogs.The default size is 900 x 480
LookupGridHeaderFilterOptionsLimitUniversal GUI Defines the flip-over point: the number of items to switch from a list of checked items to a dropdown list with search functionality.Default: 25.Application
MapQuestApiUriLicense Uri to be able to use the Maps component.Request a key here: MapQuest DeveloperApplication
MaxNoOfRecordsMaximum number of records to show.250Application
MergedMenusMerges all application menus into a single menu for users with access to multiple applications.Yes
No
Global
MonitorProcessForces a memory flush after starting the GUI and closing a screen to decrease apparent memory usage in the Windows Task Manager.
MSWordConnVarNameConnection variable name for Word reports.TSFTOWORD_CONNApplication
MSWordMacroNameMacro to run for Word reports./mTSFReport_0Application
MSWordSQLVarNameSQL variable name for Word reports.TSFTOWORD_SQLApplication
MultiselectParameterIDUniversal 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/NLCustom text of the message shown when the IAM user has no rights to a single GUI Application in German/English/Dutch.
NoAsyncReportPreloadPrevents a dummy Crystal Reports report from being preloaded asynchronously so that no SMApiAgent.dll error message is shown.Yes
No
NoClaimableApplicationMessageENGAllows 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
OAuthRedirectURIChanges the standard OAuth login connector redirect URI (http://localhost/oauth-callback).A redirect URIApplication
OpenLinksInUrlControlOnSameTabUniversal GUI When enabled, links in the URL control will open in the GUI's browser tab. When disabled, it will open in a new browser tab.Yes
No
Application
OpenLookupsFullScreenUniversal GUI When enabled, all lookup pop-ups will appear bigger, covering about 90% of the screen.Yes
No
Application
PageSizeSize of pages shown in the Web GUI grids.0
25
Application
PrefilterLookupBehaviourUses data or translated value for prefilter conditions.transl
data
Application
PreviewerToolbarVisibleSpecifies whether the top toolbar in a previewer component is visible.Yes
No
PreviewerWebCacheAgeDaysNumber 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.
QuickbarDisplayDetermines 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.
RefreshOnDocumentSwitchUniversal GUI Refreshes an already opened document when you re-visit it.
This extended property generates a lot of server load in a multi-user environment. Instead, consider using a process flow or auto-refresh with change detection. See:
- Auto-refresh
- Change detection
Yes
No
Application
RefreshOnTabSwitchUniversal GUI Refreshes data on an already opened detail tab when you re-visit it.
This extended property generates a lot of server load in a multi-user environment. Instead, consider using a process flow or auto-refresh combined with change detection. See:
- Auto-refresh
- Change detection
Yes
No
Application
RepeatOfflineTasksRepeats 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
ReportContentLocaleCrystal 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.
RibbonDisplayDetermines 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
RowNotFoundActionDetermines 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
RunAsyncTasksInSequenceAllows 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
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
SchedulerPeriodInYearsUniversal GUI Specifies how many years the Scheduler should look ahead. Without this extended property: 1 year.A number, maximum 5.Application
ShowButtonbarIndicatorShows or hides extra icon with tooltip on buttonbars to indicate the type of buttonbar, e.g., task, report or prefilter.Yes
No
Application
ShowColumnHeaderMenuMakes column headers show their own context menu instead of the grid's context menu. Right-clicking the header or clicking the three dots (...) within it opens this specific context menu.Yes
No
Global
ShowContextColumnsShows foreign key fields to parent in child forms.Yes
No
Application
ShowCopyButtonShows 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
ShowNavigationButtonsShows or hides the Navigation buttons underneath the form.Yes
No
Application
ShowPrefiltersInTitleShows active prefilters in the document title.Yes
No
Application
ShowTabIconsUniversal GUI Shows the tab icons for detail tabs (inherited from the table) and tab containers (explicitly assigned in the screen type). Icons on a tab are hidden by default. See also Screen component settings.Yes
No
Application
ShowTitleActiveChartShows the cube title in the active graph.Yes
No
Application
ShowVerticalGridlinesDraws vertical grid lines when grid line color is set.Yes
No
Application
ShutdownProcedureA shutdown procedure for each application when the GUI is closed.The name of the stored procedureApplication
SmallDetailTilesAllows the user to make detail tiles smaller than the default medium-sized tiles in Windows and Web.Yes
No
Global
SQLStringCaseCase of the cursor-, col-, ref- and task parameters in stored procedures.upper
lower
Application
SsrsPreferDefault-
DisplayMode
When this parameter is enabled, the Windows GUI is instructed not to open SSRS reports in the print layout mode when previewing.Yes
No
Application
SsrsReportServerUniversal GUI Indicium Indicium Basic Specifies the location of the SSRS Server to use for remote SSRS reports inside an application.Application
StartupProcedureA startup procedure for each application that is started.The name of the stored procedure.Application
ThemeNon-default theme to load. Useful when developing new themes.theme idApplication
TilesMenuBackgroundScalingScaling for the tiles menu background image. By default, the image stretches and does not scale. The 'Centered' option keeps the image in the center. The 'Tiled' option keeps the image in the upper-left corner. 'Tiled' repeats the background, so you might see multiple images when the screen gets very large.Centered
Tiled
Application
TranslateShows translation for all transl_objects.Yes
No
UniformTabHeaderAreaColorOverrides 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
UsageTimeoutDuration 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
UseAlternateRowColorToggles alternative row color in the grids of an application.Yes
No
Application
UseCubeHorizontalScrollbarSets the horizontal scrollbar of the cube to scroll over the whole width instead of the cells.Yes
No
Application
UseCurrentRowBreadcrumbShows the current row of the focused table in the breadcrumb bar.Yes
No
Application
UseExportLayoutsUses layout concept when exporting, so hidden fields are not exported.Yes
No
Application
UseISOweekgroupintervalsUses the ISO standard week numbering system.Yes
No
Application
UseManualIconSizeTabHeaderUse the manual height set for document and tab headers as icon size and not as padding for the tabs.Yes
No
Application
UseOnlyLockedPrefilterForRefreshApply only locked prefilters after an automatic refresh.
When changed to No, all prefilters are applied after an automatic refresh.
Yes
No
Application
UserObjectLimitSpecifies 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: 8000Global exclusive
UseUsrLiblUniversal GUI Indicium Indicium Basic Sets connection string LibraryList using [database], USRLIBL for IBM i DB2 connections.Yes
No
Application
WebGuiURLSpecifies 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:///.
WriteLogToFileTo 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

Was this page helpful?