bsw@3: local initiative = Initiative:by_id(param.get("initiative_id", atom.integer)) bsw@3: local issue = initiative.issue bsw@3: local member = Member:by_id(param.get("member_id", atom.integer)) bsw@3: bsw@3: local members_selector = Member:new_selector() bsw/jbe@4: :join("delegating_interest_snapshot", nil, "delegating_interest_snapshot.member_id = member.id") bsw@177: :join("issue", nil, "issue.id = delegating_interest_snapshot.issue_id") bsw/jbe@4: :add_where{ "delegating_interest_snapshot.issue_id = ?", issue.id } bsw/jbe@4: :add_where{ "delegating_interest_snapshot.event = ?", issue.latest_snapshot_event } bsw/jbe@4: :add_where{ "delegating_interest_snapshot.delegate_member_ids[1] = ?", member.id } bsw/jbe@4: :add_field{ "delegating_interest_snapshot.weight" } bsw@3: bsw@3: execute.view{ bsw@3: module = "member", bsw@3: view = "_list", bsw@3: params = { bsw@3: members_selector = members_selector, bsw@3: issue = issue, bsw@3: trustee = member bsw@3: } bsw@3: }