Based on David's suggestion for not introducing the WorkEffortHistory entity. Instead we introduced new field "statusChangeNote" in WorkEffort entity and maintained its history in "reason" field of WorkEffortStatus entity. Thanks David.
-- Ashish On Fri, Jun 27, 2008 at 7:26 AM, <[EMAIL PROTECTED]> wrote: > Author: ashish > Date: Fri Jun 27 04:26:45 2008 > New Revision: 672246 > > URL: http://svn.apache.org/viewvc?rev=672246&view=rev > Log: > Introducing new field "statusChangeNote" in the WorkEffortEntity. > Maintaining its value in the WorkEffortStatus table as well. > Sometime it happens that we would like like to save the status change > reason of keeping the Project (aka WorkEffort) into either HOLD or CANCEL > state. > > Thanks Ratnesh for discussing this with me. > > > Modified: > ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml > > > ofbiz/trunk/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml > ofbiz/trunk/applications/workeffort/widget/WorkEffortForms.xml > > Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml > URL: > http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=672246&r1=672245&r2=672246&view=diff > > ============================================================================== > --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml > (original) > +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Fri Jun > 27 04:26:45 2008 > @@ -245,6 +245,7 @@ > <field name="showAsEnumId" type="id"></field> > <field name="sendNotificationEmail" type="indicator"></field> > <field name="description" type="description"></field> > + <field name="statusChangeNote" type="description"></field> > <field name="locationDesc" type="description"></field> > <field name="estimatedStartDate" type="date-time"></field> > <field name="estimatedCompletionDate" type="date-time"></field> > @@ -800,6 +801,7 @@ > <field name="statusId" type="id-ne"></field> > <field name="statusDatetime" type="date-time"></field> > <field name="setByUserLogin" type="id-vlong"></field> > + <field name="reason" type="description"></field> > <prim-key field="workEffortId"/> > <prim-key field="statusId"/> > <prim-key field="statusDatetime"/> > > Modified: > ofbiz/trunk/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml > URL: > http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml?rev=672246&r1=672245&r2=672246&view=diff > > ============================================================================== > --- > ofbiz/trunk/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml > (original) > +++ > ofbiz/trunk/applications/workeffort/script/org/ofbiz/workeffort/workeffort/WorkEffortSimpleServices.xml > Fri Jun 27 04:26:45 2008 > @@ -115,6 +115,7 @@ > <set from-field="lookedUpValue.workEffortId" > field="newWorkEffortStatus.workEffortId"/> > <set from-field="parameters.currentStatusId" > field="newWorkEffortStatus.statusId"/> > <set from-field="nowTimestamp" > field="newWorkEffortStatus.statusDatetime"/> > + <set from-field="lookedUpValue.statusChangeNote" > field="newWorkEffortStatus.reason"/> > <set from-field="userLogin.userLoginId" > field="newWorkEffortStatus.setByUserLogin"/> > <create-value value-name="newWorkEffortStatus"/> > </then> > > Modified: ofbiz/trunk/applications/workeffort/widget/WorkEffortForms.xml > URL: > http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/widget/WorkEffortForms.xml?rev=672246&r1=672245&r2=672246&view=diff > > ============================================================================== > --- ofbiz/trunk/applications/workeffort/widget/WorkEffortForms.xml > (original) > +++ ofbiz/trunk/applications/workeffort/widget/WorkEffortForms.xml Fri Jun > 27 04:26:45 2008 > @@ -91,6 +91,8 @@ > </field> > <field name="percentComplete" position="2"/> > > + <field name="statusChangeNote" > use-when="workEffort==null"><ignored/></field> > + > <field name="priority" position="1"> > <drop-down allow-empty="true"> > <option key="1" description="1 > (${uiLabelMap.WorkEffortPriorityHigh})"/><option key="2"/><option > key="3"/><option key="4"/><option key="5"/> > @@ -164,6 +166,7 @@ > <sort-field name="workEffortPurposeTypeId"/> > <sort-field name="currentStatusId"/> > <sort-field name="percentComplete"/> > + <sort-field name="statusChangeNote"/> > <sort-field name="priority"/> > <sort-field name="scopeEnumId"/> > <sort-field name="estimatedStartDate"/> > > >
