Populate article number in kb_feedback_task table

[bhavana2]

Hi All,

There is a catalog item called "submit feedback" in which if user submits this form it will create an feedback task record in kb_feedback_task table.  Once it is submitted i have to map the article number field to the Article field in feedback task table.  But is not mapping correctly and coming empty. Apart from that i am able to map the author, desc and other fields.

I am using "current.article= producer.article_number;"   // inorder to map the "Article" field 

 since it is reference field i used  "current.feedback.article= producer.article_number;"

 But still it is not working. Can i know where i am doing wrong?

 Please let me know as it urgent requirement.  Early responses are highly appreciated

Thanks,

 Deepa

[shloke04]

@bhavna 

Not an issue, will help to debug and get you to a solution here.

Can you share the version of code which you have updated? Also can you let me know what is the variable type for Article number on your form?

If it is a reference to which table it is referring to?

Regards,

Shloke

[bhavana2]

Hi Shloke,

var getNumber = producer.knowledge_article_number; // Article Number Variable here

var createdFeedbackFirst = updateKBFeedback(getNumber);

if(createdFeedbackFirst){
current.article = createdFeedbackFirst; // This will update the Article field
}

function updateKBFeedback(getNumber){
var gr = new GlideRecord('kb_feedback');
gr.initialize();
gr.article = getNumber;
var succ = gr.insert();
if(succ){
return gr.sys_id;
}
}

The knowledge article number field is Reference to  kb_knowledge table.

Can i know why it is not mapping still

[Ravi9 · Accepted solution]

what is ur target table in rec prod ?

is it kb_feedback_task

then change the current.article = createdFeedbackFirst; TO

current.feedback = createdFeedbackFirst;

also ur code can be much simpler as well , something like below

var getNumber = producer.knowledge_article_number; // Article Number Variable here

current.feedback = createdFeedback(getNumber);

function createdFeedback(sys_id) {
  var gr = new GlideRecord("kb_feedback");
  gr.initialize();
  gr.article = sys_id;
  return gr.insert();
}

let me know

[bhavana2]

Hi Ravi,

ya it was kb_feedback_task table and the solution is working fine

Thank you so much for your help

[Ravi9]

cool , cheers!