Hi all,
im searching for a method to list all issues where the fixVersion Date is smaller than the actual date.
Fix Version examples:
A0.5 (11.08.2021)
A1.1 (11.05.2021)
A1.3 (09.02.2021)
A1.5 (09.02.2021)
A2.3 (04.01.2021)
A3.4 (18.11.2020)
E.g. show all issues where the fixVersion <= 09.02.2021 (actual date)
Result:
A1.3 (09.02.2021)
A1.5 (09.02.2021)
A2.3 (04.01.2021)
A3.4 (18.11.2020)
I have read in here:
that functions like now() or startOfDay() are not supported in FixVersion.
Is there any workaround to get the results above?
The FixVersion is the only reference for the dates.
Thank you very much for your help.
@Contexys , if you have scriptrunner, you can use the function like
fixVersion in releaseDate("before 2021/09/02")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yup.. fixVersion in releaseDate("before now()") would work
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Works great thank you.
If I change the date to 2021/21/12 e.g.
- A1.0 (21.12.2021) as fixVersion
following errors appear:
could you explain what I'm doing wrong?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Put the date in format 'yyyy/MM/dd' as mentioned in the error - 2021/12/21
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For my understanding. How does releaseDate work?
Sometimes im experiencing that although the date is correct some issues not getting displayed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Fazila Ashraf im using following filter at the moment:
(fixVersion in releaseDate("before now()") OR fixVersion in releaseDate("on now()")).
My problem is that issues which are not in status = implemented are not displayed with this filter.
E.g. it should display issues which are in status (qualified, planned, assigned) with a fixversion e.g A1.0 (14.02.2021) which are not implemented.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Contexys , you will just have to append your additional clauses 'status != implemented and status in (qualified, planned, assigned) ' to your fixversion query
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think appending does not solve in problem here.
If i use following filter:
(fixVersion in releaseDate("before now()") OR fixVersion in releaseDate("on now()"))
Every issues with status (qualified, planned, assigned) disappears.
If I append following filter: status in (implemented, qualified, planned, assigned)
Only issues with status implemented are shown even though issues with status qualified etc. with fixversion before now() exist.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Contexys ,
Welcome to the community!
Could you specify if you are on server or cloud?
The documentation you specify is for fixVersions themselves, not for metadata of fixVersions (like releaseDate).
However, Scriptrunner, a very popular app, does add this functionality, as documented here.
- Tessa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.