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.
Performance note
Please note that using secureFieldSearch
() function on large instances may cause performance issues. We strongly recommend using secureFieldSeachJQL() or secureFieldSearchFilter() functions instead. Please be aware that these functions have a parameter to enter JQL Query/filter and we recommend using selective filters. It's not recommended to search for secure fields on large dataset (more than 1000 issues).
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 |
In large instances due to better performance please refer to functions described below as they allow to search within secure fields in limited range of issues.
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, issuetype = 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 = "Some Project" change it to project = \"Some Project\"
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