liquid_feedback_core

log

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

Impressum / About Us