The Expression Editor includes a feature that lets you generate expressions for interacting with your data source, saving you having to write them manually and minimising the risk of incorrect syntax.
Before launching the Data Source Expression wizard, make sure you have created aliases and variables for your data source fields.
To access this feature, right-click inside the expression editor and select Intellisense > Create Data Source Expression from the context menu. This will open the Create a Data Source Expression wizard.
The Data Source Expression wizard.
Use the drop-down menu at the top of the dialog to select the data source you want the expression to interact with.
If one or more options in the Expression section of the window are unavailable it means that you have selected a data source that is not compatible with that function.
On completion of the wizard the new expression will be added to the editor, at which point you can make additional changes to the code if required.
To learn how to use the wizard and determine what the expression should do, refer to the following topics:
| Description | Further Reading |
|---|---|
| Manually write data to the selected data source, or generate the expression automatically using a wizard. | Adding or Updating Data Source Rows |
| Manually delete rows from the selected data source, or generate the expression to permanently delete the data source rows using a filter. | Deleting Data Source Rows |
| Manually write or generate an expression that returns the number of rows that match a specified filter, or executes True or False, indicating whether the function was able to find at least one matching row. | Retrieving Rows from a Data Source |
| Manually write or generate an expression to pass data between KnowledgeKube and a data source table. Depending on how the expression is written it can be used to add new rows to a table or update existing ones. | Call a Stored Procedure |