Squish has three kinds of searches available; built-in searches, keyword searches and searches you create on the Search screen.
Built-in Searches
The home page provides access to several built-in searches. Some of these searches are available through the Reports menu and some are available through links at the top of the lists on the project Homepage, which can be modified through the Edit link in the title bar. The searches in the Reports menu cannot be modified. The searches that appear in the body of the Home page on the Search page and which searches appear can be changed when viewing the search results.
Clicking the link opens the search results table on the Search screen. Issues in the results table are sorted by Date Last Modified, by default with the most recent being first. Each of the built-in searches is described below.
On the Title Bar:
- Total Issues - The link for Total Issues displays the results table for all issues (both non-confidential and confidential) that have been entered into the project. This statistic and its results table include both resolved and unresolved issues.
- Unresolved Issues - The link for Unresolved Issues displays the results table including all unresolved issues (both non-confidential and confidential).
- Unresolved Issues Assigned to Me - Clicking this link opens the result table of unresolved issues that are assigned to you. This links to the same results table as the link to the title of the Unresolved Assigned to Me list that appears below the statistics bar.
On the Project Navigation Bar:
- Recently Updated Issues - Clicking on this link, opens the result table of all issues for the project that have had recent activity, regardless of their status. The issues are listed in order of Date Last Modified, with the most recent date at the top. To open an issue, click on the Issue ID or Subject.
- Unresolved Issues Assigned to Me - Clicking this link opens the results table of unresolved issues that are assigned to you. This links to the same results table as the link Unresolved Assigned to Me that appears above in the statistics bar.
Note: My Watch List does not link to a results table. The issues that you have selected for your watch list appear in the list on the home page.
Keyword Searches
Keyword searches can be done from the box on the right side of the project navigation bar on any project screen. Type one or more words in the field with spaces between the words and press Enter or click the magnifying glass icon. The search treats multiple words as an AND search, where all words must appear in the issue. If you want to search for a phrase (words appear together and in the specified order), enclose the words in quotes.
When typing a name, lookup value, or issue number, Squish will suggest possible searches that include those terms. For example, typing in "Dave" will result in suggested searches such as "Assigned To: Dave Smith" and "Submitted By: Dave Smith". Click a suggested search to open the search page with the selected criteria predefined.
You can also search by Issue ID by typing the ID in the field and pressing Enter or clicking the magnifying glass icon. If you would like to search for multiple IDs, type the IDs with a comma followed by a space between them.
Keyword searches will only search the Subject, Description, and Comments associated with each issue. Additionally, keyword searches ignore punctuation except - and "" because they are used as operators.
If you entered an Issue ID and that number does not also appear in other issues, that issue will be displayed. If you entered one or more keywords, the Search screen will be displayed with a table listing the search results.
Creating your own search
The Search screen is reached by selecting Search from the navigation bar or by clicking one of the built-in searches on the Home page. The Search page for each project has:
- A keyword search field
- A list of searchable fields with selectable criteria.
- Search settings
Notes: You can run an existing saved search or a recent unsaved search from the Search menu.
You can create a new search by using any combination of variables available on the Search screen.
- Enter keyword text to search, if needed.
- Select a field from the Add Filter dropdown menu.
- Select an operator from the dropdown list next to the field you want to search on and enter the value in the text field to search for issues on.
- Multiple search criteria can be added.
- Text fields are filled by keying in the value.
- Drop-down lists are used by selecting the values. Multiple values may be selected.
- Date fields can be filled in by keying in the date or by selecting the date from the Calendar control.
- If needed, select an option for grouping the results from the Group by dropdown list.
- Select an option from the Results per page dropdown list: 5, 10, 15, 20, 25, 50, 100, 500, 1000, or All.
- Mark the Watch list only checkbox if you only want to return issues on your watchlist which also match the search criteria.
- Select Display Fields, remove fields you do not want to display, or rearrange field order by dragging and dropping.
- Click on the Refresh Search button at the bottom of the screen to run your search.
- Search results are displayed in a table with links to individual issues. You can change the sort in the table by placing the mouse pointer over a column title until the title is underlined and then clicking on the title. The arrow in the column header will show which column is being sorted and whether the sort is ascending or descending. Click the column title again to switch the direction of the sort.
- Note: Columns based on lookups will sort following the order specified in the Lookups tables.
Once you have the results you can click the Actions menu on the search bar or update the search parameters to make further use of the search results.