1 local issue = Issue:by_id(param.get("issue_id", atom.integer))

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

3

4 local members_selector = Member:new_selector()

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

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

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

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

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

10 :add_field{ "delegating_interest_snapshot.weight" }

11

12 execute.view{

13 module = "member",

14 view = "_list",

15 params = {

16 members_selector = members_selector,

17 issue = issue,

18 trustee = member

19 }

20 }