Assignment group is showing sys_id instead of group name

hemanth16
Tera Contributor

I have created one report when i added the column as assignment group and state as row in assignment group it is showing sys id instead of group name 

can anyone suggest?

Thanks in Advance! 

find_real_file.png

1 ACCEPTED SOLUTION

AnirudhKumar
Mega Sage
Mega Sage

The Display value could be incorrect for your table.

1. Go to your Groups table

2. Right-click on any of the columns

3. Select Configure -> Dictionary

4. In the filter add, Display = true

 

Ideally, you should not be getting any records or there should be a single record which is for the Name field.

In case you get something else, ensure only the Name field has Display checkbox set to true, and other fields have Display = false

View solution in original post

4 REPLIES 4

Aoife
Tera Guru

On my instance it gave me the name and not the sys_id.

Not sure why the difference, however:

try expanding the Assignment Group, then select the Name field.

 

Aoife

AnirudhKumar
Mega Sage
Mega Sage

The Display value could be incorrect for your table.

1. Go to your Groups table

2. Right-click on any of the columns

3. Select Configure -> Dictionary

4. In the filter add, Display = true

 

Ideally, you should not be getting any records or there should be a single record which is for the Name field.

In case you get something else, ensure only the Name field has Display checkbox set to true, and other fields have Display = false

Only issue is that this will cause the field you set Display=true on to show up on every drop down and reference lookup that uses that table.  It may have been turned off because someone did not want Number show up on those lists in other forms.  It impacts the entire system, not just your little part of it.

Aoife

AnirudhKumar
Mega Sage
Mega Sage

Hello Hemanth,

Has you issue been resolved?