Reference qualifier not working on Dictionary Entry Override

Abigail
Tera Expert

 

Issue with the Assignment Group Field in the incident_task Table

I want to specify that only groups with a defined group type should be shown in the Assignment group field. However, when I applied the filter, 15 records are displayed. Yet, when I use the same filter in the reference qualifier, only 5 records are shown.

Abigail_0-1729620045430.png

Any idea

1 ACCEPTED SOLUTION

That's helpful.  I meant to ask for these results too, but if you could also show a list view of the table containing the columns Name Type and Parent, with the filter that should clarify things

BradBowman_0-1729700014382.png

If you change the attribute in the override to tree_picker=false you will see a similar list view, with whatever columns you define in the List Layout - if this view is clearer for you, and you don't need or want to see the group members

BradBowman_1-1729700213688.png

 

 

View solution in original post

20 REPLIES 20

Anand Kumar P
Giga Patron
Giga Patron

Hi @Abigail ,

 

To get the reference qualifier code, go to the table the reference field points to (e.g the group table) and apply your filters. Once the correct records are shown, right-click the filter and choose “Copy Query.” Paste this query into the Reference Qual field on the assignment group dictionary record.

If not check below one:

Check for Acls on incident task table that restricting access to see assignment group records.

 

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

Brad Bowman
Kilo Patron
Kilo Patron

The Type field on the Groups table is a List, which means it can contain more than one value.  Your reference qualifier is only returning the groups which only have that Type, whereas your list filter is including groups that have that Type as one of the values.  To include the others in the reference qualifier, change the beginning to

typeLIKE

followed by the sys_id of the type you are after.

Hello @Brad Bowman  that doesn't work either; I get the same result.

This is not making sense, but I'm sure there's a perfectly logical explanation.  Let's break it down to clarify assumptions and see where it's going wrong.  I have a sys_user_group_type record - let's say it's the out of the box one named 'catalog' with a sys_id = 74af88c6c611227d0066386e74dc853d

 

If look at a list view of the sys_user_group table, then manually filter like this, I see 6 records in my instance

BradBowman_1-1729636548813.png

I create a Dictionary Entry Override for the assignment_group field on the incident_task table using the Attributes you have, and a reference qualifier like this:

BradBowman_2-1729636672217.png

On an Incident Task record, when I click the reference search icon (magnifying glass), I see the expected 6 group names

BradBowman_3-1729636751662.png

 

When you say you 'applied the filter, 15 records are displayed' what does that mean - what is the filter?  Does it also include type is / is not null, or something else?  Do the 15 group records display all have this certain type as or in their value?