Expression Builder

The Expression Builder is conveniently located within Nodes where you have the option to manipulate Attributes, filter existing ones, or execute On-demand Queries on Tables, Windows, or Aggregations. Whenever a Node allows for the manipulation of data via Attributes, the Expression Builder is there to facilitate your needs. This section will guide you through using the Expression Builder, ensuring you can efficiently embed complex logic into your Applications.

Expression Builder is in Multiple Nodes

Located within Nodes for creating new Attributes using Built-in Functions, filtering data, and executing On-demand Queries. Essential for data manipulation.

Using the Expression Builder

Whenever you need to write functions or put filters on Cortex Nodes, you will encounter the Expression Builder.

0. Connected Node Attributes

These are Attributes relayed from Nodes already connected in your Application. It is to aid in creating logical expressions and functions, the Builder provides a list of Connected Node Attributes.

All the Attributes you can use on the Expression Builder is conveniently placed at top of every Expression Builder.

We strongly suggest that you utilize Connected Node by clicking onto Attributes you want to use as in same Nodes (Table, Join, Pattern, and Sequence); each attribute may come (e.g.attribute_3) with their associated Node names (e.g.stream_2.attribute_3). You should construct your expression using the latter format in order to create expressions without errors.

1. Click Edit Button

To start creating your filter/functions; first you need to press the Edit button in the corresponding section below the Expression Builder. Now, the Expression Builder can be utilized to fill the the blanks for the activated filter/function.

2. Use the Input Area to Freely Construct Your Logic

When you're ready to insert a function or filter into your Node, simply click the 'Edit' button on the user-input field. This action opens the Expression Builder where you can write and refine your function. Once you're satisfied, clicking 'Save' applies your logic to the Node.

3. Built-in Functions

Cortex comes equipped with a wide array of Built-in Functions, covering various operations and manipulations you might need for your Attributes. Whether it's mathematical, string, or logical operations, the Expression Builder gives you access to these tools. For the comprehensive list cf. Built-in Functions

Finding the right Built-in Function(s) is straightforward. You can use the search bar to quickly look up functions by name, helping you locate the exact tool you need for your specific task.

4. Logical Operators

The bread-and-butter logical operators are also conveniently in the Expression Builder.

5. Save or Clear Your Expression

When you're ready to save the expression you just created, simply click the 'Save' button on the user-input field. This action opens the Expression Builder where you can write and refine your function. Once you're satisfied, clicking 'Save' applies your logic to the Node.

6. Automatic Validation

To ensure the accuracy and functionality of your input, Cortex includes an Expression Validator. This tool checks your function or filter against the Built-in Function input attribute types. This validation step is crucial for maintaining the integrity and reliability of your Application.

If there's a mismatch or an error with your expression, you'll receive an immediate error message prompting you to correct the issue.

7. Further Edits

By utilizing Steps 1-7 as starting with the Edit Button and finishing with the Save button; you can edit your expressions as many times as you nedd.

Benefits

The Expression Builder is a testament to Cortex's commitment to providing a user-friendly and powerful environment for real-time data processing. By understanding and utilizing this tool, you can significantly enhance the functionality and efficiency of your Applications. As you become more familiar with the range of Built-in Functions and the flexibility of the Builder, you'll find yourself able to implement increasingly sophisticated and tailored data processing logic within your Applications.