cojennin on "[Plugin: Edit Flow] Update post modified date on new comment"

Hi there.
What would be the best and safest solution to order the posts by the last editorial Idea date?

Joining the Idea table in the main query seams heavy solution, so I though about updating the post modified field.

Does anyone have better suggestion?

Thanks a lot in advance.

https://wordpress.org/plugins/edit-flow/

Updating the post modified field might cause some issues. Did you already try joining on the Idea table? I'm not sure what the best solution would be, but that's where I'd start. Only if it ends up being problematic would I try to look for ways to optimize.