liquid_feedback_core

log

age author description
7 months ago jbe pgLatLon is now a stand-alone extension for PostgreSQLdefault tip
7 months ago jbe Fixed typo in documentation and comments: "indicies" -> "indices"; Marked make-doc.sh as executable
7 months ago jbe New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback
9 months ago jbe Work on new issue admission system (replacing current approach of 1st quorum); Added support for geo-tagging and spatial indexing
10 months ago jbe Updated LICENSE file (year 2016)
10 months ago jbe Merged experimental work on alternative mechanism to the first (issue) quorum
10 months ago jbe Added tag v3.2.2 for changeset bc6d9dc60ca4
10 months ago jbe Require members to be "activated" in order to receive messages/notifications; New views "member_eligible_to_be_notified" and "member_to_notify"v3.2.2
10 months ago jbe Set notification settings to zero/NULL/DEFAULT for deleted members
10 months ago jbe Fixed functions "delete_member" and "delete_private_data" to properly handle NULL constraints of "member" table
10 months ago jbe Exclude locked members as recipients in view "scheduled_notification_to_send"
10 months ago jbe Allow a value of zero as "notification_sample_size" to disable featured initiatives
10 months ago jbe Merged experimental work on alternative mechanism to the first (issue) quorum
10 months ago jbe Added tag v3.2.1 for changeset e4f619e87664
10 months ago jbe Fixed accidental PostgreSQL 9.5 dependency (because of UPSERT aka ON CONFLICT clause)v3.2.1
11 months ago jbe Added tag v3.2.0 for changeset ab05fb3bf974
11 months ago jbe Set column "notification_hour" of "member" table by default to random numberv3.2.0
11 months ago jbe Include column "published" in view "newsletter_to_send" (to make ordering easier)
11 months ago jbe Drop and re-create view "expired_session" in update script to v3.2.0 (necessary to alter column type in table "session")
11 months ago jbe Corrected execution order in update script to v3.2.0
11 months ago jbe Added comment on function "get_initiatives_for_notification"
11 months ago jbe Updated update script to v3.2.0
11 months ago jbe Added missing quote
11 months ago jbe Added SQL COMMENTs
11 months ago jbe Renamed tables "notification_sent" to "notification_event_sent" and "initiative_notification_sent" to "notification_initiative_sent"
11 months ago jbe Fixed syntax error in "get_initiatives_for_notification"
11 months ago jbe New algorithm for view "scheduled_notification_to_send"; Update "notification_sent" column in "get_initiatives_for_notification" function
11 months ago jbe New column "notification_sent" in "member" table; New view "scheduled_notification_to_send"
11 months ago jbe Exclude revoked initiatives from updated/featured/leading initiatives in notification system
11 months ago jbe Use "supporter_count" instead of "harmonic_weight" to determine leading initiative for notification system
11 months ago jbe Use "recipient_id" instead of "member_id" in function "get_initiatives_for_notification"
11 months ago jbe Fixed minor error in update script (DROP VIEW instead of DROP TABLE)
11 months ago jbe Revised notification system; Dropped tables "selected_event_seen_by_member" and "event_seen_by_member"
11 months ago jbe Corrected comparison operator in view "newsletter_to_send"
11 months ago jbe Added view "newsletter_to_send"
11 months ago jbe New table "newsletter"
11 months ago jbe Removed NOT NULL constraint for column "last_suggestion_id" in table "initiative_notification_sent" (NULL means that no suggestion existed)
11 months ago jbe Another bugfix in function "get_initiatives_for_notification"
11 months ago jbe Bugfix in function "get_initiatives_for_notification"
11 months ago jbe Updated preliminary update script for new notification system
11 months ago jbe New function "get_initiatives_for_notification"
11 months ago jbe Require new drafts or new suggestion in area for view "initiative_for_notification"
11 months ago jbe Fill columns "new_draft" and "new_suggestion_count" in views "updated_or_featured_initiative" and "leading_complement_initiative"
11 months ago jbe Ignore suggestions with opinion also in returned column "new_suggestion_count" of view "updated_initiative"
11 months ago jbe Ignore suggestions with opinion
11 months ago jbe New table "initiative_notification_sent"
11 months ago jbe Fixed further mistake in views "updated_initiative" and "updated_or_featured_initiative"
11 months ago jbe Sort harmonic_weight of NULL after zero in updated_or_featured_initiative
11 months ago jbe Fixed typo in "featured_initiative" function
11 months ago jbe Bugfix in function "featured_initiative"
11 months ago jbe Fixed wrong calculation of "leading" column
11 months ago jbe Removed wrong "ISNULL" in view "updated_initiative"
11 months ago jbe Repaired preliminary update script
11 months ago jbe Added preliminary update script
11 months ago jbe New columns "supported", "new_draft", "new_suggestion_count", "featured", "leading" in view "initiative_for_notification" and associated helper views
11 months ago jbe Function "featured_initiative" simplified
11 months ago jbe Added missing EXIT statement in featured_initiative function
11 months ago jbe New view "initiative_for_notification" using helper views/functions "updated_initiative", "featured_initiative", and "leading_complement_initiative"
11 months ago jbe New view "updated_initiative"
12 months ago jbe Removed experimental algorithm for determining issues to be included in notification mails

Impressum / About Us