Filter Assignment Group field by hasRole

[denisdoucet]

I've created a new application to which I have extended the Task table.
I have 2 type of groups, one of which will have an admin role associated to it and all others will have a user role associated to it.

I want to filter the the assignment_group field to only show groups that contain both the admin and the user roles.

I've come across articles for reference qualifiers but it seems like it's converting my Assignment Group reference field to a select box.

I'm looking for best practice and possible approaches on how to set this up for my application and not mess with other applications that have the Task table extended to it.

Thanks in advance.

[ccajohnson]

Typically you see that behavior if the field has the Choice List Specification defined. I do not see anything in a Dictionary Override that turns that on or off, so I would look there first. Also see what kinds of Attributes are defined to see if you can turn those off in the dictionary override.

[ccajohnson · Accepted solution]

I did some investigating in my developer instance and found some interesting ways you can get around this depending upon how your Assignment group [assignment_group] field is defined on the base table.

If you have the Choice List Specification defined, you may also have an attribute set as well:
ref_auto_completer=AJAXReferenceChoice

If that is set, you can use your Dictionary override to set an attribute which defines the threshold to switch from a menu to be an actual reference field:
max_ref_dropdown=1

I just tested this and determined that even if you do not have the ref_auto_completer set to AJAXReferenceChoice, the above max_ref_dropdown attribute will still force the field to be a reference field, especially if you have more than 1 group to select from.

[denisdoucet]

Thanks ccajohnson, doing that attribute override switched it back to a Reference field.

Much appreciated!