Skip to main content
B
bson2112-Amethyst
12-Amethyst
May 27, 2019
Solved

With only node id, how can I get email address in user field on document belongs to ?

  • May 27, 2019
  • 1 reply
  • 2358 views

Hello

 

I would like to create trigger

in script I want to get email address in document's user field

trigger is triggered when node is changed, so I only know node id.

with this node id, I can get document's ID using API.

but I have a problem getting email address in user field on document.

 

below is my plan to getting user email address

(1)node(2nd level) ID -> (2)node(1st level) ID -> (3)document ID -> (4)user field list -> (5)user email address

I achieved only (3)

 

Thank you in advance

Best answer by awalsh

The previous script assumes that the node is being edited. If that's not the case, and you just have the ID, then you can get an Issue bean for the node ID rather than getting a delta bean:

 

// var nodeBean = bsf.lookupBean("imIssueDeltaBean");
var nodeBean = server.getIssueBean(1234,["Document ID"]);

where 1234 is the node ID.

 

1 reply

A
awalsh5-Regular Member
5-Regular Member
May 27, 2019

You will need to get an issueBean for the document to see the user field info, then a userBean for the user to get the email address.

 

Sample script that just looks up the user email and prints to the server.log file:

var eb = bsf.lookupBean("siEnvironmentBean");
eb.setMessageCategory("GENERAL");

var server = bsf.lookupBean("imServerBean");
var nodeBean = bsf.lookupBean("imIssueDeltaBean");
var userfield="Assigned User";

var docID=nodeBean.getDocumentID();
var docBean=server.getIssueBean(docID,[userfield]);
var username=docBean.getFieldValue(userfield);

if (username != null) {
var userBean=server.getUserBean(username);
var userEmail=userBean.getEmailAddress();
eb.print("The email address for " + username + " is " + userEmail);
} else {
eb.print("The user field " + userfield + " is empty on Document " + docID);
}

I ran this as a pre-trigger with the rule "Type=Requirement", and here's the server.log output for different values of the user field:

2019-05-27 11:35:27,586 INFO [mksis.IntegrityServer] GENERAL(5): awalsh[RMI Executor-thread-8]: Trigger "useremail.js" - The email address for awalsh is awalsh@test.com
2019-05-27 11:36:57,072 INFO [mksis.IntegrityServer] GENERAL(5): awalsh[RMI Executor-thread-3]: Trigger "useremail.js" - The email address for business_analyst is null
2019-05-27 11:38:53,074 INFO [mksis.IntegrityServer] GENERAL(5): awalsh[RMI Executor-thread-6]: Trigger "useremail.js" - The user field Assigned User is empty on Document 1382
    A
    awalsh5-Regular MemberAnswer
    5-Regular Member
    May 27, 2019

    The previous script assumes that the node is being edited. If that's not the case, and you just have the ID, then you can get an Issue bean for the node ID rather than getting a delta bean:

     

    // var nodeBean = bsf.lookupBean("imIssueDeltaBean");
    var nodeBean = server.getIssueBean(1234,["Document ID"]);

    where 1234 is the node ID.

     

      B
      bson2112-AmethystAuthor
      12-Amethyst
      June 2, 2019

      Thank very much

       

      your advice is very helpful for me Smiley Happy

      Terms & ConditionsAccessibility statement