Ian, I see no flaws the logic you outlined; seems perfectly acceptable to me. As for adding more features and or more advanced settings, that is entirely dependent on whether they are justified, required or are likely to be required - something which only you are in a position to judge at present. If what you outlined is all that you need then I see no reason to expand.
It is conceivable, as in other workflow systems, that you may in the future need more than one level of approval i.e. the article/story may go through a whole chain of people before it is finally ready to be published e.g. author -> editor -> creative/formatting -> publisher etc. however, I don't know if that is appropriate for your circumstances but it might be worth bearing in mind. Hope you are successful in your endeavors. Thanks, André -----Original Message----- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 11:54 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4