filter options for custom filters

[Jon]

hi, I have made some custom filters that are dates. the query allows to search by the entered date but I would like to search by issues where there is no date entered. is there a way to do this? 

[Alexey Matveev]

Hello,

Go to advanced search and write

"name of your field" is empty

[Jon]

is there a way to apply the filter in the basic mode? some people in my team don't really know how to use the advanced jql... 

another question I have is how to search/filter a custom field of random characters (numbers and letters) if I only know the 4 of the characters in the 8-12 character field (just so you know its a reference number). for example, my reference number I am looking for ends in 1204, the entire ref no is 8009321204, all I know is the last for characters I want to apply a custom filter to search for a particular field that contains "1204". Is there a way to do this? I tried some wild card symbols (like *1204, $1204, have tried many other variations but nothing works exactly although I have gotten it to work if I'm searchin for the beginning characters of the reference number however I'm most of the time searching by the last characters) but cannot seem to get it to work. 

thanks.

jon

[Alexey Matveev]

1. You would need to use the Advanced search to find empty values.

2. The problem is that you can search only for the beginning characters. You can not search by last characters. If you want to search for the last characters, you would need an add-on.

For example, you could use the JQL search extensions plugin:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-fieldMatch(jql-subquery,field-name,regexp)