How to populate Array values in new line

Sironi · ‎07-19-2022

Hi all,

Some one please help me how to show values in new line and Story number should be clickable .

Expecting result :

RLSE0010000 Test Release 07/18_01 for 2022-12-31 16:26:00

STRY00001: Test Story 1.0 for 07/18_1 Release
Release Notes : Release Note for story Test Story 1.0 for 07/18_1 Release ( story release notes )

STRY00002: Test Story 2.0 for 07/18_1 Release
Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release ( story release notes )

I m getting result wrong

RLSE0010000 Test Release 07/18_01 for 2022-12-31 16:26:00 STRY00001: Test Story 1.0 for 07/18_1 Release Release Notes :

Release Note for story Test Story 1.0 for 07/18_1 Release 

STRY00002: Test Story 2.0 for 07/18_1 Release Release Notes :

Release note for story Test Story 2.0 for 07/18_1 Release

var ReleaseKnowledgeArticle = Class.create();
ReleaseKnowledgeArticle.prototype = {
    initialize: function() {},

    CheckStory: function() {
        var arr = [];
        arr.push(current.release.number.toString() + " " + current.release.short_description.toString());

        var results = '';
        var story = new GlideRecord('rm_story');
        story.addQuery('release', current.release);
        story.addEncodedQuery("state=3");
        story.query();
        while (story.next()) {
            arr.push(story.number + ": " + story.short_description);
            arr.push("Release Notes : " + story.u_release_notes.toString());
            results = arr.join("\n");
        }

        var kb = new GlideRecord('kb_knowledge');
        kb.addQuery('source', current.release);
        kb.query();
        if (kb.next()) {
            this._UpdateKB(results);
        }
    },

    _UpdateKB: function(results) {
        var art = new GlideRecord("kb_knowledge");
        art.addQuery("source", current.release);
        art.query();
        if (art.next()) {
            art.text = results;
            art.update();
        }
    },
    type: 'ReleaseKnowledgeArticle'
};

Expecting result :

RLSE0010000 Test Release 07/18_01 for 2022-12-31 16:26:00

STRY00001: Test Story 1.0 for 07/18_1 Release
Release Notes : Release Note for story Test Story 1.0 for 07/18_1 Release

STRY00002: Test Story 2.0 for 07/18_1 Release
Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release

I m not sure why it was not showing in new line.

Harish KM · ‎07-19-2022

Hi i tested your script include in background script it displays output like this , so guess this is what your looking?

*** Script: 
STRY0010058: Update Inbound Action for Benefits@avnet.com
Release Notes : Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release
STRY0010021: HR KM - User criteria  - Employees by Hourly
Release Notes : Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release
STRY0010070: Secure HR Tasks by HR Region + Germany
Release Notes : 
STRY0010074: Update HR Group Members
Release Notes : 
STRY0010064: Limit Access to the HR Request Menu link
Release Notes : 
STRY0010011: HR KM - User criteria  - Employee Type
Release Notes : Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release

Regards
Harish

Sironi · ‎07-19-2022

Yes, what is the result you got that was the result I want ... Not sure why my side in KB article body result showing like below.

RLSE0010014YR Test Release 07/18_01 for 2022-12-31 16:26:00 STRY0027011: YR Test Story 1.0 for 07/18_1 Release Release Notes :

Release Note for story YR Test Story 1.0 for 07/18_1 Release

STRY0027012: YR Test Story 2.0 for 07/18_1 Release Release Notes :

Release note for story YR Test Story 2.0 for 07/18_1 Release

Expecting result :

RLSE0010000 Test Release 07/18_01 for 2022-12-31 16:26:00

STRY00001: Test Story 1.0 for 07/18_1 Release
Release Notes : Release Note for story Test Story 1.0 for 07/18_1 Release

STRY00002: Test Story 2.0 for 07/18_1 Release
Release Notes : Release note for story Test Story 2.0 for 07/18_1 Release

Harish KM · ‎07-19-2022

Try this way

var arr = [];

var results = '';
var story = new GlideRecord('rm_story');
story.addQuery('release', '21e4b576db50001025c85a35dc9619d1');
//story.addEncodedQuery("state=3");
story.query();
while (story.next()) {
arr.push(story.number + ": " + story.short_description);
arr.push("Release Notes : " + story.u_release_notes.toString());

}
results = arr.join("\n"); // print this outside while
gs.info(results);

Regards
Harish

Harish KM · ‎07-19-2022

That's because your setting the array values in HTML editor. You need to use tag for new line. Refer attached screenshot

var arr = [];

var results = '';
var story = new GlideRecord('rm_story');
story.addQuery('release', '21e4b576db50001025c85a35dc9619d1');
//story.addEncodedQuery("state=3");
story.query();
while (story.next()) {
arr.push(story.number + ": " + story.short_description +" "); // add br tag to your array
arr.push("Release Notes : " + story.u_release_notes.toString()+" ");

}
results = arr.join("\n");
story.acceptance_criteria = results;
story.update();
gs.info(results);

Regards
Harish

Sironi · ‎07-19-2022

Background:

var gg= new GlideRecord('rm_story');
if(gg.get('19c20b8ddb7c9d10a7e1f592ba9619a0')){
var arr = [];
arr.push(gg.release.number + gg.release.short_description.toString() + " for " + gg.release.end_date);

var results = '';
var story = new GlideRecord('rm_story');
story.addQuery('release', gg.release);
story.addEncodedQuery("state=3");
story.query();
while (story.next()) {
arr.push(story.number + ": " + story.short_description.toString()+" ");
arr.push("Release Notes : " + story.u_release_notes.toString()+" ");
}

results = arr.join("\n");
gs.print(results);
}

result :

*** Script: RLSE0010014YR Test Release 07/18_01 for 2022-12-31 16:26:00
STRY0027011: YR Test Story 1.0 for 07/18_1 Release  <br>
Release Notes : <p>Release Note for story <strong>YR Test Story</strong> 1.0 for 07/18_1 Release </p> <br>
STRY0027012: YR Test Story 2.0 for 07/18_1 Release  <br>
Release Notes : <p>Release note for story YR Test Story 2.0 for 07/18_1 Release </p> <br>