Function getGroupPropertyKeys

packages/db/src/services/group.service.ts:235–245

(
  projectId: string
)

}

export async function getGroupPropertyKeys(
  projectId: string
): Promise<string[]> {
  const rows = await chQuery<{ key: string }>(`
    SELECT DISTINCT arrayJoin(mapKeys(properties)) as key
    FROM ${TABLE_NAMES.groups} FINAL
    WHERE project_id = ${sqlstring.escape(projectId)}
      AND deleted = 0
  `);
  return rows.map((r) => r.key).sort();
}

export type IServiceGroupStats = {
  groupId: string;