Searching for Records
Within the Corridor Site Admin portal, all grids have search capabilities for specified fields on the grid.
To Search for Records:
-
On a page within the Corridor Site Admin portal and select a function with a grid list (Reset Administrator Password, Activate Corridor for Client/Law Firm, and Troubleshoot Invoice Submissions)
-
In the search area, enter criteria on which to filter and click Search.
The number of records returned appears on the left above the grid list. Click Clear removes any search criteria.
To Specify Wildcards in Searches:
The following wildcard characters can be used in a grid list search:
|
Symbol |
Description |
Examples |
|
% |
The percent character represents zero or more characters |
bi% finds bl, black, blue, and blob |
|
_ |
The underscore character represents a single character |
h_t finds hot, hat, and hit |
|
[] |
Characters within square brackets represents any single character |
h[oa]t finds hot and hat, but not hit |
|
^ |
The carat character represents any character not in the square brackets |
h[^oa]t finds hit, but not hot and hat |
|
- |
The hyphen character represents a range of characters within square brackets |
c[a-b]t finds cat and cbt |
|
LIKE Operator |
Description |
|
WHERE CustomerName LIKE 'a%' |
Finds any values that starts with "a" |
|
WHERE CustomerName LIKE '%a' |
Finds any values that end with "a" |
|
WHERE CustomerName LIKE '%or%' |
Finds any values that have "or" in any position |
|
WHERE CustomerName LIKE '_r%' |
Finds any values that have "r" in the second position |
|
WHERE CustomerName LIKE 'a_%_%' |
Finds any values that start with "a" and are at least 3 characters in length |
|
WHERE ContactName LIKE 'a%o' |
Finds any values that start with "a" and end with "o" |