Page MenuHomePhabricator
Create Task
Maniphest T303642

Remove the user from the participants list into the database
Closed, ResolvedPublic
Actions

Description

As a Dev, I want to remove (soft delete) the user from the list of participants of a giving event registration id

Background: Users should be able to leave events, but it would be useful for organizers if it is a soft delete so that: 1) organizers can see total number of people who have left event, 2) organizers can see who left event, so they can maybe see if there are patterns (such as being from certain wikis, communities, etc), and 3) we could potentially have a field/dropdown in the future where participant can optionally share why they are leaving the event that can be shared with organizer. This is not something we need to display in the UI for V0, but it could be useful for MVP and V2.

Acceptance criteria:

The user must be soft deleted on the list of participants in the database

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Create a REST endpoint for unregistering as a participantDaimona Eaytoymediawiki/extensions/CampaignEventsmaster+329 -42
Implement soft deletion of participantsDaimona Eaytoymediawiki/extensions/CampaignEventsmaster+79 -8
Customize query in gerrit

Related Objects
Search...

Event Timeline

cmelo created this task.Mar 11 2022, 8:21 PM
Daimona added a project: CampaignEvents.Mar 18 2022, 12:13 PM
gerritbot added a comment.Mar 22 2022, 2:58 PM

Change 772845 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] Create a REST endpoint for unregistering as a participant

https://gerrit.wikimedia.org/r/772845

gerritbot added a project: Patch-For-Review.Mar 22 2022, 2:58 PM
Daimona subscribed.Mar 22 2022, 3:02 PM

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Daimona claimed this task.Mar 22 2022, 3:02 PM
Daimona edited projects, added: Connection-Team (Campaign-Tools-Sprint-9); removed: Connection-Team.
Daimona moved this task from Ready 🎬 to Review/Feedback 💬 on the Connection-Team (Campaign-Tools-Sprint-9) board.
ifried updated the task description. (Show Details)Mar 22 2022, 3:48 PM
ifried updated the task description. (Show Details)
ifried updated the task description. (Show Details)Mar 22 2022, 3:50 PM
Daimona added subscribers: • vyuen, • JCarvalho.Mar 23 2022, 1:43 PM

We do need to change our schema to allow soft deletion. I was thinking that we could have another field in the ce_participants table, e.g. cep_deleted that is 1 if the participant unregistered and 0 otherwise. @vyuen @cmelo @JCarvalho What do you think?

cmelo added a comment.Mar 23 2022, 1:44 PM
In T303642#7796784, @Daimona wrote:

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

Daimona added a subscriber: ifried.Mar 23 2022, 3:45 PM
In T303642#7799720, @cmelo wrote:
In T303642#7796784, @Daimona wrote:

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

That's a good point, but is it needed?. @ifried do we need to know when a participant has unregistered from an event?

gerritbot added a comment.Mar 28 2022, 6:19 PM

Change 773624 had a related patch set uploaded (by Daimona Eaytoy; author: Daimona Eaytoy):

[mediawiki/extensions/CampaignEvents@master] Implement soft deletion of participants

https://gerrit.wikimedia.org/r/773624

cmelo added a comment.Mar 29 2022, 7:33 PM
In T303642#7800289, @Daimona wrote:
In T303642#7799720, @cmelo wrote:
In T303642#7796784, @Daimona wrote:

The user must be soft deleted

Oh, I didn't notice this. @cmelo do we need soft deletion for V0? The schema we created doesn't seem to support that.

Hi @Daimona, yes we need to create a new field into the database, I think it should be a deleted_at (timestamp)

That's a good point, but is it needed?. @ifried do we need to know when a participant has unregistered from an event?

This could help us in case we have scenarios like:

We want to track when participant are unregistering for events.
We could get information like, almost 80% of participants unregister 2 days before the event, with this information we can help organizers informing them to send a reminder or a motivation message 3 days before the event to encourage the participants to attend.

gerritbot added a comment.Mar 31 2022, 9:38 PM

Change 773624 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Implement soft deletion of participants

https://gerrit.wikimedia.org/r/773624

Daimona mentioned this in rUCAM827a48d21f26: Implement soft deletion of participants.Mar 31 2022, 9:38 PM
gerritbot added a comment.Apr 1 2022, 12:17 PM

Change 772845 merged by jenkins-bot:

[mediawiki/extensions/CampaignEvents@master] Create a REST endpoint for unregistering as a participant

https://gerrit.wikimedia.org/r/772845

Daimona mentioned this in rUCAM4f699b765940: Create a REST endpoint for unregistering as a participant.Apr 1 2022, 12:17 PM
Daimona removed a project: Patch-For-Review.Apr 1 2022, 12:24 PM
Daimona moved this task from Review/Feedback 💬 to Product sign-off 🤘 on the Connection-Team (Campaign-Tools-Sprint-9) board.
ifried closed this task as Resolved.Apr 1 2022, 4:21 PM
ifried moved this task from Product sign-off 🤘 to Done 🏁 on the Connection-Team (Campaign-Tools-Sprint-9) board.

Nothing user-facing to test, so I am marking this as done.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits