searching - high Flashcards
what security permissions do you need to use filtering?
none, you don’t need any specific permissions
what does the filter type of a filter determine?
the steps required to set the search criteria that it uses
when can you select a field’s filter type?
when you create or edit a field
T or F: you can edit the filter card in the list conditions box by clicking on it
False
the numeric filter type is available for what field types? (3)
decimal, whole number, and currency
what can cause the list filter to take longer to populate?
fields that contain a large number of items (use a pop-up filter instead)
how does the textbox filter treat each search term?
as if it were surrounded by a wildcard, so it returns all versions of the terms when used with Boolean operators and/or
can you use filters in a saved search?
yes
what permissions are needed to be able to perform mass operations on saved searches?
add or delete permissions on the search object
when and why might you want to turn on the requires manual rerun option for a saved search?
for searches that might take a long time to run, and you don’t need them to run automatically when you navigate back to the saved searches
when are search highlights applied?
only when using the search bar, or when running a saved search against a keyword index
what does the contains operator work identically to?
keyword search, except that it searches a specific field
why do searches using the “Is like” operator tend to run slowly?
it queries every document for the field specified in the condition
are there any special requirements for using the “Contains” operator?
yes, the full text index must include the field that you want to search with the contains operator
how does query execution differ for searches with the “Contains” and “Is like” operators?
the “Contains” operator queries the SQL full text catalog, while the “Is like” operator queries the database table inside the catalog
