System pick lists are showing the value not the title in query results

[tlammer]

Pick lists such as Reference work type and agent type are displaying the value for the pick list, which in these instances are numbers, rather than the title, which is what is displayed on the form.
Further, you cannot edit the values in these pick lists without causing further, significant issues.

[norinespears]

Edinburgh noted this - as well as others.

[benanhalt]

I'm not sure if this affects all picklists or just the ones mentioned (needs research)

Either way it is probably not too difficult to fix. But it would need testing to be sure new bugs weren't introduced.

[norinespears]

Need to research:
does this affect all Pick Lists?
are these supported in Queries?
discover which pick lists are reading the value rather than the title (System, User Defined, Prep Type)

[maxpatiiuk]

Does not happen for Agent Type for me:

Though, it seems like the back end returns Agent Type as a title, but Reference Work as an ID:

@benanhalt Is value to title conversion supposed to happen on the back end or the front end?

See also #443

[maxpatiiuk]

Similar issue:

The filtering box expects a number (picklist item id), not a string (picklist item label)

Screen.Recording.2021-07-12.at.7.15.05.PM.mov

[grantfitzsimmons]

I had the same issue again. Tipus is showing its value in the database rather than its title (Book, Report, etc).

[maxpatiiuk]

Fixed for all pick lists in 9fd6572