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 you can test with tag. I tested and works fine for HTML fields

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);
}
},

Regards
Harish

Sironi · ‎07-19-2022

Hi,

tag already added in code and tested. but no difference. kindly see result.

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>

Sironi · ‎07-19-2022

here "u_release_notes" is HTML type field on story form.

kindly check last screenshot which is result one

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 + "<br>");
            arr.push("Release Notes : " + story.u_release_notes.toString() + "<br>");
            results = arr.join("\n");
        }

        var kb = new GlideRecord('kb_knowledge');
        kb.addQuery('source', current.release);
        kb.query();
        if (!kb.next()) {
            this._CreateKB();
        } else {
            this._UpdateKB(results);
        }
    },
    _CreateKB: function() {
        var kb = new GlideRecord("kb_knowledge");
        kb.initialize();
        kb.source = current.release;
        kb.short_description = current.release;
        kb.insert();
    },

    _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 '
};

Sironi · ‎07-19-2022

Tq.

please help me how can we make story number clickable

Harish KM · ‎07-19-2022

Hi you can do something like this

var arr = [];
var link ;
var results = '';
var story = new GlideRecord('rm_story');
story.addQuery('release', '21e4b576db50001025c85a35dc9619d1');
//story.addEncodedQuery("state=3");
story.query();
while (story.next()) {
link = '<a href="/rm_story.do?sys_id="+story.sys_id + target="_blank" >Story</a>';

arr.push("Story Number:"+link + ": " + story.short_description +" ");
arr.push("Release Notes : " + story.u_release_notes.toString()+" ");

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

Regards
Harish