Pro Tip #1: Filtering Data with RHEA Queries

When dealing with large datasets in Masha using Cignal Ultra’s RHEA queries, you may want to filter your data to focus on specific information. With RHEA filters, you can easily narrow down your search and retrieve only the data that matters. For instance, to get all records where the ‘Country’ column equals ‘USA’, use the following query:

rhea filter Country equals "USA"

Pro Tip 2: Sorting Data with RHEA Queries

Sorting your data is essential when analyzing trends or comparing different elements. Use the RHEA ‘sort’ command to arrange your data based on various columns. For example, to retrieve all records sorted by the ‘Date’ column in descending order, use:

rhea sort -desc Date

Pro Tip 3: Combining Filters and Sorting with RHEA Queries

You can combine filters and sorting commands to create more complex queries. For instance, to get all records for the ‘USA’ country sorted by the ‘Date’ column in descending order, use:

rhea filter Country equals "USA" | rhea sort -desc Date

Pro Tip 4: Using Regular Expressions with RHEA Queries

RHEA supports regular expressions to perform text matching and pattern recognition. For example, to retrieve all records where the ‘Message’ column contains the word ‘Error’, use:

rhea filter /Message/i contains "Error"

Pro Tip 5: Combining Regular Expressions with Filters and Sorting

You can combine regular expressions, filters, and sorting commands to create advanced queries.