AdaptableOptions provides all the layout, DataGrid, config and other information required to ensure a full, rich user experience.
This is the only object created that AdapTable requires to initialise and run; it is set up by developers at design-time and injected into the AdapTable constructor at startup.
AdaptableOptions class contains a few regular properties of which 2 (
primaryKey) are mandatory - and a number of
xxxOptions properties where the type is itself a collection of related properties.
Typically users will only populate a few of the properties in
AdaptableOptions, and only a few properties in each class.
Any property that is not supplied by the user when populating the object, will use the default value (which is listed here for each property).
All properties are optional with the exception of
The current contents of
|adaptableId||A unique ID for this instance of AdapTable|
|adaptableStateKey||A localStorage key for storing of AdaptableState|
|predefinedConfig||User State shipped with AdapTable instance for first use|
|primaryKey||Name of a column guaranteed to contain unique contents|
|userName||The current AdapTable user (useful for Audit purposes)|
|vendorGrid||Underlying vendor grid object (e.g. GridOptions for ag-Grid)|
|auditOptions||Audit Log related options|
|chartOptions||Chart-based options (used when using chart plugin)|
|editOptions||Editing (and server-editing) related options|
|exportOptions||Export and reporting related options|
|filterOptions||Options relating to filtering functionality in AdapTable|
|generalOptions||General set of Options (e.g. for managing Primary Keys|
|layoutOptions||Layout (Views) related Options|
|queryOptions||Options when running a Query ( Expression ) in AdapTable|
|searchOptions||Search-related options (e.g. for managing Server searching)|
|stateOptions||Series of functions to allow you to manage AdapTable State|
|teamSharingOptions||Enables 'Team Sharing' of AdapTable objects among colleagues|
|userFunctions||Implementations of User Functions which are referenced in Config|
|userInterfaceOptions||User Interface related functions (e.g. menus, toolbars)|
|plugins||Options used by the AdapTable plugins (e.g. charting, finance)|
|customPredicateDefs||Custom predicates provided by devs (e.g. for filters, alerts etc.)|
|ipushpullPluginOptions||Options used by the ipushpull Plugin|
|glue42PluginOptions||Options used by the Glue42 Plugin|
|openfinPluginOptions||Options used by the OpenFin Plugin|
|finsemblePluginOptions||Options used by the Finsemble Plugin|
|masterdetailPluginOptions||Options used by the Master / Detail Plugin|
Identifier for this instance of AdapTable
Useful if Audit Log is turned on or you are using multiple grids
Note it cannot contain a '.' (as this value is used to name styles which raises issues if it contains a full stop).
The value provided here is also that used in the Dashboard Header.
Default Value: adaptable_id
Identifier to be used as the localStorage persistence key for the AdaptableState.
If not provided, will default to the value of the adaptableId option
Options for mananging the Audit Log.
Depending on the options you set, audit messages will send details of actions in AdapTable to an Audit destination.
Each Audit message is a combination of an
AuditTrigger and an
AuditDestination, and packaged as a simple JSON object.
You can set as many AuditTriggers as you want, and for each
AuditTrigger, select as many AuditDestinations as you require.
The 5 Audit Triggers are:
CellEdit: whenever a cell in AdapTable is changed as a result of user action
TickingDataUpdate: whenever the data in AdapTable is updated as a result of external action
FunctionEvent: whenever an AdapTable function is run (e.g. Quick Search, Smart Edit, Export)
UserStateChange: whenever a change is made to the User's state (e.g. selected a new layout)
InternalStateChange: whenever a change is made to AdapTable's internal state (e.g. new cells selected)
The 4 possible Audit Destinations are:
Http Channel: If you choose this then you need to set up the channel, on which you can subsequently listen to Audit messages using your own internal reporting software (e.g. he Elastic Stack).
Console: Audits messages to the console - useful for testing, support and debug purposes
Alert: If you set this option for any Trigger, then you can should also choose the Type (e.g. 'Success', 'Info' etc) and whether to show it as a Popup.
Event: If selected, you will be able to listen to the the
Audit Event using the Audit Event Api
Options to manage AdapTable charting.
Primarily concerned with how and where charts appear.
Options for setting the Div elements in which AdapTable and the underlying grid are placed.
Also allows you to set where popups appear relative to the page and where charts are displayed.
Predicate Definitions provided by Develoeprs at Design Time
A Predicate Definition contains a number of properties of which the most important are:
id: the unique identifier for the Predicate (a more friendly
label can also be provided)
columnScope: for which columns or DataTypes the Predicate can be applied
functionScope: which AdapTable Functions can use this predicate (e.g. Filters, Conditional Styles, Alerts etc.)
inputs: the definitions of any values the Predicate needs
handler: the actual function that will run each time the Predicate is evaluated - it will receive a `PredicateDefHandlerParams' object and return a boolean
Options related to Editing in AdapTable.
Includes a function enabling you to perform custom validation when a cell changes values.
Options for managing Exporting and Reports in AdapTable.
Related to creating and managing filters in AdapTable.
Includes options concerning whether to use AdapTable's filters (or those provided by the vendor grid).
Also contains options to set if, how and when the Grid should repaint and refilter after user data edits and ticking data edits.
General options to manage AdapTable.
Includes options for managing Server Searching, and how to manage Primary Keys.
Options related to Layouts (ie. saveable views of column order, visibility and sort).
Includes properties for whether to include vendor state in the Layout (e.g. Column Grouping) and whether layouts should save automatically or manually.
Used for managing the AdapTable Plugins.
These allow us to keep the download size of AdapTable manageable while allowing you to access only the functionality you need.
There are currently 8 plugins:
charts - a powerful charting suite based on a package from Infragistics
finance - some additional finance-related features (e.g. for cell summaries)
finsemble - a plugin designed for using AdapTable with Finsemble from ChartIQ (currently empty)
glue42 - a plugin with special functionality for working with Glue42, inclding 2-way live, validated Excel
ipushpull - features relating to ipushpull helping collaboration and data sharing
master-detail-aggrid - designed for when using the Master/Detail option in ag-Grid, so that all child grids are AdapTable instances
nocode-aggrid - powerful plugin whch enables the creation of new AdapTable instances (using ag-Grid) with no code required
openfin - designed for when using AdapTable inside the OpenFin container; contains custom functionality like 'Live Excel'
User State (a.ka.
predefinedConfig) set at design-time and shipped with AdapTable for first use.
Contains a mixture of objects and properties.
Can be either an PredefinedConfig object or a url to the file which contains the config.
See full details at Predefined Configuration
Default Value: undefined
The name of a column in AdapTable guaranteed to contain unique values.
Required for cell identification purpose when using cell summary and editing functions.
Also used by Audit Log to identify which cells have been edited.
Because AdapTable is fully data agnostic, the only way it can identify a particular cell is as a combination of Primary Key value and Column value (e.g. the user has edited in the 'Bid' column in the row where the value in the Primary Key Column is 15).
Note: The column does not need to be visible but it does need to exist in the grid's data source.
showMissingPrimaryKeyWarning property is true (the default), AdapTable will warn you at start-up if you have provided a value which does not match a column in the grid.
preventDuplicatePrimaryKeyValues property is true (the default), an error alert is triggered (and displayed) if a user attempts to enter a duplicate value into the Primary Key column.
Default Value: N/A
Options for running queries in AdapTable - known as an Expression
Lets you specify how (and how many) values are returned when doing a column lookup, how to deal with case and what is in the Query.
Also includes a callback function allowing devs to populate column lookups dynamically.
Options for managing Search in AdapTable.
Options related to state hydration / dehydration - allows users to intercept state persistence and state loading.
By default, AdapTable state is persisted in the local storage of the user browser, under the
These state options allow you to change this default behavior and also to add custom properties or behaviour in the persisted state.
Options for managing 'Team Sharing'
This allows users to create Adaptable Objects and share with colleagues
Includes 2 functions:
getSharedEntities: retrieves any available Shared Entities for the user to download
setSharedEntities: saves (essentially uploads) Shared Entities so they can be re-used by other members of the team
The actual implementations of User Functions that users reference in Predefined Config.
Predefined Config is stored as JSON - and often remotely - which means that it is not possible to store function implementations (as they are code and not strings, so cannot be serialised).
Accordingly, the pattern we use in such cases is as follows:
The section in Predefined Config (e.g. CellSummary / OperationFunction) provides the name of the function
userFunctions section of AdaptableOptions contains the implementation code itself.
Options for managing the User Interface elements of AdapTable.
Includes options for themes, menus, tool panels etc.
The name of the current AdapTable user.
Strongly recommended to be set if using remote storages (via Server Options)
Also used in Audit Log to identify the current user who has made edits or changed state.
Default Value: anonymous
This is the underlying vendor grid or grid object which AdapTable will interact with.
Depending on the vendor it is either a Grid or an Options object.
vendorGrid object should contain all the column definitions and data sources required.
Note: if you are using the React Wrapper or the Angular Wrapper then you do not need to populate this property (as
gridOptions is a separate parameter and AdapTable will wire up everything for you).
If you are using ag-Grid and want to include Enterprise modules then you should add them to the
modulesproperty of ag-Grid.
Default Value: N/A
Generated using TypeDoc