'Overview' section: pending draft content does not display
Description
The overview section does not update correctly due to a mismatched SQL statement. The fix is described below, along with a reference to the group discussion on google.
On lines 71-76 of the file /core/packages/farcry/_workflow/getObjectsPendingApproval.cfm,
There are two statements that create the same output table from different SQL settings. You'll notice that not all the columns are in the same order. Specifically, createdby and lastupdatedby are switched in the second. What I did was switch those and I believe that is all I had to do to make things work for me. Now, this was for FC5.0, but I don't think this specific code changed between 4 and 5.
The overview section does not update correctly due to a mismatched SQL statement. The fix is described below, along with a reference to the group discussion on google.
On lines 71-76 of the file /core/packages/farcry/_workflow/getObjectsPendingApproval.cfm,
There are two statements that create the same output table from different SQL settings. You'll notice that not all the columns are in the same order. Specifically, createdby and lastupdatedby are switched in the second. What I did was switch those and I believe that is all I had to do to make things work for me. Now, this was for FC5.0, but I don't think this specific code changed between 4 and 5.
http://groups.google.com/group/farcry-dev/browse_thread/thread/ba12a44490ea469f