Working with Advanced Search Filter Options
Advanced search provides additional operators for filtering the records.
Operators for the String values - For example, First Name
equals: results are an exact match of the search valueNote: This operator is not case sensitive. It will display all results that match the search criteria, irrespective of whether it is in uppercase or lowercase.not: results exclude the exact match of the search valueexists: results have a value in that fieldfull text: results contain any of the search terms (for example: term1 term2) somewhere in the field.Note: A term must exist in the field and multiple terms can be separated by spaces or special characters.has all: results for multiple values from the same attribute based onANDoperationmissing value: results have no value for that fieldstarts with: results start with the search valuecount equals: the number of nested attribute identifiers equals the search value. See the example given below.count not equal: the number of nested attribute identifiers that is not equal to the search valuecount less: the number of nested attribute identifiers that is less than the search valuecount less or equal: the number of nested attribute identifiers that is less than or equal to the search valuecount greater: the number of nested attribute identifiers that is greater than the search valuecount greater or equal: the number of nested attribute identifiers that is greater than or equal to the search valuecount in range: the number of nested attribute identifiers that is greater than the minimum and less than the maximum search valuein file: file-based search: results have any one of the search values taken from a file.When doing a file-based search, there is a limit on the number of values that can be returned from one file. The current limit is 5,000. If you do a search that would return more than 5,000 values, an error message is displayed.Note: Limitation for supported file size is 5000 rows. Before selecting a file, make sure that the number of rows in the file does not exceed 5000. If you are uploading multiple files, ensure the total number of rows in all the files does not exceed 5000.not in file: results exclude any one of the search values taken from a filecontains: results include all records that have the specified search value
Note: Get ready to wait longer to get your results — for complex searches — when:
- you use the
containscondition, along with wildcard characters - you run multiple wildcard searches simultaneously
The count comparisons are relevant only if there are nested attributes. The count is the number of those nested attributes within that entity that meet the search criterion.
Example using the equals operator:
- HCP has nested attributes identifiers, and a search returns 5 HCP. Out of these 5 HCP, only one has two identifiers.
- If the search is select
count=2, then the search will return one record.
Operators for the Date values
On- results match the specified dateBefore- results contain all records prior to the specified dateAfter- results contain all records after the specified dateWithin- results include records within the specified date range. You can select from any of the following date ranges:- Last 24 hours
- Last 3 days
- Last 7 days
- Last 30 days
- Last 6 months
- Last year
- Pick date - select the From and To dates
Operators for the Integer/Numeric values
Less than- results include records with values lesser than the specified valueLess than or equal- results include records with values lesser than or matching the specified valueGreater than- results include records with values greater than the specified valueGreater than or equal- results include records with values greater than or matching the specified valuein- results include all the specified search valuesnot in- results exclude the specified search values
Note:
You can search your entities based on their Start Date and/or End Date (Activeness). Additionally, even the potential matches can be searched upon by using several operators, including by specifying the range.
While searching for RDM transcode errors in profiles, the profile won't be a part of the search results if the error is associated only with hidden attributes.