Query on Employer Relationship Field

Options
Corie Weaver
Corie Weaver ✭
Seventh Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Is there a way to run a query that brings up only those people who have an employer in the relationship tab?


I'm hoping to run a constituent profile report on them. I'm pretty sure I know how to run it to show the employer - but I don't want folks that don't have an employer listed.  I'm not seeing a way to filter on that, so figured it probably needs to be done from the initial query.


(or, if there's a way to add employer as a column in nxt, that would do me too, but I'm pretty sure there's not.)


Thanks for any assistance!
Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    You should be able to query - it depends on your data entry.  Do you check 'employee' check box? Do you have relationship/reciprocal that has 'employee/employer'? 


    However it's recorded in your system a query like criteria for relationships business - employee equals yes would be one way.
  • Corie Weaver
    Corie Weaver ✭
    Seventh Anniversary Photogenic First Reply
    It looks like we *don't* always check the Employee box, but it is set up as a Relationship, and Reciprocal. I'll give it a try - thanks!

     
  • Katherine Manniion
    Katherine Manniion ✭
    Fifth Anniversary Facilitator 1 Name Dropper Photogenic
    You could also try this in criteria (for a Constituent query)....


    Key Indicator equals Individual

    AND Organization Relationship Organization Name not blank

     
  • Corie Weaver
    Corie Weaver ✭
    Seventh Anniversary Photogenic First Reply
    Thank you both!  I have what my boss wanted now :)

Categories