On 2/26/2010 2:01 PM, Sven Klemm wrote:
Hi,
Dan Langille wrote:
On 2/24/2010 8:52 PM, Dan Langille wrote:
I'm at pentabarf/mail using the 'All accepted speakers of this
conference'. I see 6 speakers.
However, event/state/accepted shows 42 events accepted.
I can see no differences the events/speakers not included.
For example, a speaker missing from the list:
- event role: speaker
- role state: confirmed
- event state: accepted
- progress: reconfirmed
What's up?
luser error. reconfirmed != confirmed.
probably not
Is the work flow for these various states documented?
the workflow for accepted events is
unconfirmed> confirmed> reconfirmed
reconfirmed is the final state making the event appear in the schedule
export. So included only speakers of confirmed events is clearly a
bug. Reconfirmed has been added recently and this function has not
been adjusted to this change. I should change this function to either
include only speakers of reconfirmed events, speakers of reconfirmed
and confirmed or events or all accepted events no matter their substate.
Please find attached a patch which fixes this for me.
--
Dan Langille - http://langille.org/
diff --git a/sql/views/mail/mail_accepted_speaker.sql
b/sql/views/mail/mail_accepted_speaker.sql
index 49b742a..5c553a3 100644
--- a/sql/views/mail/mail_accepted_speaker.sql
+++ b/sql/views/mail/mail_accepted_speaker.sql
@@ -21,7 +21,7 @@ CREATE OR REPLACE VIEW view_mail_accepted_speaker AS
conference.conference_id = event.conference_id )
WHERE
event.event_state = 'accepted' AND
- event.event_state_progress = 'confirmed' AND
+ event.event_state_progress IN ('confirmed', 'reconfirmed') AND
event_person.event_role IN ('speaker', 'moderator') AND
event_person.event_role_state = 'confirmed'
ORDER BY view_person.person_id, event.event_id
_______________________________________________
pentabarf mailing list
pentabarf@mail.skyhub.de
https://mail.skyhub.de/cgi-bin/mailman/listinfo/pentabarf
