Where can I go within IPS to create an Adhoc Value Code Definition? Currently in the Adhoc Value Code Definitions out of the box all pertain to Employee ID, Users and Dates, I need to create a definition that is related to Activity Codes.
Hi,
Sorry, I'm not sure how to achieve this but definitely on my wish list when filtering an adhoc report using a code definition field!
Fingers crossed someone knows a way, otherwise would make a good enhancement request.
Kenny, what issue are you trying to solve? That code table is maintained by development and not user editable. Even if you could get a new entry added, the Ad Hoc report would not know what to do with it.
That field, while it has a popup, is not validated to the popup list, so if you are just trying to run a report where work order number = 99999 then you can just type the 99999 in the field even though it is not in the popup.
Mike
I reread your question and see this is about Activity Codes, so I believe you are expecting the popup to change to the code field popup if you specified a code field property? If so, unfortunately, this is not part of the functionality and you would need to know the code value and specify it in the edit field the same as the work order number I described above.