SHOW items WHERE category_id IN (selected_category_ids)Selected: "Performance", "Bug Reports"
Result: All items in either categorySelect: All categories
Purpose: See everything
Use: Initial review, reportingSelect: "Bug Reports" only
Purpose: Bug fixing session
Use: Engineering team reviewSelect: "UI/UX", "Mobile"
Purpose: Design improvements
Use: Design team planningSHOW items WHERE:
(type = 'idea' AND status_id IN (selected_idea_statuses))
OR
(type = 'issue' AND status_id IN (selected_issue_statuses))Idea Status: "Under Review"
Issue Status: "New"
Result: Items needing initial reviewIdea Status: "In Progress"
Issue Status: "In Progress", "Investigating"
Result: Active work itemsIdea Status: "Completed"
Issue Status: "Resolved", "Closed"
Result: Finished items for reportingif (statusControl === 'custom') {
// Use product-specific statuses
} else {
// Use default system statuses
}created_at)SHOW items WHERE created_at >= (now - selected_range)Selected: "Last 7 days"
Calculation: created_at >= (current_date - 7 days)
Result: Items created in past weekRange: "Today" or "Last 7 days"
Purpose: Daily/weekly review
Use: Triage, trending analysisRange: "Last 30 days"
Purpose: Monthly retrospective
Use: Team meetings, reportingRange: "Last 90 days"
Purpose: Quarterly planning
Use: Strategic roadmap sessionsRange: "Last year" or "All time"
Purpose: Long-term trends
Use: Annual planning, pattern analysisType: Issue
Category: Bug Reports
Date: Last 7 days
Result: Bugs reported this weekType: Idea
Status: Completed
Date: Last 90 days
Result: Features shipped this quarterif (isIdeaTypeSelected && !isIssueTypeSelected) {
SHOW WHERE type = 'idea'
} else if (isIssueTypeSelected && !isIdeaTypeSelected) {
SHOW WHERE type = 'issue'
} else {
SHOW both types
}Type: Ideas only
Purpose: Roadmap planning
Use: Product team meetingsType: Issues only
Purpose: Bug fixing sprint
Use: Engineering focus timeType: Both (no selection)
Purpose: Complete picture
Use: Executive reportingSHOW items WHERE user_id = current_user.idFilter: My Contributions
Result: All items you createdSHOW items WHERE id IN (
SELECT feedback_item_id
FROM votes
WHERE user_id = current_user.id
)Filter: Voted By Me
Result: All items you've upvotedMy Contributions + Voted By Me
Result: Items you created OR voted onMATCH(title, short_description, long_description)
AGAINST (search_term IN NATURAL LANGUAGE MODE)Search: "export"
Finds: Items about export functionalitySearch: "mobile app crash"
Finds: Items about mobile crashesSearch: "performance slow loading"
Finds: Items about performance issuesSearch: "authentication"
Category: "Security"
Type: Issue
Date: Last 30 days
Result: Recent security authentication issuesType: "per" → (wait)
Type: "f" → (wait)
Type: "ormance" → (400ms pause) → Search executesCategories: "Performance" OR "Bug Reports"
Statuses: "New" OR "Under Review"Category: "Performance"
AND Status: "New"
AND Date: "Last 7 days"Type: Issue
Category: Bug Reports
Status: New
Date: Last 7 days
Result: Recent unprocessed bugsType: Idea
Category: Feature Request
Status: Planned, In Progress
Tab: Top
Result: Popular planned featuresSearch: "customer_name"
Date: Last 30 days
Type: Both
Result: All recent feedback from specific customerStatus: Completed (Ideas), Resolved (Issues)
Date: Last 90 days
Tab: Backlog
Result: Quarterly completion report?category=performance&status=new&date=7daysGoal: Everything except "Declined"
Method: Select all statuses except Declined1. Identify low-engagement segment
2. Search for segment name
3. Review their specific feedbackWeek 1: Date = Last 7 days, Count items
Week 2: Date = Last 7 days, Count items
Compare: Identify growth or decline1. Filter: Category A
2. Note item count
3. Filter: Category B
4. Note item count
5. Filter: Category A + B
6. If count < (A + B), items overlapTab: New
Date: Last 24 hours
Status: UnprocessedType: Issue
Category: Bug Reports
Status: New, InvestigatingType: Idea
Tab: Top
Status: Under Review, PlannedSearch: [Customer Name]
Tab: Backlog
Date: Last 30 daysStatus: Completed, Resolved
Date: Last 90 days
Tab: Backlog| Filter Type | Selection | Logic | Use Case |
|---|---|---|---|
| Category | Multi-select | OR | Topic-based filtering |
| Status | Multi-select | OR within type | Workflow stage filtering |
| Date Range | Single select | >= date | Time-based analysis |
| Work Item Type | Exclusive | Single type | Ideas vs. Issues |
| Activity | Multi-select | OR | Personal tracking |
| Search | Text input | Full-text | Keyword finding |