Edjet LMS Server 6.4
Search and filter data
Instructor info
Procedures in this article require role Instructor or above.
Learner Instructor Admin Superadmin
help Learn more about user roles.
The data filter can be used to search and filter the data in the data tables based on various conditions.
On the background, the SQL technology is used to process the filtering and searching.
You can search any phrase or value available in any searchable columns, even if the column is currently hidden from view.
Value in search condition matches exact and similar values:
For example: Searching for “abc”: - matches “abc”, “Abc”, “abcdef” and “Abcdedf”
Search phrase is added as a filter condition “Contains”
Some columns might be non-searchable. For details contact your Edjet LMS Administrator.
To search a data:
- Sign in to Edjet LMS admin.
- Navigate to any page with data table and filter.
- Enter keyword into input Search above the data grid.
- Click OK.
The query is composed from conditions, logical operators and condition groups. You can see the current query if you expand the filter panel.
Conditions
Filter condition is composed from value of the the item property (stored and displayed in the data table column) and the comparison operator.
Available comparison operators:
- Equal [=]
- Not equal [≠]
- Greater than [>]
- Smaller than [<]
Value matches exact values only and is case sensitive.
Example - condition value "abc":
- matches "abc"
- but doesn't match "Abc", "abcdef" and "Abcdedf".
Logical operators
A logical operator allows you to test for the truth of a condition. They return a true or false.
- AND - True if all the conditions separated by AND is true
- OR - True if any of the conditions separated by OR is true
Condition groups
You can combine multiple filter conditions and group them as you need, allowing you to combine different logical operators.
Groups can be added and removed. There is always a basic condition group that cannot be removed.
Steps to add or edit filter:
- In the toolbar click filter_list Filter.
- Click drop down Choose and select item property (column).
- If available, click the comparison operator dropdown and choose the option.
- If available, enter the condition value.
You can use the item lookup, date time picker or different tool available next to input.
- To add another condition, click add Add above the condition group.
The condition will be added into the next nearest condition group.
- To add a condition group, click add Group above the condition group and set logical operator.
The group will be added after the last condition in current group.
- To remove the condition or group click icon remove cancel in a row.
- In the toolbar click save Save and close.
To apply the filter without closing the dialog, click Save.
If the filter is active, it is visually highlighted using dark grey color.
To view current filter conditions:
- Click Filter keyboard_arrow_down next to View dropdown.
Expanded filter show all filter conditions and operators.
You can also access buttons to clear and edit filter.
To reset the current filter:
- Expand the filter.
- Click clear Clear.
To remove the filter conditions individually:
- Expand the filter.
- Click clear icon clear next to the condition you want to remove.
This feature is available on Learners and Administrators page only.
To filter learners by initial letter of their surname:
- Sign in to Edjet LMS admin.
- In the menu click people Learners.
- Click a letter in the letter bar in the bottom of the screen.
- Data from different columns cannot be searched within one condition.
For example: if there are columns Name and Surname, you cannot search “name surname”, but create a query “name” AND “surname” composed from two conditions.
- If there are folders on a page, filter always apply only to current folder – to filter across all tests disable the folders using link Turn off, if available.
- Basic group can only be set to AND logical operator. Add a custom group to use other logical operators.
