[farcry-dev] RE: getUserDraftObjects.cfm

[Andrew Mercer]

Maybe this should be the SQL SELECT objectID, title, versionID, datetimelastUpdated FROM dmHTML WHERE status = 'draft' AND (rtrim(versionID) = '' AND createdby = 'fred')  OR (rtrim(versionID) != '' and lastupdatedby = 'fred') ORDER BY datetimelastUpdated DESC   But I think this will only work when there is another version of the object..?   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Mercer Sent: Thursday, 27 May 2004 15:12 PM To: FarCry Developers Subject: [farcry-dev] getUserDraftObjects.cfm   My clients have discovered that if a page is requested for approval, and then sent back to draft, it does not show up for the content persons ‘myFarCry’ home page.   I think I have tracked it down to farcry_core\packages\farcry\_workflow\getUserDraftObjects.cfm                         <cfset sql = "SELECT objectID, title, versionID, datetimelastUpdated FROM #application.dbowner##i# WHERE status = 'draft' AND rtrim(versionID) = '' AND (createdby = '#arguments.userLogin#' OR lastupdatedby = '#arguments.userLogin#') ORDER BY datetimelastUpdated DESC">   I think the problem is that versionID is not blank when testing for lastupdatedby.   I would also be inclined to put parentheses are the things that are been ORed.   Regards, Andrew Mercer Senior Developer Power Business Systems 18-20 Piccadilly Square 7 Aberdeen Street Perth WA 6000 T: +61 8 9221 1182 F: +61 8 9325 5198 E: [EMAIL PROTECTED] W: www.power.net.au     < Please speak to Power Business Systems, Your Business Objects Partner, Today.   CAUTION - This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that any use, dissemination, distribution or reproduction of this message is prohibited. If you have received this message in error please notify Power Business Systems immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Power Business Systems.     --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004

<<image002.jpg>>