Searching for data
On most pages in Rival Learn, you can easily search for data objects using filters and search criteria.
The page has two primary sections:FiltersSearch results tableFilters appear on the left side of the page under the Search button. You can enter search criteria in one or more search fields to limit the search. If you leave all the fields blank, all results are displayed. Search results based on your search criteria appear in the Search Results table on the right side of the page. You can click on a column heading and sort in ascending or descending order.
- The page has two primary sections:FiltersSearch results tableFilters appear on the left side of the page under the Search button. You can enter search criteria in one or more search fields to limit the search. If you leave all the fields blank, all results are displayed. Search results based on your search criteria appear in the Search Results table on the right side of the page. You can click on a column heading and sort in ascending or descending order.
The page has two primary sections:FiltersSearch results tableFilters appear on the left side of the page under the Search button. You can enter search criteria in one or more search fields to limit the search. If you leave all the fields blank, all results are displayed. Search results based on your search criteria appear in the Search Results table on the right side of the page. You can click on a column heading and sort in ascending or descending order.
The page has two primary sections:FiltersSearch results tableFilters appear on the left side of the page under the Search button. You can enter search criteria in one or more search fields to limit the search. If you leave all the fields blank, all results are displayed. Search results based on your search criteria appear in the Search Results table on the right side of the page. You can click on a column heading and sort in ascending or descending order.
Search criteria details
Enter search criteria in one or more search fields, then click Search, or press enter to initiate a search. If the search fields are left blank, everything in Rival Learn is displayed.
Rival Learn uses common SQL search process when searching the database. By default, Rival Learn returns any data containing the entered string in the filter. For example, entering the string "end" returns all data containing the word "end". Wildcard characters can be used to further narrow searches. For example, use the following wildcard characters to modify your search:
| Wildcard character | Description |
|---|---|
| % | Any string of zero or more characters. For example: %r returns any data ending in "r" r% returns any data beginning with "r" |
| _ | Any single character in a string. For example: _andy returns "Randy, Sandy, Mandyne", etc. _andy_ DOES NOT return "Randy or Sandy" but returns Mandyne |
| [ ] | Any single character within a specified range. For example: [a-f] Any single character within a set of values. For example: [acfq] |
| [^] | Any single character NOT within a specified range or set of values. For example: [^a-f] or [^acfq] |
By default, Rival Learn wraps all text searches with %, unless the search text contains %. This means if users enter the string "vi", Rival Learn actually searches for %vi%. That is, Rival Learn returns anything that contains the string "vi". (e.g. David, Gavin, Levi, Ravi, Vivian would all be returned. Entering %vi instead would return anything ending with "vi". (e.g. only Levi and Ravi from the previous list).