Overview
Scrum Management allows scrum teams to manage and conduct scrum ceremonies all within Appian, allowing Scrum Masters and Team Members alike to facilitate processes to ensure successful sprints and delivery.
Key Features & Functionality
For Scrum Masters:
For Team Members:
Thanks for the congrats gonzalog, while we cannot attach documentation here, I'm happy to send to your email if you could provide it.
In the mean-time, while the tables can be created directly from Appian using the OOTB save&publish feature, you are correct that it would be nice to have the view context available so I am commenting that here:
Announcements_Projects
select concat(`tm`.`userid`,`an`.`description`) AS `id`,`tm`.`id` AS `team_member_id`,`tm`.`userid` AS `team_member_user_id`,`tm`.`projectid` AS `project_id`,`pr`.`name` AS `project_name`,`pr`.`active` AS `active_status`,`an`.`id` AS `announcement_id`,`an`.`description` AS `announcement_description` from ((`Appian`.`ksscteammember` `tm` join `Appian`.`ksscproject` `pr` on((`tm`.`projectid` = `pr`.`id`))) join `Appian`.`ksscannouncements` `an` on((`pr`.`id` = `an`.`projectid`)))
Attendance_DailyScrums
select `at`.`id` AS `attendance_id`,`at`.`attended` AS `attended_flag`,`tm`.`userid` AS `teammember_username`,`ds`.`id` AS `daily_scrum_id`,`ds`.`scrummaster` AS `scrummaster`,`ds`.`startdatetime` AS `startdatetime`,`ds`.`enddatetime` AS `enddatetime`,`pr`.`id` AS `project_id`,`pr`.`name` AS `project_name`,`ac`.`previousdaydescription` AS `previous_activities`,`ac`.`currentdaydescription` AS `current_activities` from ((((`Appian`.`ksscattendance` `at` join `Appian`.`ksscteammember` `tm` on((`at`.`teammemberid` = `tm`.`id`))) join `Appian`.`ksscproject` `pr` on((`tm`.`projectid` = `pr`.`id`))) left join `Appian`.`ksscdailyscrumactivities` `ac` on((`at`.`id` = `ac`.`attendanceid`))) join `Appian`.`ksscdailyscrummeeting` `ds` on((`at`.`meetingid` = `ds`.`id`)))
Impediments_Projects
select `im`.`id` AS `impediment_id`,`im`.`reporterteammemberid` AS `reporter_teammember_id`,`tm`.`userid` AS `reporter_username`,`im`.`ownerteammemberid` AS `owner_teammember_id`,`tm2`.`userid` AS `owner_username`,`im`.`description` AS `description`,`im`.`reporteddate` AS `reported_date`,`im`.`status` AS `status`,`im`.`actiontaken` AS `action_taken`,`im`.`result` AS `result`,`im`.`closeddate` AS `date_closed`,`pr`.`id` AS `project_id`,`pr`.`name` AS `project_name` from (((`Appian`.`ksscimpediments` `im` join `Appian`.`ksscteammember` `tm` on((`im`.`reporterteammemberid` = `tm`.`id`))) left join `Appian`.`ksscteammember` `tm2` on((`im`.`ownerteammemberid` = `tm2`.`id`))) join `Appian`.`ksscproject` `pr` on((`tm`.`projectid` = `pr`.`id`)))
TeamMembers_Projects
select `tm`.`id` AS `teammember_id`,`tm`.`userid` AS `teammember_userid`,`pr`.`id` AS `project_id`,`pr`.`name` AS `project_name`,`pr`.`updatedby` AS `project_updatedby`,`pr`.`updateddatetime` AS `project_updated`,`pr`.`active` AS `project_active` from (`Appian`.`ksscteammember` `tm` join `Appian`.`ksscproject` `pr` on((`tm`.`projectid` = `pr`.`id`)))