1 local initiatives_selector = Initiative:new_selector()

2 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")

3 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")

4 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })

5

6 if initiatives_selector:count() > 0 then

7 ui.container{

8 attr = { style = "font-weight: bold;" },

9 content = _"Open initiatives you are supporting which has been updated their draft:"

10 }

11

12 execute.view{

13 module = "initiative",

14 view = "_list",

15 params = { initiatives_selector = initiatives_selector }

16 }

17 end