You can use wildcard characters, such as an asterisk (*) or a question mark (?), to represent one or more characters when you are typing search terms. Wildcard characters are often used in place of one or more characters when you do not know what the actual character is or you do not want to type the entire name.
Use the asterisk (*) to substitute for one or more characters. For example, sales* locates all words that contain the word sales. The location of the asterisk is important: sales* might bring back salesman, or sales tax, but it would not find dollar sales. To locate dollar sales, you could type * sales.
Use the question mark (?) to replace one character. For example, if you type sal?, this would find words like sale, or sal2, but not sales, since there are two extra characters in that term and the question mark only replaces one of them.
You cannot use the question mark (?) wildcard to search for attribute elements. For example, in the View Filter pane when you click Select and search for attribute elements, you cannot use a question mark (?) as part of the search.
The following examples assume that the attribute Name has two display (browse) forms: First and Last. First refers to the first name and Last refers to the last name.
Search keywords that do not include wildcards have wildcards added at the beginning and the end.
User Input: aaa
Filter: First Name like "*aaa*" or Last Name like "*aaa*"
Any text that is included inside of double-quotes is treated as a literal comparison. For example:
User Input: "aaa"
Filter: First Name = "aaa" or Last Name = "aaa"
If you include wildcards, then MicroStrategy Web does not add any. For example:
User Input: aaa*
Filter: First Name like "aaa*" or Last Name like "aaa*"
User Input: a*aa
Filter: First Name like "a*aa" or Last Name like "a*aa"
A blank space, a comma, or the word OR indicates a logical OR between two conditions. An OR is placed in between multiple forms.
User Input: aaa* *bbb User Input: aaa*,*bbb User Input: aaa* OR *bbb
Filter: (First Name like "aaa*" or Last Name like "aaa*") OR (First Name like "*bbb" or Last Name like "*bbb")
A pipe symbol (|) or the word AND indicates a logical AND between two conditions. An AND is placed between multiple forms.
User Input: "aaa"|"bbb" User Input: "aaa" AND "bbb"
Filter: (First Name = "aaa" or Last Name = "aaa") AND (First Name = "bbb" or Last Name = "bbb")
A form name (not case-sensitive) followed by a colon can be used to search on a specific form.
User Input: Last:aaa
Filter: Last Name like "*aaa*"
User Input: First:aaa OR Last:bbb OR ccc
Filter: (First Name like "*aaa*") or (Last Name like "*bbb*") or (First Name like "*ccc*" or Last Name like "*ccc*")
Related topics