How to pull correct project start and end dates into filters?

[Chelsea Duke Miller]

We use filters for a subset of users to see cards with specific labels. 

In the filtered view, we have project start and project end date pulled in from the JPD project. The dates do not match what is configured on the JPD card. 

For example, we have a projected start date of 7/31/23 and projected end date of 11/30/2023. 

On the filtered view, project end date lists the following: 

{"start":"2023-11-30","end":"2023-11-30"}

Additionally, we have a due date filter for non-JPD cards and the due date listed is 10/27/23. The linked delivery card also are due with work estimates of 11/30/23.

Wondering where these dates are coming from? Potential bug?

[Hermance NDounga]

Hi Chelsea, 

Could you please elaborate on the reason why you are using the filtering in JQL and not create a dedicated view for these contributors? 

Jira Product Discovery dates fields are a bit different than non-JPD date fields. 

One field value is always composed of a start and end date (because you could select a quarter instead of a specific day), e.g. if you'd select this quarter, it would look like 

{"start":"2023-10-01","end":"2023-12-31"} 

So in your screenshots and examples - I see that on your first screenshot, you only display the field "project target date" but not the field "project start".

 But I can guess that when you will display the field project start you will see {"start":"2023-07-31","end":"2023-07-31"} 

All this to say - our date field is definitely not to be used with the Jira filtering because the Jira platform doesn't know how to interpret it. :/ 

[Chelsea Duke Miller]

Hi Hermance - 

In terms of the following question, do you mean a dedicated view within the JPD project? 

Could you please elaborate on the reason why you are using the filtering in JQL and not create a dedicated view for these contributors? 

Thanks!

[Hermance NDounga]

Hey @Chelsea Duke Miller yes exactly

[Chelsea Duke Miller]

@Hermance NDounga -

We are using filters so we can pull in cards from different projects, outside of the JPD project. Are you suggesting we should pull different projects into one view? 

[Hermance NDounga]

@Chelsea Duke Miller thanks for exaplaining your use case, I was simply curious to understand the reason why you need to get "off" JPD to achieve what you want. but as it's not possible to display cards from various projects in one Jira Product Discovery view, I do understand now :) 

[Paolo Pastorino]

I found the same issue in the past and this was the answer https://community.atlassian.com/t5/Jira-Product-Discovery-questions/JQL-script-for-exporting-a-timeline/qaq-p/2282863

[Chelsea Duke Miller]

Thank you for sharing! Will definitely use if I export.