Create New record (with code) after Workflow Submit

(0) Share

Report

Posted on by Community Member

Hello everyone, som i'm trying to create a new record in Planned answer Session after i submit my workflow i used these code but it doesn't work

  public void completed(WorkflowElementEventArgs _workflowElementEventArgs)
	{
		// TODO:  Write code to execute once the workflow is completed.
        RecId documentRecId = _workflowElementEventArgs.parmWorkflowContext().parmRecId();
        NouvelleMesureTable::updateWorkflowStatus(documentRecId, GD_WFDocumentStatus::Valide);
        FormControl sender;
        FormRun formRun;
        Args args = new Args();
        KMVirtualNetworkAnswerTable kMVirtualNetworkAnswerTable;
        NouvelleMesureTable nouvelleMesureTable;
        FormDataSource nouvelleMesureTable_ds  = sender.formRun().dataSource(formDataSourceStr(NouvelleMesureDisciplinaire,NouvelleMesureTable))as
            FormDataSource;
       
        
       
        ttsbegin;
        kMVirtualNetworkAnswerTable.ExecutedBy=nouvelleMesureTable.Person;
        kMVirtualNetworkAnswerTable.EvaluationOf=nouvelleMesureTable.Person;
        kMVirtualNetworkAnswerTable.kmCollectionId=nouvelleMesureTable.Questionnaire;

        ttscommit;

        args.name(formStr(NouvelleMesureDisciplinaire));
        formRun = classFactory.formRunClass(args);
        formRun.init();
        formRun.run();
	}

thank you.

All responses (33)

Answers (0)

Sort by

Suggested answer

Komi Siabi 13,253 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Bonjour wassim77,

Your code seems a bit confusing with ttsbegin while you are trying to insert a record and no insert() method anywhere.

If I get you right, you want to pick record from your custom table and insert it into kMVirtualNetworkAnswerTable when the current document is fully approved.

A better way, I would achieve this is by having a method createkMVirtualNetworkAnswerTable() on NouvelleMesureTable where I will define the fields and mapping for insertion.

On the workflowEventHandler, I would just call the insertIntokMVirtualNetworkAnswerTable and pass the documentId.

///
/// ///
public void createkMVirtualNetworkAnswerTable(RecId _recId) { kMVirtualNetworkAnswerTable kMVirtualNetworkAnswerTable; NouvelleMesureTable nouvelleMesureTable = NouvelleMesureTable::find(_recId); kMVirtualNetworkAnswerTable.clear(); kMVirtualNetworkAnswerTable.ExecutedBy=nouvelleMesureTable.Person; kMVirtualNetworkAnswerTable.EvaluationOf=nouvelleMesureTable.Person; kMVirtualNetworkAnswerTable.kmCollectionId=nouvelleMesureTable.Questionnaire; ....... ....... kMVirtualNetworkAnswerTable.insert(); }

public void completed(WorkflowElementEventArgs _workflowElementEventArgs) { // TODO: Write code to execute once the workflow is completed. RecId documentRecId = _workflowElementEventArgs.parmWorkflowContext().parmRecId(); NouvelleMesureTable::updateWorkflowStatus(documentRecId, GD_WFDocumentStatus::Valide); // Here we call the method for inserting record into KMVirtualNetworkAnswerTable NouvelleMesureTable.createkMVirtualNetworkAnswerTable(documentRecId); }
Suggested answer

GirishS 27,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi wassim77,

You are saying that you need to create a record in table after submission, But you have added the code in completed event handler. Completed event handler will be called once workflow is completed.

You need to write the logic in the started event handler which will be called once you submit the workflow.

Thanks,

Girish S.
Community Member on at

Like (0)

Report
Copy link

Link copied!

thank you sir but i'm these error

"Cannot create a record in Plan a questionnaire (KMVirtualNetworkAnswerTable). The record already exists."

when i try to submit
GirishS 27,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

This error is throwing because you have unique index on a table. You need to validate the record before inserting.

If KMColectionId is unique index field in the table, then you need to add select statement to check whether the KMCollectionId is already there in the table.

Thanks,

Girish S.
Community Member on at

Like (0)

Report
Copy link

Link copied!

how do i do that?
GirishS 27,845 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you tell me the unique index on the KMVirtualNetworkAnswerTable table?

Thanks,

Girish S.
Community Member on at

Like (0)

Report
Copy link

Link copied!

okey so the index for the table is IdIdx and the Allow Duplicate is set to No
GirishS 27,845 Moderator on at

Like (1)

Report
Copy link

Link copied!

No IdIdx is index name. You need to expand that and see what are all the fields added inside.

Thanks,

Girish S.
Suggested answer

Komi Siabi 13,253 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello wassim77,

Here is what Girish is talking about.

Before inserting, you need to check if the record exist.

select firstonly kMVirtualNetworkAnswerTable where kMVirtualNetworkAnswerTable.kmVirtualNetworkAnswerTableId ="" if(!kMVirtualNetworkAnswerTable.RecId) { //insert here }
Community Member on at

Like (0)

Report
Copy link

Link copied!

i'm getting an error (join expected)