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….
Helen J. says
January 19, 2010 at 1:18 pmWow! 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?
REsolvedLLC.com says
January 19, 2010 at 1:21 pmHelen, 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!
BJenkins says
March 19, 2010 at 12:24 pmGreat stuff. Thanks!