Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo
Im trying to use the Activity Control Report, but I failed…
Can someone explain to me how FinishDate works ?
I think that need to be the time that a Activity is completed, but in the code the time is a last movementDate.
But I dont know why.
private void setDateFinish(boolean override)
if (!DOCSTATUS_Completed.equals(getDocStatus()) && !DOCSTATUS_Closed.equals(getDocStatus()))
throw new IllegalStateException("Calling setDateFinish when the activity is not completed/closed is not allowed");
if (!override && getDateFinish() != null)
log.fine("DateFinish already set : Date="+getDateFinish()+", Override="+override);
final String sql = "SELECT MAX("+MPPCostCollector.COLUMNNAME_MovementDate+")"
+" FROM "+MPPCostCollector.Table_Name
+" WHERE "+MPPCostCollector.COLUMNNAME_PP_Order_Node_ID+"=?"
+" AND "+MPPCostCollector.COLUMNNAME_DocStatus+" IN (?,?,?)"
+" AND "+MPPCostCollector.COLUMNNAME_CostCollectorType+"=?"
Timestamp dateFinish = DB.getSQLValueTSEx(get_TrxName(), sql, get_ID(),
if (dateFinish == null)
log.warning("Activity Completed/Closed but no cost collectors found!");
Victor Perez Juarez
Can please give steps to replicate the issue, have you some error?
I'm trying to use the Activity Control window to do the follow up of production.
During production, the items go from one sector to another to create the finished product.
I believe the correct screen to inform the system what stage the production is, is this.
I tried to do the following:
- When entering the item in the sector A (1 Workflow node), I create a new record, informs the control activity and leaves the state of the document = "Prepare" ( In Progress)
- When leaving the item from the sector, informs again (update record) but this time with the state of the document = "Completed"
But, the system don’t take the final time that I believe is correct, its takes a start date of the last node, which is the entrance of the item.
I'm quite confused about the use of this screen, I do not found documentation of it, and I'm doing reverse engineering of the code to know if it meets my needs.
Thank you for your attention.
Any idea for the question?