Find Exports which use a given query

Bob Wiebe

I I do a set of reports after each fiscal year.  Believe it or not, I do not always remember the exact combination of query and export I used to generate the report, although I am getting better at using title nomenclature consistently between query and export.  Right now I have a query which I know I used related to alumni, but I don’t know which Export I used.  I can easily make up another export, but I want to ensure I export the data in the best way possible, and would like to see last year’s decision.

It would be helpful to be able to pull up a list of exports which use a given query.  Can RE do that?  

 

Joanne Felci 2

I'm interested to see what others say - if there is a way to export a list like I believe you are asking


I do know when you are in the query screen and you click on a query down below there is a "The selected query is used in the following..." and it will list exports, reports, dashboards it is used in - I'm not sure if this is a user option setting though



 

Steven Cinquegrana 2

Hi Bob,


You don't say if you're Blackbaud-hosted but if you're not, you can use this direct SQL:

SQL Query

SELECT E.[NAME] [Export Name],

       Q.[NAME] [Query Name]

FROM

       [dbo].[EXPORT] E INNER JOIN

       [dbo].[QUERIES2] Q ON Q.[QUERIESID] = E.[INCLUDEQUERYID]

Example Output

Export Name                                    Query Name

Address/Phone List Export                      Volunteers

Members with Current Membership Information    All Current Members


Cheers,

Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

 

Linda Mikelson

There is an article in knowledgebase about this: 

https://www.kb.blackbaud.com/articles/Article/60775 

Bob Wiebe

Thank you Joanne, for your helpful answer.


Joanne Felci:

I'm interested to see what others say - if there is a way to export a list like I believe you are asking


I do know when you are in the query screen and you click on a query down below there is a "The selected query is used in the following..." and it will list exports, reports, dashboards it is used in - I'm not sure if this is a user option setting though