Query Search

Key words can be searched for when using the search (simple or advanced) function in SmartyFile. There is added functionality to use a query to search for partial words and to add wildcards as part of the query. Queries can be used on to search on the following items to match a partial word:
- Round
- Owned by
- Shared with
- Form response text
- Form name

Info: For example, you may have tried to search for any applications that are owned by one of your team members ‘Jenny’. You search using ‘jen’ but received no results. If you use ‘Jenny’ you receive results. If you wanted to use ‘jen’ to find applications you would need to use a query. Details on how to do this are outlined below.

For those interested in the specifics of this function, SmartyFile uses 'Lucene Search'.

Types of searches

Results include specific character/number/word/phrase etc

If you would like your filter to return results for only those applications that contain specific character, number, word, phrase, etc, then you are able to do this by using double quotation marks ( ““) on either side of the required result.

For example, to search for all the applications that contain ‘community’ you can use the search:

“community”

Wildcard Searches

Lucene supports single and multiple character wildcard searches within single terms (not within phrase queries).

To perform a single character wildcard search use the "?" symbol.
To perform a multiple character wildcard search use the "*" symbol.

The single character wildcard search looks for matching terms which replace the "?" with another character.

For example, to search for "text" or "test" you can use the search:

te?t

Multiple character wildcard searches look for 0 or more characters.

For example, to search for test, tests or tester, you can use the search:

test*

You can also use the wildcard searches in the middle of a term.

te*t

Note: You cannot use a * or ? symbol as the first character of a search.

Boolean Operators

Boolean operators allow terms to be combined. Lucene supports AND, "+", OR, NOT and "-" as Boolean operators (Note: Boolean operators must be ALL CAPS).

For example, to search for applications that include community events or just the word events you can use the search:

“community events” events

or

“community events” OR events

You can use the AND operator to find results where both terms exist anywhere in the Application ID.
- For example, to search for applications that include community events and also youth events you can use the search:
- ```
“community events” AND “youth events”
```
The + operator requires that the term after the + symbol must exist somewhere in the result.
- For example, to search for applications that must contain community, but may also contain events you can use the search:
- ```
+community events
```
The NOT operator excludes results that contain the term after NOT.
- For example, to search for applications that contain community but do not include events you can use the search:
- ```
“community” NOT “events”
```

Note: The NOT operator cannot be used with just one term. For example, the following search will return no results: NOT “events”

The - prohibit operator excludes documents that contain the term after the - symbol.
- For example, to search for applications contain community events but not youth events you can use the search:
- ```
“community events” - “youth events”
```

Info: For further technical information on Lucene search parameters, see Technical Lucene Parameters (external site).