Get a Custom Field's default value in a Filter using JQL?

[Philippe Cadieux]

Hello,

We use a custom field in our DB where the Default Value gets changed every month. Right now this means that we have to update all our filters to search for the new Default Value.

Is there a way in the Filter's JQL query to make it so it's searching for the field's "Default Value" whatever the default value actually is at the time of the search? Some kind of Default Value wildcard to use for our searches. 

Thanks

[Peter Bengov · Accepted solution]

Hi Philippe,

Try this solution:

1. Create a filter that gets only the default value. Say "customfield = "default value". Save it as "Default Value".
2. Every other filter that you are using that should refer to this ever-changing field will now change to project = XXX AND ... AND filter = "Default Value".

That way you should only change this once. All other filters will get updated accordingly. 

[Philippe Cadieux]

Thanks, that's a smart workaround for the issue!

[Peter Bengov]

Great. Happy it works for you