Setting up a Choice List Interactive Filter

[jorgel]

I'm trying to create a choice list interactive filter based on the Assignment Group Manager. However I'm getting the following error:

I've setup the Choice List Specification in the Dictionary.   Any ideas why I'm getting this error:

Thanks.

JorgeL

[Arnoud Kooi]

You should base your filter on Reference, something like:

Note that you also need to add the Interactive Filter Refrences via the related list to Incident and other tables.

A pro tip..

You probably want to restrict the choices to the user how are actually group manager.

In List v3 you can filter on this the following way, via related list condition.

This however is not supported to select in the Interactive Filter form.

But you can force it by setting it using this background script:

var filter_sys_id = '8d758e5a4ff9b68074570ab18110c714'; //change to your sys_id
var gr = new GlideRecord('sys_ui_hp_publisher');
if (gr.get(filter_sys_id)) {
   gr.reference_conditions = '^RLQUERYsys_user_group.manager,>=1^ENDRLQUERY';
   gr.update();
}

Be aware that this is not supported, so you would need to run the script again if you make a change in the form.

Good luck!