# Filtering & Sorting

## Sorting

Click a column header to sort ascending (↑); click again to sort descending (↓); click a third time to remove the sort.

## Filtering

1. Click the **Filter** icon

<figure><img src="https://2094208261-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCZc46qaaBbVmMuYXPfgz%2Fuploads%2FtHW3s61UBs7vQtlaShj8%2Fimage.png?alt=media&#x26;token=caa51a5a-b3e6-4a7d-9b83-293003f1ddfc" alt=""><figcaption></figcaption></figure>

2. Select an attribute (Department, Location, Pay Grade, etc.)
3. Choose values to include
4. Click **Apply**

Active filters appear as tags above the table. Multiple filters use AND logic — all conditions must be true. Click the **X** on any tag to remove it; use **Clear All** to reset.

* **Filter by calculated fields** — Direct SOC = 1–2 (low spans), Layer = 6+ (deep org), Total Org Size > 50 (large orgs)
* **Filter by empty values** — Employee Name = (empty) finds vacant positions

**Note:** Active filters persist across Directory and Org Chart views. Always check for active filters if data looks unexpected.

## Search

Type in the search box to find positions by name, title, or any attribute. Partial matches work and search is case-insensitive. Search only scans currently filtered (visible) rows.

<figure><img src="https://2094208261-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCZc46qaaBbVmMuYXPfgz%2Fuploads%2FRsoxGGMa64gD6utYHcVq%2Fimage.png?alt=media&#x26;token=9334df4e-121e-4201-ba86-23febd35f97b" alt=""><figcaption></figcaption></figure>

## Common Workflows

**Analyze department compensation** — Filter = Department > Sort = Salary (high→low) > Export CSV.

**Find compression** — Filter = Direct SOC = 1–2 AND Pay Grade > 12 > Sort = Layer (low→high).

**Vacancy list for recruiting** — Filter = Employee Name = (empty) > Sort = Department (A→Z) > Export CSV.

**Pay equity check** — Filter = Job Title = "Software Engineer" > Sort = Salary (high→low) to compare across departments and locations.

**Find recent hires** — Sort = Start Date (newest→oldest).

## Troubleshooting

| Problem                        | Solution                                                 |
| ------------------------------ | -------------------------------------------------------- |
| Can't find expected positions  | Check active filters; clear all and search again         |
| Sort not working               | Remove existing sort (click header 3×), then re-sort     |
| Filter options missing a value | That value doesn't exist in the data — check your import |
| Search returns no results      | Search only scans filtered rows; clear filters and retry |

## Related Articles

* [Column Customization](https://docs.agentnoon.com/directory/columns-customization)
* [Bulk Operations](https://docs.agentnoon.com/directory/bulk-operations)
