bsw@57: local initiatives_selector = Initiative:new_selector()
bsw@57:   :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
bsw@57:   :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
bsw@57:   :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
bsw@57: 
bsw@57: if initiatives_selector:count() > 0 then
bsw@57:   ui.container{
bsw@57:     attr = { style = "font-weight: bold;" },
bsw@57:     content = _"Open initiatives you are supporting which has been updated their draft:"
bsw@57:   }
bsw@57: 
bsw@57:   execute.view{
bsw@57:     module = "initiative",
bsw@57:     view = "_list",
bsw@57:     params = { initiatives_selector = initiatives_selector }
bsw@57:   }
bsw@57: end