When creating a dynamic group, or if your company has purchased the Dynamic Task Assigner plug-in, there are number of fields you can utilize within a SQL query to retrieve contacts stored in Integrify.
The table you will need to refer to is the CONTACT table and the available fields are:
| CONTACT_GUID |
| CONTACT_ID |
| NT_ID |
| FIRST_NAME |
| MIDDLE_NAME |
| LAST_NAME |
| EMAIL |
| PHONE |
| LOCATION |
| ADDRESS1 |
| ADDRESS2 |
| CITY |
| STATE |
| ZIP |
| COUNTRY |
| TITLE |
| DEPARTMENT |
| COST_CENTER |
| DIVISION |
| REPORTS_TO_GUID |
| C_FIELD_1 |
| C_FIELD_2 |
| LAST_UPDATE |
| TIMEZONE |
| CREATED_DATE |
| CREATED_BY |
| MODIFIED_DATE |
| MODIFIED_BY |
| DELETED_DATE |
| DELETED_BY |
One key item to remember when defining your query is to filter out deleted users:
select contact_id
from CONTACT
where DELETED_DATE is NULL
Integrify will not truly delete a contact rather it will mark it as deleted so by retrieving only records with a NULL value in the DELETED_DATE field you will only retrieve users who are active in the system.