Report Platform Bug to Base44

🚨 CRITICAL BUG REPORT: Base44 Platform Filter System Failure

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

App ID: 68eed6a8ca9efc733033fb04
App Name: Snappy English (Grammar Academy)
Reporter: barnabyieals@gmail.com
Date: 2026-10-13T18:45:19.543Z
Priority: PRODUCTION BLOCKER ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## THE BUG

Multi-field entity filters fail with Python TypeError:
"unsupported operand type(s) for |: 'dict' and 'str'"

This occurs in YOUR Base44 backend filter system, not our application code.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## REPRODUCTION (100% Reproducible)

✅ Single-field filter WORKS:
await base44.entities.DailyCrossword.filter({
  puzzle_date: "2025-11-11"
});
→ Success, returns array

❌ Multi-field filter FAILS:
await base44.entities.DailyCrossword.filter({
  puzzle_date: "2025-11-11",
  thinking_style: "critical"
});
→ 500 Internal Server Error
→ Python TypeError in Base44 backend

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## ERROR DETAILS

URL: https://base44.app/api/apps/68eed6a8ca9efc733033fb04/entities/DailyCrossword
Query: ?q={"puzzle_date":"2025-11-11","thinking_style":"critical"}
Status: 500 Internal Server Error

Response:
{
  "error_type": "TypeError",
  "message": "unsupported operand type(s) for |: 'dict' and 'str'",
  "detail": "unsupported operand type(s) for |: 'dict' and 'str'",
  "traceback": ""
}

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## AFFECTED ENTITIES

Confirmed failing (100% reproducible):
- DailyCrossword
- CurrencyPack
- GrammarTopic
- All entities with multi-field filter queries

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## BUSINESS IMPACT

❌ Daily Crossword feature unusable
❌ Shop system broken (can't filter active packs)
❌ Grammar module loading broken
❌ User progress tracking broken
❌ Assignment system broken
❌ All complex data queries failing
❌ PRODUCTION LAUNCH BLOCKED INDEFINITELY

Time lost: 5+ days debugging a platform issue
Revenue impact: Cannot monetize product
User impact: App is non-functional

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## ROOT CAUSE (Technical Analysis)

Base44's backend filter system uses Python's | operator to merge filter 
conditions. When processing multi-field queries, it's trying to merge 
incompatible types (dict and str), causing TypeError.

Expected behavior:
filter1 = {"puzzle_date": "2025-11-11"}
filter2 = {"thinking_style": "critical"}
combined = filter1 | filter2  # Should work in Python 3.9+

Actual bug:
The merge operation fails because one operand is a dict and the other 
is a string.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## SUGGESTED FIX

def build_query_filter(params):
    result = {}
    for key, value in params.items():
        filter_part = build_single_filter(key, value)
        if isinstance(filter_part, dict):
            result = result | filter_part  # Safe merge
        elif isinstance(filter_part, str):
            result[key] = filter_part  # Add as key-value
        else:
            result.update(filter_part)  # Handle other types
    return result

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## WHAT WE NEED FROM BASE44

1. ✅ Acknowledge this bug - Within 24 hours
2. ✅ Provide ETA for fix - Within 48 hours
3. ✅ Deploy hotfix - Within 1 week
4. ✅ Test thoroughly - Ensure multi-field filters work
5. ✅ Compensate for lost development time

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## TECHNICAL ENVIRONMENT

- SDK Version: @base44/sdk@0.8.4 (latest)
- Platform: Deno Deploy (backend functions)
- Frontend: React + TanStack Query
- Browser: Multiple browsers tested (Chrome, Firefox, Safari)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

## CONTACT INFORMATION

Email: contact@snappyidioms.com
App ID: 68eed6a8ca9efc733033fb04
Reporter: Samuel Minionis (barnabyieals@gmail.com)

Available for:
- Screen sharing to demonstrate bug
- Testing hotfixes
- Providing additional diagnostics
- Beta testing patches before public release

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

THIS IS A PRODUCTION BLOCKER.

We cannot launch with this bug. Our entire business model depends 
on being able to query data with multiple conditions.

Please escalate to your engineering team immediately.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

End of Bug Report

Generated: 13/10/2026, 18:45:19