In the world of big and complex data, data formats and applying filters are essential tools for effectively organizing and filtering information. This technique in the DataLexing system aims to facilitate the process of searching for and accessing the required data quickly and accurately. In this guide, we will explore how to apply formats to data in DataLexing and their benefits in organizing and filtering data effectively.
Filters
Filters in DataLexing are aimed at refining and organizing your data to quickly find the necessary information.
Filters enable the classification and precise arrangement of data based on specific criteria. They simplify the display of data by showing only the rows that meet the specified conditions, facilitating the management of vast datasets.
Filters contribute to reducing clutter and facilitating data management tasks, whether by isolating data from a specific date, filtering rows that match specific conditions, or arranging data in a particular sequence.
Filter Components
Before applying the filter, you must choose three field values:
Column
Condition
Value.
When adding the condition, it represents the Condition that must apply to the rows to be displayed.
Columns | drop down list of all the columns that exist in the table |
Condition | refers to a specific criterion or rule used to select or exclude data based on. Conditions changes based on column Types. to learn more about conditions click here |
Value | a specific value or pattern that you want to compare against in the chosen column. It represents the target or reference point for the condition
|
To Learn more in how to add custom filters to the view, click here
Customizing filters using multiple conditions
allows you to refine filtering criteria to display rows that meet specific requirements. Complex filtering can be achieved by linking multiple conditions together. For multiple filtering rules, two types of logic are used: "AND" and "OR". This method enables applying multiple filters at once using "AND" and "OR" conditions.
"AND" Conditions:
Use "AND" when all conditions need to be met. Use the "AND" logic to find items that meet all requirements within a set of filter rules.
For example, to identify projects with the status 'In Progress' and 'Urgent' in a table, select "AND" before adding the second rule.
"OR" Conditions:
Use "OR" when any condition is sufficient. Use the "OR" logic to find items that meet at least one of a set of filter rules.
For example, to identify projects containing 'Site Renaming' or 'User Portal' in a table, select "OR" before adding the second rule.
To add another condition for refinement, click on the 'Add Condition' button. This creates another workspace containing all conditions connected by "AND" or "OR".
Enabling and Disabling Multiple Filter Options:
You can toggle the 'Disable All' checkbox to enable or disable all current fields within the page. This action does not remove filters from the table but only disables their application.
