How to show value of 'Description' field of 'Knowledge Base' table as Field Message on 'Knowledge Base' (type:reference) field of Knowledge Article form.

[Jagbir Singh]

Hi All,

On the Knowledge Article form, when value of 'Knowledge Base' field (field type is reference, getting value from Knowledge Base Table) is changed. A field message should appear below this field, that should contain value of 'Description' field of Knowledge Base table. And a pop up alert should appear that has the value of 'Workflow Description' field (field type is text) of Knowledge Base table.

In other words, when:

     'Knowledge Base' field of Knowledge Article Table is CHANGED

Then:

     Field Msg on Knowledge Article form ==  'Description' field of Know. Base table.      AND

     Popup Alert == 'Workflow Description' field (type is text) of Knowledge Base table.

Kindly let me know how it can be achieved. Thanking u in advance.

[Harish KM]

Hi I am assuming you want to display Knowledge base description on article form field knowledge base  field and a pop of workflow description (field from knowledgebase) correct?

[Jagbir Singh]

I want to show knowledge base's Description as Field Message on Article form's field Knowledge Base. And regarding popup alert, you got it right.  

[Harish KM]

Hi You can write a script include and Onchange client script for field knowledge base on Knowledge table.

SCript Include:

getKnowledgeBase: function()
    {
    var kbBase = this.getParameter("sysparm_id"); // pass knowledgebase sysid
var kbDetails ={};
var gr = new GlideRecord("kb_knowledge_base");
gr.addQuery("sys_id", kbBase);
gr.query();
if (gr.next()){
kbDetails.description = gr.getValue("description");// get description field values from knowledge base
kbDetails.owner = gr.getValue("owner"); // get owner field values from knowledge base
}

var json = new JSON();
var result = json.encode(kbDetails);
return result.toString();    
        
    },

client script:

 var kBase = g_form.getValue('kb_knowledge_base');
    alert(kBase);
      var ga = new GlideAjax("userDepartment"); // script include name
        ga.addParam("sysparm_name", "getKnowledgeBase"); // SI function name
        ga.addParam("sysparm_id", kBase);
        ga.getXMLAnswer(response);
    }

function response(getResponse) {
    var answer = JSON.parse(getResponse);
    g_form.showFieldMsg('kb_knowledge_base',answer.description); //Knowledgebase description
   alert("workflow description"+answer.owner); // for pop up
  }

[Jagbir Singh]

Thank you so much Harish.