Skip to main content

Search and Filtering

Learn how to efficiently locate and organize payment records in DooUMS using search, filtering, and pagination features.

Overview​

The search and filtering system in DooUMS helps you quickly locate specific payments among potentially thousands of records. Effective use of these features is essential for:

  • Daily Operations: Finding specific payments for verification or editing
  • Bank Reconciliation: Matching payments with bank statements
  • Customer Service: Locating pilgrim payment histories quickly
  • Financial Reporting: Filtering data for specific time periods or criteria
  • Audit Preparation: Organizing records by verification status or date ranges

Search Functionality​

The main search bar allows quick lookup using multiple criteria:

Search Terms That Work​

  • Pilgrim Names: Full or partial names
  • Receipt Numbers: Exact or partial receipt numbers
  • Reference Numbers: Bank reference or transaction IDs
  • Notes Content: Keywords from description fields

Search Examples​

✅ "Faizah" → Finds all payments for pilgrims named Faizah
✅ "R250" → Finds receipts starting with R250
✅ "CIMB" → Finds payments with CIMB in reference or notes
✅ "Final Payment" → Finds all final payment transactions

Pagination and Navigation​

Pagination Controls​

Standard Pagination​

  • First Page: Jump to beginning
  • Previous Page: Go back one page
  • Next Page: Advance one page
  • Last Page: Jump to end
  • Direct Page: Enter specific page number

Results Per Page​

Common options:

  • 10 records - Quick browsing
  • 25 records - Standard view
  • 50 records - Detailed review
  • 100 records - Bulk operations

Large Dataset Handling​

  • Use filters to reduce result sets before browsing
  • Sort by relevant criteria for your task
  • Bookmark frequently accessed filter combinations
  • Export filtered results for offline review

Performance Optimization​

  • Apply date filters for large databases
  • Use specific search terms rather than browsing
  • Limit results per page for faster loading
  • Clear unnecessary filters when switching tasks

Quick Search Workflows​

Daily Verification Workflow​

  1. Filter: Payment Date = Yesterday
  2. Filter: Status = Not Verified
  3. Sort: By amount (highest first)
  4. Action: Verify each payment systematically

Bank Reconciliation Workflow​

  1. Search: Bank name (e.g., "CIMB")
  2. Filter: Specific date range from bank statement
  3. Filter: Verified status = All
  4. Sort: By payment date
  5. Action: Match each payment with bank statement

Customer Service Workflow​

  1. Search: Pilgrim name provided by customer
  2. Filter: All payment types
  3. Sort: By payment date (newest first)
  4. Action: Review payment history with customer

Month-End Reporting Workflow​

  1. Filter: Payment Date = Previous month
  2. Filter: Status = Verified only
  3. Sort: By payment type, then by date
  4. Action: Generate monthly payment report

Search Performance Tips​

Optimization Strategies​

Efficient Search Practices​

  • ✅ Start Specific: Use detailed search terms
  • ✅ Filter First: Apply date/status filters before searching
  • ✅ Sort Strategically: Choose relevant sort orders
  • ✅ Limit Results: Use appropriate page sizes

Avoid Performance Issues​

  • ❌ Overly Broad Searches: Searching without any filters
  • ❌ Complex Wildcards: Multiple partial terms
  • ❌ Large Page Sizes: 500+ records per page
  • ❌ Frequent Filter Changes: Rapid filter switching

Troubleshooting Search Issues​

Common Search Problems​

No Results Found​

Possible Causes:

  • Too specific search criteria
  • Typos in search terms
  • Restrictive date filters
  • Incorrect status filters

Solutions:

  • Broaden search terms
  • Check spelling and formatting
  • Expand date ranges
  • Review all filter settings

Too Many Results​

Possible Causes:

  • Overly broad search terms
  • Missing date filters
  • No status filters applied

Solutions:

  • Add specific search terms
  • Apply date range filters
  • Use verification status filters
  • Sort by relevant criteria

Slow Search Performance​

Possible Causes:

  • Large date ranges
  • No filters applied
  • Complex search terms
  • High page size settings

Solutions:

  • Narrow date ranges
  • Apply status or type filters
  • Simplify search terms
  • Reduce results per page

Search Validation​

Verifying Search Results​

  • ✅ Count Validation: Confirm expected number of results
  • ✅ Spot Checking: Verify random results match criteria
  • ✅ Edge Cases: Test boundary conditions
  • ✅ Filter Verification: Confirm all filters are applied correctly

Next Steps​