Trying to add an href filter containing URL path (/admin/sites/*/courses/42400-example-course), but it’s returning 0 results, when I use a wildcard (% or *), but when I search a specific path (/admin/sites/56306/courses/42400-example-course), it returns results. What am I doing wrong?
ee/clickhouse/models/test/test_property.py
return [
        _create_event(event="$pageview", team=team, distinct_id="whatever", properties={"email": "test@posthog.com"},),
        _create_event(event="$pageview", team=team, distinct_id="whatever", properties={"email": "mongo@example.com"},),
        _create_event(event="$pageview", team=team, distinct_id="whatever", properties={"attr": "some_val"},),
        _create_event(event="$pageview", team=team, distinct_id="whatever", properties={"attr": "50"},),
        _create_event(event="$pageview", team=team, distinct_id="whatever", properties={"attr": 5},),
    ]
@pytest.mark.parametrize(
    "property,expected_event_indexes",
    [
        (Property(key="email", value="test@posthog.com"), [0]),
        (Property(key="email", value="test@posthog.com", operator="exact"), [0]),
        (Property(key="email", value=["pineapple@pizza.com", "mongo@example.com"], operator="exact"), [1]),
        (Property(key="attr", value="5"), [4]),
        (Property(key="email", value="test@posthog.com", operator="is_not"), range(1, 5)),
        (Property(key="email", value=["test@posthog.com", "mongo@example.com"], operator="is_not"), range(2, 5)),
        (Property(key="email", value=r".*est@.*", operator="regex"), [0]),
        (Property(key="email", value=r"?.", operator="regex"), []),
    ],
)
def test_prop_filter_json_extract(test_events, property, expected_event_indexes):
    query, params = prop_filter_json_extract(property, 0)
    uuids = list(sorted([uuid for (uuid,) in sync_execute(f"SELECT uuid FROM events WHERE 111 = 111 {query}", params)]))
    expected = list(sorted([test_events[index] for index in expected_event_indexes]))
    assert uuids == expected