Two additional issues need to be resolved. It’s using an inner join on those parent expressions where it needs to use a left join, in addition to fixing the aggregate references. Working on it 
zachdaniel
Creator of Ash
0
zachdaniel
Creator of Ash
And it looks like potentially a bug in Ecto that needs to be fixed around inner_lateral_join vs left_lateral_join 
0
zachdaniel
Creator of Ash
Nevermind 
hours down the drain not realizing it was just a logic issue. As you had alluded to in the comments in your test, you need a filter like this:
filter expr(
is_nil(parent(post_view.viewed_post.inserted_at)) or
inserted_at > parent(post_view.viewed_post.inserted_at)
)
I still need to investigate the aggregates issue, but that shouldn’t affect your use case.
0
zachdaniel
Creator of Ash
Alright, I’m on the trail of the aggregate bug. I’ve got to step away for now, but should have it fixed this weekend or early next week. The fix for your original case if you use the snippet I showed above should be functional for now, but I won’t release until next week when I have the full fix and have verified w/ tests.
0
zachdaniel
Creator of Ash
Alright, this should be fully fixed in the latest release of ash_sql, with one small fix in ash_postgres which you should not need immediately. ash_postgres will be released next week.
1
