Search & Filters
DrillerDB provides powerful search and filtering tools to help you find projects quickly, even when managing hundreds of jobs.
Projects List
Basic Search
The project search bar at the top of the Projects screen searches across multiple fields:
- Project number and name
- Customer name and company
- Well location and address
- Project notes and descriptions
Simply type your search term and results appear instantly. Search is case-insensitive and matches partial words.
Status Filters
Click the status buttons above the project list to filter by project status:
- All - Show all projects regardless of status
- Proposals - Active proposals waiting for customer approval
- Open - Active drilling jobs in progress
- Completed - Finished jobs ready for invoicing
- Closed - Archived projects
The number badge on each button shows how many projects are in that status.
Advanced Filters
Click the "Filters" button to access advanced filtering options:
Date Range Filters
- Filter by creation date, start date, or completion date
- Use preset ranges (This Week, This Month, This Quarter, This Year)
- Or select custom date ranges with the date picker
Customer Filters
- Filter by specific customer or company
- View all projects for a single customer
- Combine with other filters for detailed analysis
Location Filters
- Filter by city, state, or zip code
- Find all projects in a specific area
- Useful for route planning and regional analysis
Crew and Equipment Filters
- Filter by assigned crew members
- Filter by equipment used
- Track specific driller or rig activity
Sorting Options
Click any column header to sort the project list:
- Project number (ascending or descending)
- Customer name (alphabetical)
- Creation date (newest or oldest first)
- Project status
- Total amount
Click the same header twice to reverse the sort direction. A small arrow indicates the current sort column and direction.
Saved Searches
Save frequently used filter combinations for quick access:
- Set up your desired filters and search criteria
- Click "Save Search" above the filter panel
- Give your saved search a descriptive name
- Access saved searches from the dropdown menu
Common saved searches include:
- This Week's Completed Jobs
- Open Proposals Over $10,000
- My Assigned Projects
- Projects Needing Invoices
Saved searches are personal to your account but can be shared with team members through the Settings panel.
Quick Tips
- Use the search bar for quick lookups by name or number
- Combine multiple filters for precise results
- Clear all filters with the "Reset" button
- Export filtered results to Excel for reporting
- Bookmark the URL after filtering to save your view