How to get Comment value

Hello Guys,

I am try get Comment value on post,pre and Server . but I am getting null value . code is below .

Can you suggest me ? How can i do it?

/*ND Add Comment On AVL ECR From Activity Assignment*/
Innovator inn=this.getInnovator();
string activityId = this.getID();
Aras.Server.Security.Identity roleIden = Aras.Server.Security.Identity.GetByName("Innovator Admin");
bool SetPermission = Aras.Server.Security.Permissions.GrantIdentity(roleIden);
try
{

Item WorkflowProcessActivity=inn.newItem();
WorkflowProcessActivity.loadAML("<Item type='Workflow Process Activity' action='get' select='id,related_id,source_id'>"+
"<related_id condition='eq'>"+activityId+"</related_id>"+
"</Item>"
);
Item WorkflowProcessActivityR=WorkflowProcessActivity.apply();
int WorkflowProcessActivityCount=WorkflowProcessActivityR.getItemCount();
if(WorkflowProcessActivityCount==1)
{
String state="Active" ;
String WorkflowProcessID=WorkflowProcessActivityR.getProperty("source_id");
Item WorkflowProcess=inn.newItem();
WorkflowProcess.loadAML("<Item type='Workflow Process' action='get' select='id,name,state'>"+
"<id condition='eq'>"+WorkflowProcessID+"</id>"+
"<state condition='eq'>"+state+"</state>"+
"</Item>"
);

Item WorkflowProcessR=WorkflowProcess.apply();
int WorkflowProcessCount=WorkflowProcessR.getItemCount();
if(WorkflowProcessCount==1)
{
String AVLNO=WorkflowProcessR.getProperty("name");
Item AVLECR=inn.newItem();
AVLECR.loadAML("<Item type='ND Part AVL ECRs' action='get' select='id,nd_design_reviewer,nd_avl_ecr_no'>"+
"<nd_avl_ecr_no condition='eq'>"+AVLNO+"</nd_avl_ecr_no>"+
"</Item>"
);
Item AVLECRR=AVLECR.apply();
int AVLECRRCount=AVLECRR.getItemCount();
if(AVLECRRCount==1)
{

Item ActivityAssignment=inn.newItem();
ActivityAssignment.loadAML("<Item type='Activity Assignment' action='get' select='id,related_id,source_id,comments'>"+
"<source_id condition='eq'>"+activityId+"</source_id>"+
"</Item>"
);
Item ActivityAssignmentR=ActivityAssignment.apply();
int ActivityAssignmentCount=ActivityAssignmentR.getItemCount();
//return inn.newError("ActivityAssignmentCount "+ActivityAssignmentCount);
if(ActivityAssignmentCount==1)
{
string Activitycomments=ActivityAssignmentR.getProperty("comments");
return inn.newError("Activitycomments "+Activitycomments);
Item AVLECRs=inn.newItem("ND Part AVL ECRs","edit");
AVLECRs.setAttribute("slect","id,nd_design_reviewer,nd_avl_ecr_no,nd_reviewer_comments");
AVLECRs.setID(AVLECRR.getID());
AVLECRs.setProperty("nd_reviewer_comments",Activitycomments);
AVLECRs.apply();
//AVLECRR



}

}

}
}
}
finally{
if (SetPermission ==true) {
Aras.Server.Security.Permissions.RevokeIdentity(roleIden);
}
}
return this;

Regards

Ashok Kumar Yadav

Parents
  • Hi Ashok

    I attached below method in Pre Event of workflow transition and able to get the comment provided by user. Changes to be done are highlighted below

    Innovator inn = this.getInnovator();
    Aras.Server.Security.Identity plmIdentity = Aras.Server.Security.Identity.GetByName("Super User");
    bool permissionWasSet = false;
    try
    {
    permissionWasSet = Aras.Server.Security.Permissions.GrantIdentity(plmIdentity);
    Item wf = inn.newItem ("Workflow","get");
    Item wfp = inn.newItem("Workflow Process","get");
    Item wfpa = inn.newItem("Workflow Process Activity","get");
    Item act = inn.newItem("Activity","get");
    act.setID(this.getID());
    wf.setRelatedItem(wfp);
    wfp.addRelationship(wfpa);
    wfpa.setRelatedItem(act);
    wf = wf.apply();
    if( 1 != wf.getItemCount())
    {
    wf = wf.getItemByIndex(0);
    }
    Item parentItem = this.newItem("ItemTypeName", "get");
    parentItem.setID(wf.getProperty("source_id"));
    parentItem = parentItem.apply();

    string userID = inn.getUserID();
    Item workflow = inn.newItem("Workflow", "get");
    workflow.setProperty("source_id",parentItem.getID());
    Item workflowProcess = inn.newItem("Workflow Process", "get");
    Item workflowProcessActivity = inn.newItem("Workflow Process Activity", "get");
    Item activity = inn.newItem("Activity", "get");
    activity.setProperty("closed_by","");
    activity.setPropertyCondition("closed_by","is not null");
    Item activityAssign = inn.newItem("Activity Assignment", "get");
    activityAssign.setProperty("closed_by",userID);
    activity.addRelationship(activityAssign);
    workflowProcessActivity.setRelatedItem(activity);
    workflowProcess.addRelationship(workflowProcessActivity);
    workflow.setRelatedItem(workflowProcess);
    workflow = workflow.apply();

    Item activityAssignment = workflow.getItemsByXPath("//Item[@type='Activity Assignment']");
    if( activityAssignment.getItemCount() == 0 )
    {
    return inn.newError("No Closed Activity");
    }
    string comments = activityAssignment.getItemByIndex(0).getProperty("comments");
    return inn.newError(comments);  //Can be removed. Added for testing Purpose
    return this;
    }
    catch(Exception ex)
    {
    return inn.newError(ex.Message);
    }
    finally
    {
    if(permissionWasSet)
    {
    Aras.Server.Security.Permissions.RevokeIdentity(plmIdentity);
    }
    }

    Thank You

    Gopikrishnan R

  • 0 オフライン in reply to Gopikrishnan

    Hi Gopikrishnanm,

    If form has been revised and saved when signing, it will get null value. Could you suggest more? Thank you.

Reply Children
No Data