Targeted Searching

Activating Targeted Searching

1. Create a custom field of type CCC Last Comment(if it doesn't already exist)
2. Configure the searcher for the custom field; choose Last Comment Searcher. (Edit the custom field searcher if there's already a Last Comment Custom Field Type)
3. Re-Index JIRA
4. Once indexing completes you are ready to use the new advanced JQL functions to do targeted Last Comment searching.

Examples of Searching

With the exception of the basic comment content search, the following examples are limited to Jira's advanced search and have no basic search equivalent.

Basic Comment Content Searching

"<last comment field name>"~athlete

Supported JQL Operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Back to Top

Last Commented Author (user) Search

lastCommentAuthor()

Supported Operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

• Find issues whose last comment was made by user jsmith. The following examples are equivalent searches since id, key, and issue are aliases of issuekey.

  issuekey in lastCommentAuthor("jsmith")

  OR

  id in lastCommentAuthor("jsmith")

  OR

  key in lastCommentAuthor("jsmith")

  OR

  issue in lastCommentAuthor("jsmith")

• Find issues whose last comment was made by users who have "john" or"smith" in their display name but results for issues with "John" and "Smith" will show up at the top of the search. This search is not an exact string search. In this example, both "john" and "smith" are separate search terms.

  issuekey in lastCommentAuthor("john smith")

• Find issues whose last comment was made by users whose username or display name start with "john". In this example, the * character acts as a wild card.

  issuekey in lastCommentAuthor("john*")

Back to Top

Last Commented Group Search

lastCommentGroup()

Supported Operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

• Find issues whose last comment was by users in the "customer" group. The following examples are equivalent to each other.

  issuekey in lastCommentGroup("customer")

  OR

  issue in lastCommentGroup("customer")

  OR

  id in lastCommentGroup("customer")

  OR

  key in in lastCommentGroup("customer")

   

   

Back to Top

Last Commented Role Search

lastCommentRole()

Supported Operators

=	!=	~	!~	>	>=	<	<=	IS	IS NOT	IN	NOT IN	WAS	WAS IN	WAS NOT	WAS NOT IN	CHANGED

Examples

• Finds issues whose last comment was by users in the "developers" role for a project. The following examples are equivalent to each other.

  issuekey in lastCommentRole("developers")

  OR

  issue in lastCommentRole("developers")

  OR

  id in lastCommentRole("developers")

  OR

  key in lastCommentRole("developers")

Back to Top

Advanced Search Queries

The following examples show how our targeted search functions can work with other JQL statements

Examples

• Find issues in a particular project whose last comment is in a project with the with a key of TEST and whose author is in the "customer" group and also in the "developers" role.

  project = TEST and issuekey in lastCommentGroup("customer") and issueKey in lastCommentRole("developers")

• Find issues whose last comment custom field named "Final Comment" contains the words "business" and "strategies" and whose author is in either the "managers" group or the "marketing" group.

  "Final Comment" ~ "business strategies" and lastCommentGroup("managers marketing")

Back to Top