Hi,
I would like to have an automatic filter that display all the tickets that have Activity Start Date and Activity End Date since yesterday starting with 8 am and ending with tomorrow at 8 am.
E.g.: today 4/ March i want to receive all tickets with Activity Start Date and Activity End Date between 3 March 8 am - 5 March 8am.
Now i have every day to select manually the dates and hours and probably it can be somehow automatically filled in JQL
Hello,
Try a JQL query like this:
("Activity Start Date" > startOfDate(-16h) and "Activity Start Date" < endOfDate(8h)) or ("Activity End Date" > startOfDate(-16h) and "Activity End Date" < endOfDate(8h))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is the error received
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It should be like this:
("Activity Start Date" > startOfDay(-16h) and "Activity Start Date" < endOfDay(8h)) or ("Activity End Date" > startOfDay(-16h) and "Activity End Date" < endOfDay(8h))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Now i have this error:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks like it should have been startOfDay, not startOfDate. I'm off to try it out, anyway.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This doesn't do what it's supposed to do, but doesn't get an error, so you might try messing around with that wording until it works. That's what I'm trying for.
project = <projectname> AND issuetype in (Incident, Issue) AND status !=Done AND (created >= 2019-01-01 AND created <= 2019-03-31) AND (created > startOfDay(-16h) AND created< endOfDay(8h))
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.