Filter ideas without date

[Aurélien BARBE]

Hello everyone,

is it possible on a list view to specify that I don't want to display ideas where I don't have a date specified in one of my date fields.

Currently, if I choose to add a filter on a date field, I don't have the option :

thanks in advance

[Ste Wright · Accepted solution]

Hi @Aurélien BARBE 

You can do this from a normal issue search page using JQL?

• On the top navigation bar, select Filters > View all issues
• Enter JQL for this, for example...

  • project = "ABC and "Date de debut" is EMPTY

^ Ensure you select the right field when doing this, as JPD is still using a Team-managed model, although there is a beta running for global fields

---

However, I don't think it's possible to modify the filter in your image any further in the list view.

You could suggest this? You can raise feature requests through here: https://jira.atlassian.com/secure/Dashboard.jspa

===

A potential workaround is to use Automation to populate a checkbox field, then use this in the filter instead?

The field would be editable, and you would need to be careful of execution limits - i.e 200 for Free, 500 for Standard per month (see execution limits on this help page), but it's an option?

Prerequisites:

• Create a custom checkbox field, eg. "Date Populated?"
• Get the custom field IDs of both the date field and the checkbox field
  • See all fields here - https://<your instance>.atlassian.net/rest/api/3/field
    • Search for the fields using their names
    • For this example, Date de debut is ID 123456, and Date Populated is ID 654321

Rule:

• Trigger: Field value changed
  • Field to monitor = Date de debut
  • Change type = Any changes to the field value
• Condition: IF or ELSE
  • IF...
    • Condition: {{smart values}} condition
      • First value = {{issue.customfield_123456}}
      • Condition = equals
      • Second value = Empty - leave empty, don't type in the word
    • Action: Edit issue
      • More options...
        • Additional fields...
          • {
            "fields": {
            "customfield_654321": 0
            }
            }
  • ELSE-IF...
    • Condition: {{smart values}} condition
      • First value = {{issue.customfield_123456}}
      • Condition = does not equal
      • Second value = Empty - leave empty, don't type in the word
    • Action: Edit issue
      • More options...
        • Additional fields...
          • {
            "fields": {
            "customfield_654321": 1
            }
            }

---

Notes:

• You have to use smart values/JSON in the Conditions and Actions as JPD fields aren't available to select from the field menus.

---

Let us know if this works for you!

Ste 

[Aurélien BARBE]

Hi,

thank you for this more than complete answer.

For the time being, I'm going to use JQL. It'll help me make sure I'm on the right track with the processes I want to implement.

And thanks for the tip about automation. Maybe I'll use it to centralize everything in JPD.

Regards,

[Miguel Ramon]

Not entirely sure, but would it work for you if you do it from the issue search window? From there you'd surely be able to run a query such as:

project = XXX and "date_field" is EMPTY

This can be run  by accessing https://<your_instance>.atlassian.net/issues/

Regards,