Blank Phone Fields

Options
Megan Thoms 2
Megan Thoms 2
Ninth Anniversary Photogenic 5 Likes First Comment
in Blackbaud Raiser's Edge NXT®: General Discussion
Hello. I discovered randomly that we have blank phone fields in our database (both for e-mails and phone numbers), see screen shot below. Has anyone figured out how to query for these to remove them? When you query on phone number is blank, for example, the results incluces everyone who does not have a phone number.


0f7e18c737fd07373ff53e2b7ec376cf-huge-ph

 
Tagged:

Comments

  • Cathleen Mai
    Cathleen Mai
    Tenth Anniversary 100 Likes 100 Comments Name Dropper
    How about:


    Phone type equals Home

    AND

    Phone number is blank

     
  • Megan Thoms 2
    Megan Thoms 2
    Ninth Anniversary Photogenic 5 Likes First Comment

    Cathleen Mai:

    How about:


    Phone type equals Home

    AND

    Phone number is blank

     

    Perfect! Thank you! :)

  • Ryan Hyde
    Ryan Hyde
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper
    There's a RE plugin specifically for this phenomenon. Go to Plug-Ins and find the Delete Phones option. Click the "blank phone number" toggle and you should be all set.


    The problem with querying for them is that going from that to deleting them is difficult, unless there's only a small handful of them and you're just deleting them by hand. If that's the case, then the query is fine, but if you've got a few hundred of these things, the plugin is easier - though you have to be the only person in RE at the time you run the plugin.
  • Beth Romano
    Beth Romano
    Ancient Membership 10 Comments 25 Likes Photogenic

    Ryan Hyde:

    There's a RE plugin specifically for this phenomenon. Go to Plug-Ins and find the Delete Phones option. Click the "blank phone number" toggle and you should be all set.


    The problem with querying for them is that going from that to deleting them is difficult, unless there's only a small handful of them and you're just deleting them by hand. If that's the case, then the query is fine, but if you've got a few hundred of these things, the plugin is easier - though you have to be the only person in RE at the time you run the plugin.

    What version of RE has this plug-in? 

  • Alan French
    Alan French
    Tenth Anniversary 1,000 Likes 500 Comments Name Dropper

    Beth Romano:

    What version of RE has this plug-in? 

    There are versions available for 7.50 and upwards; you can download them from here.

  • Beth Romano
    Beth Romano
    Ancient Membership 10 Comments 25 Likes Photogenic

    Alan French:

    Beth Romano:

    What version of RE has this plug-in? 

    There are versions available for 7.50 and upwards; you can download them from here.

     

    Thank you for the link.

Categories