Working with Advanced Search Filter Options
Advanced search provides additional operators for filtering the records.
List of available Operators -
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 onAND
operationmissing value
: results have no value for that fieldstarts with
: results start with the search valuecount equals
: the number of values in an attribute equals the search value.count not equal
: the number of values in an attribute not equal to the search valuecount less
: the number of values in an attribute less than the search valuecount less or equal
: the number of values in an attribute less than or equal to the search valuecount greater
: the number of values in an attribute greater than the search valuecount greater or equal
: the number of values in an attribute greater than or equal to the search valuecount in range
: the number of values in an attribute greater than the minimum and less than the maximum search valueIs pinned exists
: filters profiles that have the specified attribute pinnedIs pinned missing
: filters profiles that do not have the specified attribute pinnedIs ignored exists
: filters profiles that have the specified attribute ignoredIs ignored missing
: filters profiles that do not have the specified attribute ignoredNote: For more information about using the pin and ignore related filter options, see topic Exploring the Advanced Search.in 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 contain the entirety of the input value as a substring somewhere within the attribute value
- you use the
contains
condition, 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.
Specific 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
Specific 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
-
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.