1 local initiative = Initiative:by_id(param.get("initiative_id", atom.integer))

2 local issue = initiative.issue

3 local member = Member:by_id(param.get("member_id", atom.integer))

4

5 local members_selector = Member:new_selector()

6 :join("delegating_interest_snapshot", nil, "delegating_interest_snapshot.member_id = member.id")

7 :join("issue", nil, "issue.id = delegating_interest_snapshot.issue_id")

8 :add_where{ "delegating_interest_snapshot.issue_id = ?", issue.id }

9 :add_where{ "delegating_interest_snapshot.event = ?", issue.latest_snapshot_event }

10 :add_where{ "delegating_interest_snapshot.delegate_member_ids[1] = ?", member.id }

11 :add_field{ "delegating_interest_snapshot.weight" }

12

13 execute.view{

14 module = "member",

15 view = "_list",

16 params = {

17 members_selector = members_selector,

18 issue = issue,

19 trustee = member

20 }

21 }