Find Exports which use a given query

Options
Bob Wiebe
Bob Wiebe
Ancient Membership 25 Likes 10 Comments Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion
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?  

 
Tagged:

Comments

  • Joanne Felci 2
    Joanne Felci 2
    Ninth Anniversary 1,000 Likes 1000 Comments Photogenic
    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

    e66c409aded664fec33e512237d3b655-huge-qu

     
  • Steven Cinquegrana 2
    Steven Cinquegrana 2
    Ninth Anniversary 500 Comments 250 Likes Name Dropper
    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
    Linda Mikelson
    Tenth Anniversary 10 Comments Photogenic Blackbaud Certified
    There is an article in knowledgebase about this: 

    https://www.kb.blackbaud.com/articles/Article/60775 
  • Bob Wiebe
    Bob Wiebe
    Ancient Membership 25 Likes 10 Comments Photogenic

    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

    e66c409aded664fec33e512237d3b655-huge-qu

     

     

Categories