Using Wildcards in Searches[edit]


= Using Wildcards in Searches =

&nbsp;

Wildcards make searching in ICI&nbsp;very easy and flexible. Here are some examples to see how this powerful feature can be used.

A search term:

*is the value based on which the results are filtered. 
*can be used for a certain field or an entity. For example, if you select '''Created By '''under ''Please Select Entities to Search box'', it will show the list of users who have created the selected entities in ICI. This allows searching for entities created by specific user(s). 
*can be a single value or a series of values that are combined with an operator. For example, 
<ul style="margin-left: 80px; list-style-type: circle;">
<li>“CLM Admin”</li>
<li>“CLM Admin” AND EXECUTED</li>
<li>"CLM Admin" OR Harish</li>
<li>"EMC Corpor" AND ( EXECUTED OR DRAFT )</li>
</ul>

*can also include&nbsp;wild card characters like '''?''' (to match a single character) or '''*'''&nbsp;(to match&nbsp;any number of characters). Here are a few examples of wildcard search terms: 
<ul style="margin-left: 80px; list-style-type: circle;">
<li>'''APPROVE?''': Matches to APPROVED</li>
<li>'''APP*''': Matches to APPROVED and WAITING FOR APPROVAL</li>
</ul>

Wildcard characters can also be used with AND and OR operators. For example:

*'''APP* OR DRA*''': Matches APPROVED, WAITING FOR APPROVAL and &nbsp;DRAFT statuses 
*'''APP* OR DRAF?''': Matches APPROVED, WAITING FOR APPROVAL and DRAFT statuses 
*'''?PP*''': Matches APPROVED and WAITING FOR APPROVAL statuses 
<div class="note-box">Note that '''*'''&nbsp;only completes the current word.</div> 
You can also use:

*'''fuzziness operator (~)''' if you are not sure of the grammatical correctness of the search term. For example,&nbsp;'''APPROVL~'''&nbsp;matches APPROVED and&nbsp;WAITING FOR APPROVAL 
*'''proximity search'''&nbsp;that allows the search term values to be further apart or in a different order. For example,&nbsp;'''"Waiting Approval"~3''' – Will match WAITING FOR APPROVAL and WAITING FOR MANAGER APPROVAL 
*Boolean operators like +/- can also be used with search terms. '''+'''&nbsp;states that the term must be present in the result. '''-''' states that the following term must not be present in the result. Any other term without the operator is optional. For example, search terms cannot contain any of these reserved characters:&nbsp;'''+ - = && || > <&nbsp;! ( ) { } [ ] ^ " ~ *&nbsp;?&nbsp;: \ / -''' 

A minus or hyphen sign can be used as a negative condition. For example,&nbsp;'''select&nbsp;'''an entity (Agreement), and enter the -&nbsp;'''''Draft&nbsp;'''''in the&nbsp;''Custom Keyword&nbsp;''field and&nbsp;'''click&nbsp;'''''Apply.&nbsp;''The Agreements with status other than&nbsp;''Draft&nbsp;''will be displayed.&nbsp;
<div class="image-green-border">[[File:Search by Wildcards1.PNG|720px]]</div> 
However, since it is a special operator, it cannot appear within the data part of the search term. For example, if minus sign was entered after the word&nbsp;''Draft&nbsp;''in the&nbsp;''Custom Keyword&nbsp;''field, Agreements in&nbsp;''Draft&nbsp;''state will only be displayed as the minus (-) part of the search term ('''''-Draft''''')&nbsp; will be ignored.&nbsp;
<div class="image-green-border">[[File:Search by Wildcards3.PNG|720px]]</div> 
'''Related Topics:'''&nbsp;[[Using_Advanced_Search|Advanced Search]] &nbsp;| &nbsp;[[Searching_agreements_and_requests|Searching for Agreements and Requests]] &nbsp;| &nbsp;[[Saved_Searches|Saved Searches]] &nbsp;