When I changes dates in pre-existing change management reporting filter date sets to ALL

[Lee Tappin]

I have pre-saved change management reporting filters I use for reporting eg..When I do monthly reporting I set the dates in a pre-existing filter to the last month but when I select 1st Aug to 31st August the dates change to ALL. Any ideas?

This has been happening for 3 weeks or so now.

Regards Lee Tappin

Change Manager - Smart Comms

[Lee Tappin]

help

[Fahad Siddiqui]

@Lee Tappin check the subscription and then click on mange subscription. 

[Lee Tappin]

what should i check for?

Where is this option?

Apologies and thanks in advance

[Fahad Siddiqui]

You need to go in filter Query.

then Go to Details and click on update Subscription

[Lee Tappin]

Thanks.

Tried this but getting

You have no subscriptions for this filter.

[Fahad Siddiqui]

You are near don't worry. can you please share the screen shot.

[Lee Tappin]

it has started working?

I can now change dates eg 1st October 2019 to today

However, when I export it truncates to the first 1000 records.

I have tried Excel online option and have got this error.....

Request Id: 4f840102-07bc-4bbd-a7bf-d559b25e4400
Correlation Id: 8e1b9f51-1060-4e5a-8e26-3756978651bb
Timestamp: 2020-09-21T17:04:18Z
Message: AADSTS90015: Requested query string is too long.

[Lee Tappin]

This filter isn't working.

If i change the date field for the 10/9 - 17/9 the date changes to ALL when I select update and this filter has worked for the past 2 years but has been a problem for the past 3 weeks?

[Lee Tappin]

See date field set to ALL