You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
analytics/lib/plausible/stats/custom_props.ex

33 lines
822 B
Elixir

defmodule Plausible.Stats.CustomProps do
@moduledoc """
Module for querying user defined 'custom properties'.
"""
alias Plausible.Stats.Query
use Plausible.ClickhouseRepo
import Plausible.Stats.Base
def fetch_prop_names(site, query) do
case Query.get_filter_by_prefix(query, "event:props:") do
{"event:props:" <> key, _} ->
[key]
_ ->
from(e in base_event_query(site, query),
array_join: meta in fragment("meta"),
select: meta.key,
distinct: true
)
|> maybe_allowed_props_only(site)
|> ClickhouseRepo.all()
end
end
def maybe_allowed_props_only(q, site) do
case Plausible.Props.allowed_for(site) do
:all -> q
allowed_props -> from [..., m] in q, where: m.key in ^allowed_props
end
end
end