liquid_feedback_core
changeset 611:a94f7cb8ed19
Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v)
author | jbe |
---|---|
date | Sun May 17 11:58:52 2020 +0200 (2020-05-17) |
parents | 22c6d1da7d78 |
children | 519826089133 |
files | core.sql |
line diff
1.1 --- a/core.sql Sat May 16 17:59:54 2020 +0200 1.2 +++ b/core.sql Sun May 17 11:58:52 2020 +0200 1.3 @@ -5384,7 +5384,7 @@ 1.4 ON "privilege"."unit_id" = "unit_id_v" 1.5 AND "privilege"."member_id" = "member"."id" 1.6 LEFT JOIN "issue_privilege" 1.7 - ON "issue_privilege"."issue_id" = "issue_id_v" 1.8 + ON "issue_privilege"."issue_id" = "issue_id_p" 1.9 AND "issue_privilege"."member_id" = "member"."id" 1.10 WHERE "member"."active" AND COALESCE( 1.11 "issue_privilege"."voting_right", "privilege"."voting_right");