liquid_feedback_core

diff core.sql @ 617:8e9d0878b5dc

find changesets by author, revision, files, or words in the commit message
Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"
author jbe
date Mon Oct 05 16:18:17 2020 +0200 (2020-10-05)
parents ae53fc96c953
children 5b3b20f1278d
line diff
     1.1 --- a/core.sql	Tue Jul 28 18:57:20 2020 +0200
     1.2 +++ b/core.sql	Mon Oct 05 16:18:17 2020 +0200
     1.3 @@ -4174,8 +4174,8 @@
     1.4                "privilege"."member_id" = "recipient_id_p" AND
     1.5                "privilege"."unit_id" = "area"."unit_id"
     1.6              LEFT JOIN "issue_privilege" ON
     1.7 -              "privilege"."member_id" = "recipient_id_p" AND
     1.8 -              "privilege"."issue_id" = "initiative"."issue_id"
     1.9 +              "issue_privilege"."member_id" = "recipient_id_p" AND
    1.10 +              "issue_privilege"."issue_id" = "initiative"."issue_id"
    1.11              LEFT JOIN "subscription" ON
    1.12                "subscription"."member_id" = "recipient_id_p" AND
    1.13                "subscription"."unit_id" = "area"."unit_id"

Impressum / About Us