Filtering and Column Management

Column Management

The columns displayed and their order can be managed.

Filtering

Emergent allows end users to configure their lists according to their needs.  They can choose which columns to display and apply filters to organize data efficiently. Once configured, these settings— including column selection and filters—will persist for that specific list, ensuring a personalized experience for each user.

Conditional Evaluation: 

• Any Can Apply (OR Logic) – Returns records that meet at least one of the filter conditions. This works like the "OR"operator in Excel or SQL.
  • Example: If you filter by Call Sign Begins With "ME" OR Mileage is less than 100,000, the results will include:
  • All records where the call sign begins with "ME"
  • All records where the mileage is less than 100,000
  • Some records may meet both conditions, but they are not required to.
• All Must Apply (AND Logic) – Returns only records that meet every filter condition. This follows the "AND"operator in Excel or SQL.
  • Example: If you filter by Call Sign Begins With "ME" AND Mileage is less than 100,000, the results will include onlyrecords where:
  • The call sign begins with "ME" and
  • The mileage is less than 100,000

This distinction helps you control how broadly or narrowly your filters apply to the data and can be applied across filters to handle complex queries.

• Example:  I want to see all units where the call sign begins with ME and the call sign does not contain 123 OR any units that are made by Ford