Overview

This guide provides comprehensive information for creating effective Quick Filters in Studytrax.

Best Practices

Use Appropriate Operators

• Use = for exact matches
• Use ~= with wildcards for pattern matching
• Use IN for multiple value comparisons instead of multiple OR conditions

Date Filtering

• Use DATE() function for specific date comparisons
• Use DATEDIFF() for relative date ranges
• Always consider timezone implications in date comparisons

Performance Tips

• Put more selective conditions first in AND expressions
• Use IN operator instead of multiple OR conditions when possible
• Avoid complex arithmetic in filters when simple comparisons will suffice

Readability

• Use parentheses to clarify complex logical expressions
• Break complex filters into multiple simpler filters when possible
• Use meaningful variable names and consistent formatting

Examples