Hello, everyone,
how to set the "Start Time" for "Get calendar view of events" to the last 7 days. I would like to see all events of the past 2 weeks.
In addition, only events that have been canceled should be output.
I know about the query for the current events, but I can't get any further.
Hi @Livearus,
You can use expressions for the Startzeit und endzeit fields and use the adddays function to calculate a date in the past.
Use something like below and add them via the expression tab.
In my example I am looking back 14 days.
Startzeit
addDays(utcNow(), -14, 'yyyy-MM-ddTHH:mm:ss')
Endzeit
utcNow('yyyy-MM-ddTHH:mm:ss')
Okay many thanks. It was somehow obvious. Can you also tell me what the correct filter query looks like for me? As I said, I would only like to have appointments issued that have been cancelled. So I think I need to filter by "Cancelled" in the subject? However, I only get error messages:
Example: subject eq 'Cancelled' or subject eq 'Cancel' - Subject does not exist
Example: subject contains 'Cancelled' - Subject does not exist
Example: contains(subject,'Cancelled')Is not allowed here
Hi @Livearus,
Did you cancel the appointments (as an organiser) or did somebody else cancel them?
In the first scenario the appointment would not be part of the view anymore and I think the events would not be part of the view of listed events.
Scenario 2 applies. Someone else canceled the events. I'm not an organizer.
User | Count |
---|---|
102 | |
38 | |
31 | |
24 | |
16 |
User | Count |
---|---|
132 | |
53 | |
52 | |
37 | |
26 |