Copy and Paste Function for One of Operator in Query

Posted by to Blackbaud Europe, The Raiser's Edge on May 9th, 2012

From time to time, you may need to copy and paste a list of values from an external file, such as a spreadsheet, into The Raiser’s Edge. Here’s how to copy from a list into your Query criteria, without having to manually type in each number…

Firstly, open up your file that contains the values and copy the contents of the cells:

Next, open up your query in Raiser’s Edge, select your field from the list of fields available, in this case Constituent ID, and then select the ‘One of’ operator. Single-click to place a cursor in the top row of the Values field, then use the scroll bar to move right down to the last line of the text box, now on your keyboard press ‘Ctrl + V’ to paste the contents of the excel file:

Please note: When you press ‘Ctrl + V’ the values will not appear automatically in the list, however once you press OK, they will then be listed as per the screenshot below.

This is how you would capture constituents in a query if you only have certain data that needs to be used with the ‘one of’ operator. You can do this for other fields, as long as the query asks you to enter values in row form as above.

You can keep up with us on Twitter by following @bbsupport; we use the hashtag #bbre when we discuss The Raiser’s Edge. Take a look at our Twitter Guide for more information.




  • jtrems

    This is a great feature however be aware that a limit of 500 values can be pasted at one time.

  • robine

    Several times a year I have to produce queries just based on the ConsID and I’ve always had to manually type the list.  
    So excited to learn about this trick!

  • Artemus

    This write-up should be added right on the “Edit Field Criteria” window!!!  I can’t believe it took 7 versions of RE to come up with this. I have to search a list every week, and this will save me much, much time. 

  • John Coombes

    Very useful to know

  • Grey

    You can also use the IMPORT function as if you were going to UPDATE records during the import and use the “CREATE QUERY FROM UPDATED RECORDS” functionality.

Previous:

Next: