Query staff using end date

Question

How can I query a specific staff class+staff type, and exclude a staff member that has an end date?

Answer 1

Use generic.

Query>Generic, Choose Table, "Staff".

Comments

Sorry, I wasn't clear.

If a staff member leaves in the middle of the year, we enter their last day as their 'date end'. I don't think it's the same field as the end-date field in generic.

I want to be able to pull a list of specific staff classes and/or specific class types (if there are multiple per class), but it should exclude any staff member that left/has an entry in the date end column.

How can I do that?

Thanks!

---

When doing the query in Generic, also select the field StaffDateEnd.
Set the condition to “Field Is Null” and click Add.
This will remove any staff members who have an end date and include only those whose end date is empty.

---

I.E.

---

Got it. It's a drop crazy to keep going back to generic and creating this query every time I want to pull a staff list/send a SMS to staff, etc.

Can we include a feature in the staff tab, to query by staff end date?

Thank you!