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/property.py
table: TableWithProperties,
    property_name: PropertyName,
    var: str,
    prop_var: str,
    allow_denormalized_props: bool = True,
) -> Tuple[str, bool]:
    materialized_columns = get_materialized_columns(table) if allow_denormalized_props else {}
    
    if allow_denormalized_props and property_name in materialized_columns and table == "events":
        return materialized_columns[property_name], True
    return f"trim(BOTH '\"' FROM JSONExtractRaw({prop_var}, {var}))", False
def box_value(value: Any, remove_spaces=False) -> List[Any]:
    if not isinstance(value, List):
        value = [value]
    return [str(value).replace(" ", "") if remove_spaces else str(value) for value in value]
def get_property_values_for_key(key: str, team: Team, value: Optional[str] = None):
    parsed_date_from = "AND timestamp >= '{}'".format(relative_date_parse("-7d").strftime("%Y-%m-%d 00:00:00"))
    parsed_date_to = "AND timestamp <= '{}'".format(timezone.now().strftime("%Y-%m-%d 23:59:59"))
    if value:
        return sync_execute(
            SELECT_PROP_VALUES_SQL_WITH_FILTER.format(parsed_date_from=parsed_date_from, parsed_date_to=parsed_date_to),
            {"team_id": team.pk, "key": key, "value": "%{}%".format(value)},
        )
    return sync_execute(
        SELECT_PROP_VALUES_SQL.format(parsed_date_from=parsed_date_from, parsed_date_to=parsed_date_to),
        {"team_id": team.pk, "key": key},
    )
def filter_element(filters: Dict, prepend: str = "") -> Tuple[str, Dict]: