User Defined Codes in BAQ (Code deleted)

[MelissaC (Melissa Couture)]

I don’t know where to start looking for the issue. We have a User Defined Code for User Queue. I add this as a drop down on the Main Job Entry Screen and want to use it as a filter on a Dashboard. On the dashboard each code I use is duplicated and says (Code Deleted) after it. (The same thing happens to the Request Type User Defined Codes). When I choose Jen or Melissa I get no results but I do when I choose the Code Deleted one. In Job entry there is only Melissa or Jen as an option in the dropdown.

Job Entry:

Dashboard

User Code Entry

[tanner (Tanner Post)]

It looks like you have records that contains the UD code descriptions instead of the Code IDs. Since Jen and Melissa are not valid IDs, it doesn’t know what description to show in the dropdown

[MelissaC (Melissa Couture)]

I changed the Value Member from CodeDesc to CodeID and that fixed it Thanks