Keyword SearchThe query page allows you to query the items in the project based on the specified data. The Query form contains two sections:
▪ Filter by Data
▪ Filter by Date.
Click Customize to go to the Customize Display page. You can choose which columns are listed as the result of a query from the Customize Display page. Fill in your search critiera in the Query Items form then click Submit.
The results from your query will be displayed on the Query Results page.
You can perform a keyword search on item descriptions, details and comments depending on what search areas are selected. The search area checkboxes, description, details, and comments, are listed under the keyword text field. The query will search by keyword only in the areas that are checked. By default all the search areas are checked.
Explanation of keywords:
If you enter the word dog in the keyword field, the query will return all items that contain the word “dog”.
If you enter dog food in the keyword field the query will return all items that contain the word “dog” and the word “food” (“my dog likes food” and “my dog eats dog food” would be returned).
To search for a literal phrase, use single or double quotes. For example to search for the phrase dog food, enter “dog food” or ‘dog food’ in the keyword field. The query will return all items that contain the phrase “dog food” (“my dog eats dog food” would be returned but “my dog likes food” would not).
The keyword search also supports the ? and * wildcards:
? – any single character. For example entering “?og” in the keyword field will return all three lettered words in which the last two letters are "og" - (hog, log, dog, bog, jog, cog, fog). However, this query will not find items for the words like “frog”.
* – zero or any number of characters. For example entering “dog*” in the keyword field will return items that contain the word “dog”, “dogs” or “dogfood” but not “dog food”.
If you would like to use "?" or "*" as a letter within the keyword phrase, use the escape character "\" just before the character. For example, if you would like to find the phrase "x = foo * bar;", the phrase would be "x = foo \* bar;". Or "x = (a < b) ? 1 : 2;", the phrase would be "x = (a < b) \? 1 : 2;"
The value that is selected by default for all of the Multi-selects lists except for the Project list is Ignore. Ignore indicates that the field will not be used to filter the query.
Selecting more than one item in the multi-select lists will return items for both values selected. For example, if you select Bug and Feature in the Type multi-select list, all items that have a type of Bug or Feature will be returned.
Data can be filtered by the following categories:
▪ Type – Multi-select list of type values
▪ Status – Multi-select list of status values
▪ Priority – Multi-select list of priority values
▪ Assignee – Multi-select list of all users
▪ Milestone – Multi-select list of all milestones for the current project
▪ Category – Multi-select list of categories for the current project
▪ Reporter – Multi-select list of all users
▪ Time Estimate – Multi-select list of all time estimate values
▪ Version – A text based search will be performed on the value entered in this field.
▪ Platform – Multi-select list of platforms
▪ Projects – Only the current project will be searched when a query is performed inside a project so this control is disabled. To search for items in more than one project, go to the Server Home page and select Query Projects.
▪ <Custom 1> and <Custom 2> – The name of the fields can be configured from the Custom Fields section of the Database Fields (link) page. A text based search will be preformed on the value entered in these fields.
▪ Primary Sort – The primary sort order for the items returned. The default value is priority.
▪ Secondary Sort – The secondary sort order for the items returned. The default value is item id.
If one of the Dates is filled in, the query will filter by date in addition to the Filter by Data criteria selected. A date query will include items Added, Updated or Commented during the given dates based on what the user selects for the List Bug checkboxes.
▪ Added – If Add is checked, the query will list items added during the dates specified.
▪ Updated – If Update is checked, the query will list items modified during the dates specified.
▪ Commented – If Commented is checked, the query will list items commented during the dates specified.
▪ From (dd-mmm-yyyy) – the starting date for the query. Enter the date or select the date by clicking on the calendar. The date should be in the form dd-mmm-yyyy.
▪ To (dd-mmm-yyyy) – the ending date for the query. . Enter the date or select the date by clicking on the calendar. The date should be in the form dd-mmm-yyyy.
The list below describes the query results you will get based on how Filter by Date form is filled out:
▪ At least 1 List Bugs checkbox checked, From and To fields left blank – Not a date based query. At least one date field must be filled in to be a date-based query. Items returned will be based on items specified in Filter by Data form.
▪ At least 1 List Bug checkbox checked, From filled out, To left blank – Items returned will be all the bugs Added, Updated and/or Commented based on the selected List Bugs checkboxes starting at the From date specified to the current date.
▪ At least 1 List Bug checkbox checked, From left blank, To filled out – Items returned will be all the bugs Added, Updated and/or Commented based on the selected List Bugs checkboxes prior to the To date.
▪ At least 1 List Bug checkbox checked, From filled out, To filled out – Items returned will be all the bugs Added, Updated and/or Commented based on the selected List Bugs items between the From and To dates.
▪ At least 1 List Bug checkbox checked, To date before from date – you will get an Error page stating that the To date must be after the From date.
▪ At least 1 List Bug checkbox checked, Invalid date format for one or both of the dates – You will get an error page stating that the date format is invalid. Dates specified that do not adhere to the formats or dates that are out of range due to windows limitations will result in this error page.