Query on Employer Relationship Field

Corie Weaver

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!

JoAnn Strommen

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

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 Mannion

You could also try this in criteria (for a Constituent query)....


Key Indicator equals Individual

AND Organization Relationship Organization Name not blank

 

Corie Weaver

Thank you both!  I have what my boss wanted now