Jira 简明教程

JIRA - Advanced Search

除了前一章中解释的搜索类型外，JIRA 还有一些高级搜索选项，可以使用以下三种方式执行。

Apart from the type of searches explained in the previous chapter, JIRA also has a few advanced search options, which can be performed using the following three ways.

  1. Using Field Reference

  2. Using Keyword Reference

  3. Using Operators Reference

上面提到这三处进行了详尽的解释。

These above-mentioned three ways have been explained in detail below.

用户在执行任何高级搜索时应考虑以下几点。

The user should consider the following points while performing any advanced search.

  1. Advanced search uses structured queries to search for JIRA issues.

  2. Search results displays in the Issue Navigator.

  3. Search results can be exported to MS Excel and many other available formats.

  4. Save and Subscribe features are available to advanced searches.

  5. An advanced search uses the JIRA Query Language known as JQL.

  6. A simple query in JQL consists of a field, operator, followed by one or more values or functions. For example, the following simple query will find all issues in the "WFT" project −

Project = "WFT"

  1. JQL supports SQL like syntax such as ORDER BY, GROUP BY, ISNULL() functions, but JQL is not a Database Query Language.

Using Field Reference

字段引用表示 JIRA 问题中表示字段名称（包括自定义字段）的单词。语法为：

A field reference means a word that represents the field name in the JIRA issue including the custom fields. The syntax is −

<field name> <operators like =,>, <> “values” or “functions”

运算符将字段值与右侧显示的值进行比较，以便查询仅检索到为真结果。

The operator compares the value of the field with value presents at right side such that only true results are retrieved by query.

  1. Go to Issues → Search for Issues in the navigator bar.

下面的屏幕截图显示了如何导航搜索部分。

The following screenshot shows how to navigate the Search section.

search section

如果存在现有的搜索条件，请单击新建筛选器按钮以重置该条件。下面的屏幕截图显示了如何从一个新的条件开始：

If there is an existing search criterion, click on the New Filter button to reset the criteria. The following screenshot shows how to start with a new criteria −

new filter

使用字段、运算符和值键入查询，例如 issueKey = “WFT-107” 。

Type the query using the Field, Operator and Values like issueKey = “WFT-107”.

还有其他字段——受影响版本、受让人、附件、类别、注释、组件、创建、创建者、描述、到期、环境等。只要用户开始键入，自动完成功能将有助于以定义的格式书写。

There are other fields as well – Affected Version, Assignee, Attachments, Category, Comment, Component, Created, Creator, Description, Due, Environment, etc. As soon as the user starts typing, the auto-complete functionality helps to write in the defined format.

下面的屏幕截图显示了如何使用高级功能添加字段名称条件。

The following screenshot shows how to add Field Name criteria using advanced features.

field name criteria

Operator selection ——下面的屏幕截图显示了如何选择运算符。

Operator selection − The following screenshot shows how to select operators.

operator selection

下一步是输入值，然后单击搜索符号。下面的屏幕截图显示了如何添加值和搜索。

The next step is to enter the value and then click on the Search symbol. The following screenshot shows how to add values and search.

add values search

以下屏幕截图显示了基于设置的条件的搜索结果。

The following screenshot shows the search result based on criteria set.

search result

Using Keyword Reference

在这里，我们将了解如何使用关键字引用以及它的优点。

Here, we will understand how to use a keyword reference and what its advantages are

JQL 中的关键字：

A keyword in JQL −

  1. joins two or more queries together to form a complex JQL query.

  2. alters the logic of one or more queries.

  3. alters the logic of operators.

  4. has an explicit definition in a JQL query.

  5. performs a specific function that defines the results of a JQL query.

关键字列表：

List of Keywords −

  1. AND − ex - status = open AND priority = urgent And assignee = Ashish.

  2. OR − ex – duedate < now() or duedate is empty.

  3. NOT − ex – not assignee = Ashish .

  4. EMPTY − ex - affectedVersion is empty / affectedVersion = empty.

  5. NULL − ex – assignee is null.

  6. ORDER BY − ex – duedate = empty order by created, priority desc.

与字段引用类似，一旦用户开始输入，自动完成功能有助于获得正确的语法。以下屏幕截图显示了如何添加关键字。

Similar to field reference, as soon as the user starts typing, the auto-complete functionality helps to get the correct syntax. The following screenshot shows how to add keywords.

add key words

单击搜索符号，它将提供搜索结果。以下屏幕截图显示了基于条件集的结果。

Click on the Search symbol and it will provide the search results. The following screenshot shows the result based on a criteria set.

search symbol result

Using Operators Reference

运算符用于比较左侧的值和右侧的值，使只有真结果显示为搜索结果。

Operators are used to compare values of the left side with the right side, such that only true results display as the search result.

List of Operators

  1. Equals: =

  2. Not Equals: !=

  3. Greater Than: >

  4. Less Than: <

  5. Greater Than Equals: ⇒

  6. Less than equals: =<

  7. IN

  8. NOT IN

  9. CONTAINS: ~

  10. Does Not contain: ! ~

  11. IS

  12. IS NOT

  13. WAS

  14. WAS IN

  15. WAS NOT IN

  16. WAS NOT

  17. CHANGED

与字段和关键字引用类似，这些运算符还可以用来增强搜索结果。

Similar to the Field and the Keyword Reference, these operators can also be used to enhance the search results.