Marius Andra

feat(hogql): ignore future persons

1

## Problem https://posthog.slack.com/archives/C02E3BKC78F/p1716558850878309?thread_ts=1716503393.145799&cid=C02E3BKC78F ## Changes Exclude persons with future created_at dates ## Does this work well for both Cloud and self-hosted? I hope so. ## How did you test this...

feat(hogql): inline filters into subqueries

2

## Problem Selecting from events is slow, if filtering by a person filter on the event. https://github.com/PostHog/posthog/issues/22427 We can build HogQL level solutions (or tools?) to make this easy. ##...

Sprint - July 1 to July 12, 2024

1

# Global Sprint Planning ## 3 things that might take us down 1. 2. 3. # Team sprint planning For your team sprint planning copy this template into a comment...

CDP Q3

1

## Changes Adds Team CDP Q3 objectives. ## Checklist - [ ] Words are spelled using American English - [ ] Titles are in [sentence case](https://apastyle.apa.org/style-grammar-guidelines/capitalization/sentence-case) - [ ] Feature...

## Problem Alternative to https://github.com/PostHog/posthog/pull/24636 ## Changes Adds support for `arrayMap`, `arrayExists`, `arrayFilter`: ```rust print(arrayMap(x -> x * 2, [1,2,3])) print(arrayExists(x -> x like '%nana%', ['apple', 'banana', 'cherry'])) print(arrayFilter(x ->...

Wrong property type displayed in the live events list

4

## Bug description There is a subtle uncommunicated discrepancy with property types on the live events page. ## How to reproduce I sent this event locally: ```js posthog.capture('test event', {...

feat(hog): fix elements matching

3

## Problem It started from this:  This exposes two problems: - we don't have the new materialized `elements_chain_*` columns in Hog globals - we can't run functions that use...

feat(hogvm): log when error in filter

1

## Problem If HogVM throws any error during CDP event filtering, it's lost (except for pod logs). ## Changes Logs an error each time something in the filter throws. ##...

## Problem  ## Changes Running `print(expr)` prints out the (unsanitized) SQL, just running `expr` in the console will still show the classes. I couldn't get the latter to work...

feat(hogql): stringOr ^^

1

## Problem We want to easily get the first _not empty_ string in Hog/QL: In JavaScript: ```js const a = null const b = '' const c = 'banana' const...