searching - high COPY 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
t or f: The following dtSearch syntax is valid for searching for terms at the end of a document:
(bank and case) w/10 lastword
f
t or f: The dtSearch syntax “paper NOT w/2 trail” returns the same documents as the dtSearch syntax “trail NOT w/2 paper”
f
t or f: Without parentheses, dtSearch strings prioritize OR operators before AND operators?
t
Match the dtSearch operators to their associated functionality:
- *
- ?
- %
- ~
- ””
- wildcard - matches any number of characters
- matches any single character
- fuzzy searching - returns documents containing spelling variations
- returns documents containing grammatical variations of a root word
- matches an exact word or phrase
What is the maximum length of a string that dtSearch will index?
32 characters - it will only index the first 32 characters of a string
Does running an incremental build index new fields or added/changed data for existing files?
no
In dtSearch, how is the following evaluated?
apple pear
the exact phrase: apple pear
In dtSearch, how is the following evaluated?
“apple pear”
the exact phrase
In dtSearch, how is the following evaluated?
apple AndAny (pear or orange)
apple and if pear or orange appear they will be highlighted, but are not a “condition” of the search so will not affect the search itself
