Safety considerations and limited access to some of the data necessitated the introduction of additional features to the search engine.
Secure Field Plugin adds "issue in search" function to the JQL. This function takes from 2 to 4 arguments rounded by quotation marks.
issue in secureFieldSearch("", "", "")
1 - custom field's name
2 - operator's name
3 - custom field's value
Note: custom field's value is not required in case of using operators such as isEmpty or isNotEmpty
4 - case sensitive/insensitive
Note: argument valid for operators = and != for fields: Secure Text, Secure Free Text, Secure List, Secure Multi Select List, Secure Single User Picker, Secure Multi User Picker, Secure Single Group Picker, Secure Multi Group Picker
Operators that are defined for the particular field types are listed below:
Secure Text | Secure Free Text | Secure Number | Secure List | Secure Multi Select List | Secure Single User Picker | Secure Multi User Picker | Secure Single Group Picker | Secure Multi Group Picker | Secure Date | Secure Date Time | |
---|---|---|---|---|---|---|---|---|---|---|---|
= | x | x | x | x | x | x | x | x | x | x | x |
!= | x | x | x | x | x | x | x | x | x | x | x |
> | x | x | x | ||||||||
>= | x | x | x | ||||||||
< | x | x | x | ||||||||
<= | x | x | x | ||||||||
isEmpty | x | x | x | x | x | x | x | x | x | x | x |
isNotEmpty | x | x | x | x | x | x | x | x | x | x | x |
startsWith | x | x | x | x | x | x | x | x | |||
endsWith | x | x | x | x | x | x | x | x | |||
contains | x | x | x | x | x | x | x | x |
Secure Field Search with JQL
issue in secureFieldSearchJQL("", "", "", "")
This function allows to search within result of other JQL. It takes from 3 to 5 arguments rounded by quotation marks.
1 - Any JQL - like project = test, type = Task etc...
Please keep in mind that if your JQL contains any double quotation marks " please escape them - change to \" - or change to single quotation marks '.
Fore example for JQL like project = "test" change it to project = \"test\" or better change to project = 'test'.
2 - custom field's name
3 - operator's name
4 - custom field's value
5 - case sensitive/insensitiv
Secure Field Search with Filter
issue in secureFieldSearchFilter("", "", "", "")
This function allows to search within result of search filter. It takes from 3 to 5 arguments rounded by quotation marks.
1 - Filter id - to obtain filter id (filter id it is NOT filter name. we are using filter id because id filter name is not unique within instance of JIRA) please execute filter and check your web browser address bar. Number after filter= will be your filter id.
2 - custom field's name
3 - operator's name
4 - custom field's value
5 - case sensitive/insensitiv