question Issue with "Dynamic choice" in Virtual agent in Community Central forum

Issue with "Dynamic choice" in Virtual agent

bondita1 — Sun, 19 May 2024 20:09:16 GMT

I want to create a 'Dynamic Choice' in the Virtual Agent to display a list based on the values in the Category field.
To achieve this, I have queried the sys_choice table with the following conditions.

So that I should get the below option for Category.

I have added the below code snippet in my script:

(function execute() {

var options = [];

var gr = new GlideRecordSecure('sys_choice');

gr.addEncodedQuery('inactive=false^table=incident^element=category');

gr.setLimit(5);

gr.query();

while(gr.next()) {

options.push({ 'value': gr.getUniqueValue(), 'label': gr.getValue('label') });

}

return options;

})()

But in my Virtual Agent, I am seeing other options that are not based on the query I provided.

Could someone please help me with this.

Thanks.

Re: Issue with "Dynamic choice" in Virtual agent

goldenjc97 — Wed, 07 Aug 2024 14:59:54 GMT

@bondita1 - Were you able to figure this out?

Re: Issue with "Dynamic choice" in Virtual agent

GlideJ — Mon, 14 Apr 2025 16:07:07 GMT

For anyone else having this issue, it has to do with the filter on the query. Instead of 'table = incident' it should instead be 'name = incident'.

EX:

(function execute() {

var options = [];
var gr = new GlideRecord('sys_choice');

gr.addQuery('inactive', 'false');
gr.addQuery('name', 'incident');
gr.addQuery('element','category');
gr.query();

while(gr.next()) {
options.push({ 'value': gr.getUniqueValue(), 'label': gr.getValue('label') });
}
return options;

})()