RE Query Cleanup

Jill Freidmutter · July 2018

Hi brilliant ones,

Is there a way to get a report on the queries that exist in Raiser's Edge? (including query names, query folder name, date of creation, last use date, and any other information about the query itself.) I would like to be able to look at the list of queries in Excel if possible.

Thank you for your assistance.

Jill

Joanne Felci 2 · July 2018

Jill Freidmutter:

Hi brilliant ones,

Is there a way to get a report on the queries that exist in Raiser's Edge? (including query names, query folder name, date of creation, last use date, and any other information about the query itself.) I would like to be able to look at the list of queries in Excel if possible.

Thank you for your assistance.

Jill

I'm curious to know about this as well...

Claudia Sauers · July 2018

I think this should work: https://kb.blackbaud.com/articles/Article/48130

Jill Freidmutter · July 2018

Thank you Claudia!

Unfortunately, it appears to only export the queries in that query folder. I am trying to avoid exporting each folder individually.

I just got a tip that if I click on Tools, Delete Multiple Queries, it takes a while but RE will provide a list of all the existing queries. If the entire grid is exported from there, all the queries are included. Yay!

Joanne Felci 2 · July 2018

Jill Freidmutter:

Thank you Claudia!

Unfortunately, it appears to only export the queries in that query folder. I am trying to avoid exporting each folder individually.

I just got a tip that if I click on Tools, Delete Multiple Queries, it takes a while but RE will provide a list of all the existing queries. If the entire grid is exported from there, all the queries are included. Yay!

This is AWESOME Jill!!!

Claudia Sauers · July 2018

Ahh, my fault, I just relied on the knowledgebase article... thanks for the awesome tip! I'm going to have to clean ours up now too!

RE Query Cleanup

Comments

Categories