You might want to think about whether there is a required publication date.
For example, if a story is entered, but is embargoed until next week, you might want to store that publication date and it won't show up on the site until that date arrives. H. > -----Original Message----- > From: Ian Vaughan [SMTP:[EMAIL PROTECTED] > Sent: Monday, March 03, 2003 3:54 AM > To: CF-Talk > Subject: Re: Is it possible to achieve workflow in Coldfusion ??? > > Andre > > Thanks for the explanation!! > > Ok I understand how it is working - > > A user fills in the fields and clicks submit the data in entered into the > db > with a 'status' field set to a default of 'Pending' > > Ok > > Then when the form is submitted I use CFMail to send an e-mail to the > approver informing them they have a story to approve. (Is this process > correct ?) > > The approver clicks on the link in the e-mail and they are taken to the > 'Pending Jobs' Screen. > > The approver opens the relevant pending job. > > At the bottom of this page there are two buttons 'Approve' and 'Decline' > > If the aprrover clicks approve the 'status' field changes to 'approve' > > However if the approver clicks decline then the 'status' field stays the > same and an e-mail is sent back to the content owner informing them that > the > content has been declined. > > Does this make sense logically ?? > > Or would you add more features and or more advanced settings?? > > > ----- Original Message ----- > From: "Andre Mohamed" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, March 03, 2003 11:24 AM > Subject: RE: Is it possible to achieve workflow in Coldfusion ??? > > > > Ian, > > > > Perhaps I can clarify/expand on what Adam suggested: > > > > 1) You do not stop the data entering the database when a story is > > submitted. Instead, it is inserted as normal but you also set another > > column probably in the same table, perhaps named "status" with a value > > of "P" for pending when you perform the insert e.g. > > > > insert into stories > > (story_id, foo, bar, status) > > values > > (666,'Foo','Bar','P') > > > > 2) Only display "stories" on the website if the "status" column is not > > "P", perhaps only if the status column is "A" for approved e.g. > > > > select foo, bar > > from stories > > where status = 'A' > > > > 3) When the approver approves a story to be published, the appropriate > > row in the database gets "updated" and the status column is changed > > appropriately. > > > > e.g. > > > > update stories > > set status = 'A' > > where story_id = 666 > > > > > > You could extend this model quite simply to allow for multi-level > > approvals and multiple types of status. > > > > It's important to note that this is not a ColdFusion specific problem. > > It is merely a programming issue and there is more than one way to skin > > a cat. > > > > Thanks, > > > > André > > > > > > -----Original Message----- > > From: Ian Vaughan [mailto:[EMAIL PROTECTED] > > Sent: 03 March 2003 11:02 > > To: CF-Talk > > Subject: Re: Is it possible to achieve workflow in Coldfusion ??? > > > > Adam > > > > There is only one administrator or approver. > > > > How would you achieve this, do you have example code so I can see how it > > may > > function, how do you stop the data entering the database ?? > > > > "As part of the submit page, have it save the document away with a flag > > 'pending'." > > > > > > > > > > ----- Original Message ----- > > From: "Adam Reynolds" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, March 03, 2003 9:46 AM > > Subject: RE: Is it possible to achieve workflow in Coldfusion ??? > > > > > > > Ian, > > > This is relatively simple. As part of the submit page, have it save > > the > > > document away with a flag 'pending'. > > > > > > Is there just one administrator? Do you want different admin for > > different > > > areas of the site? That is the real pain. > > > > > > You could have a pending approval page that admin can go to to see any > > > pending pages. They could then view (AND edit) those pages before > > accepting > > > the content or rejecting the comment. > > > > > > Adam > > > > > > > -----Original Message----- > > > > From: Ian Vaughan [mailto:[EMAIL PROTECTED] > > > > Sent: 03 March 2003 09:38 > > > > To: CF-Talk > > > > Subject: Is it possible to achieve workflow in Coldfusion ??? > > > > > > > > > > > > Hi > > > > > > > > I am trying to add a workflow element into a news application, and > > would > > > > just like to hear if anybody else on the list have been able to > > achieve > > > > this? or best practices on how to achieve this? > > > > > > > > I have an admin form that allows users to add news stories. At > > > > present when > > > > the form is submitted the data is entered into the database table. > > > > > > > > What I would like to achieve is when the user submits the form an > > > > e-mail is > > > > sent to the relevant approver. They view their e-mail and click > > > > on the link > > > > which opens up their admin screen. > > > > > > > > >From here they can see they have content to approve. The approver > > reads > > > > through the story and if they are happy they approve the data and it > > is > > > > entered into the database and goes live on the site. > > > > > > > > If the approver declines the story it sends the user who created > > > > the content > > > > an e-mail with why the data was not approved and the changes needed > > to > > be > > > > made, and the story does not go live on the site. > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4