How to remove cached filter values for deleted and archived reports

Pandurang shared this question 4 months ago
Answered

3819/YjeR+Wd11t7I86Qsebzr473r45Fs3+diyKUA8SIAESIAESIAESIAESIAESIAESIAESIIFmBP4PRLUYr2X18i0AAAAASUVORK5CYII= 3819179 Append 1 3915963 56412 10/24/2018 6:11 ARCHIVED 3772443 Append 1 3773591 40792 9/6/2018 5:23 ARCHIVED 3769721 Append 1 3769759 40792 9/4/2018 11:51 ARCHIVED 3769442 Append 1 3769778 40792 9/4/2018 11:56 ARCHIVED 2968508 Append 1 2968512 20681 9/15/2017 8:15 ARCHIVED 2958517 Append 1 2958521 20681 9/15/2017 8:15 ARCHIVED 2957576 Append 1 2957605 20681 9/15/2017 5:36 ARCHIVED 2957711 Append 1 2957713 20681 9/15/2017 5:36 ARCHIVED 2958743 Append 1 2958747 20681 9/15/2017 8:15 ARCHIVED 179 Append 1 3915963 56412 10/24/2018 6:11 ARCHIVED 3772443 Append 1 3773591 40792 9/6/2018 5:23 ARCHIVED 3769721 Append 1 3769759 40792 9/4/2018 11:51 ARCHIVED 3769442 Append 1 3769778 40792 9/4/2018 11:56 ARCHIVED 2968508 Append 1 2968512 20681 9/15/2017 8:15 ARCHIVED 2958517 Append 1 2958521 20681 9/15/2017 8:15 ARCHIVED 2957576 Append 1 2957605 20681 9/15/2017 5:36 ARCHIVED 2957711 Append 1 2957713 20681 9/15/2017 5:36 ARCHIVED 2958743 Append 1 2958747 20681 9/15/2017 8:15 ARCHIVED

Comments (3)

photo
1

Hi Padurang,

Thanks for reaching out to support with your question.

Keep in mind that queries against the configuration DB are not technically covered in the Support Agreement; as such please assure you have good backups and a rollback plan before attempting the following.

It looks like based on an old ticket, you ran into a similar issue previously and this was a possible solution (please review, there may be syntax issues):


Hello YF team,

I have changed quary as above.

I think it shod clear cached filter values of deleted and archived reports.

Delete FROM CachedFilterValueWHERECachedFilterIdIN

(

SELECTCachedFilterIdFROM CachedFilterWHEREReportIdIN

(

SELECTReportIdFROM

(

SELECTReportName,h.ReportId,ReportStatusCode

FROM

CachedFilterr,

CachedFilterValueC,

ReportHeaderh

WHERECachedFilterTypeCode='CACHEDFILTER'

ANDc.CachedFilterID=r.CachedFilterID

ANDr.ReportId=h.ReportId

andReportStatusCodein('DELETED','ARCHIVED')

GROUPBYh.ReportId,ReportName,ReportStatusCode

)

)

);


Does this give you the results you're looking for?

Thanks,

Eric

photo
1

Hi Padurang,

Just wanted to check in to see if you were able to get things cleaned up here?

Thanks,

Eric

photo
1

Hi Padurang,

I'm going to go ahead and mark this as Answered due to inactivity. Feel welcome to re-open with a reply if you have further related inquiries.

Thanks,

Eric