Hey SN Comm,
I am looking for some help implementing a conversation through VA Chatbot, to be able to resolve HR Cases.
I have taking the 'Resolve Incident' flow and copied it, change the table and state to match the hr case table (so I thought).
But the chatbot keeps returning 'No Records Found' decision.
Here is the Resolve Incident 'Get Incidents' Script Action:
(function execute() {
var gr = new GlideRecordSecure('incident');
gr.addQuery('assigned_to', vaInputs.user);
gr.addQuery('state', '!=', vaVars.resolved_state)
gr.addActiveQuery();
gr.orderByDesc('sys_updated_on');
var start = parseInt(vaVars.index);
var end = start + parseInt(vaVars.limit);
gr.chooseWindow(start, end, true);
gr.query();
vaVars.count = gr.getRowCount();
var results = [];
while(gr.next()) {
results.push({
'value': gr.getUniqueValue(),
'label': gs.getMessage('{0} [{1}]', [gr.getDisplayValue('short_description'),gr.getDisplayValue('number')])
});
}
vaVars.results = JSON.stringify(results);
})()
And here are the next steps it takes once it gets records
Here is what I changed to try and match HR Case tables:
(function execute() {
var gr = new GlideRecord('sn_hr_core_case');
gr.addQuery('assigned_to', vaInputs.user);
gr.addQuery('state', '!=', vaVars.closed_complete_state)
gr.addActiveQuery();
gr.orderByDesc('sys_updated_on');
var start = parseInt(vaVars.index);
var end = start + parseInt(vaVars.limit);
gr.chooseWindow(start, end, true);
gr.query();
vaVars.count = gr.getRowCount();
var results = [];
while(gr.next()) {
results.push({
'value': gr.getUniqueValue(),
'label': gs.getMessage('{0} [{1}]', [gr.getDisplayValue('short_description'),gr.getDisplayValue('number')])
});
}
vaVars.results = JSON.stringify(results);
})()
And here are my next steps to match:
I keep getting taken to the No Cases Found decision and I am thinking I have the table set up wrong from the very first step. I definitely have cases assigned to myself.
Anyone able to assist with this?
Thank you!
-Rob
Yes, so here is what I have for those:
Prompt:
(function execute() {
return gs.getMessage('You have {0} Cases assigned. Which Case do you want to resolve?', vaVars.count);
})()
Reference Type: Script
Choice Value Expression:
(function execute() {
var results = JSON.parse(vaVars.results);
var options = [];
for(var i = 0; i < results.length; i++) {
options.push({ 'value': results[i].value, 'label': results[i].label });
}
if ((parseInt(vaVars.index) != 0)) {
options.push({ 'value': 'show_previous', 'label': gs.getMessage('Show previous') });
}
if (parseInt(vaVars.count) > (parseInt(vaVars.index) + parseInt(vaVars.limit))) {
options.push({ 'value': 'show_next', 'label': gs.getMessage('Show more') });
}
options.push({ 'value': 'cancel', 'label': gs.getMessage('I\'m done') });
return options;
})()
Script:
(function execute() {
return vaInputs.sn_hr_core_case.getValue() == 'cancel';
})()
And the rest match to have the correct table within their script (where applicable.
