• Skip to primary navigation
  • Skip to main content
  • Skip to footer

RESOLVED

REAL solutions for The Raiser`s Edge

  • Solutions
  • About
  • Blog
  • Contact

How To, Raisers Edge · August 30, 2009

Raiser’s Edge: Query the UN-query-able

Follow Along:

  • Vimeo
  • YouTube
  • Categories
    • Commentary
    • Crystal Reports
    • Excel
    • How To
    • Power BI
    • Prospect Management
    • Raisers Edge

Nothing is more satisfying than doing the impossible. Often we are asked to find a way to create a query in Raiser’s Edge when either the records don’t have anything in common, or when the only thing they have in common is a field that is not available to select in the Query module.

The screencast below shows how you can “trick” the database into building a query for you by going out and back-in through the easiest import ever. Video is 9 minutes, but once you get the hang of this trick, you can set it up in 5 minutes and save yourself tons of time.

Best watched in full-screen mode — just click the four arrows in the bottom-right of video controller bar.

Enjoy….

RESOLVED

Filed Under: How To, Raisers Edge Tagged With: How To, Raisers Edge

RESOLVED Support

Previous Post: « Get Your Data on Google Maps For Free
Next Post: Crystal Reports 11 Database Same As Location »

Reader Interactions

Comments

  1. Helen J. says

    January 19, 2010 at 1:18 pm

    Wow! I will be able to use this for creating queries from mail lists and events all I have to do is add the IMPORT_ID field to all my exports, right?

  2. REsolvedLLC.com says

    January 19, 2010 at 1:21 pm

    Helen, you are correct. Just remember to tell your mailhouse vendors (and co-workers) that all of your exports will now be including this field. We’ve had some mailhouse vendors accidentally include the IMPORT_ID on mailing labels — not the end of the world, but looks bad. Glad you liked the tip!

  3. BJenkins says

    March 19, 2010 at 12:24 pm

    Great stuff. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Support the Blog

Footer

Quicklinks

  • Home
  • Solutions
  • About
  • Blog
  • Contact

The Latest

  • Blackbaud Custom Data Connector for Power BI in Detail
  • NXT Yourself
  • SKY API enabled Power BI
  • Grab the butter
  • A Point of Sale that is not a POS

Follow Along

  • Vimeo
  • YouTube

Via Post Phone Email

RESOLVED LLC
8630M Guilford Rd Ste 262
Columbia MD 21046-1404
USA

1-443-450-4054          Email

Copyright © 2023 · RESOLVED LLC is an independent firm not sponsored or endorsed by Blackbaud