Is there a way to create a parameter in the parameter builder where you can base the parameter list on names but use the id of that name in a query filter. Example; I have a table called Methods. Each method has an int ID and a string Name. I want the Name to show up in the prompt for the parameter, but when a user selects the name I want the ID to be used for the filter in the query.
It sounds like you want to have a display name and an actual value for each item in the list.
You cannot do this in the query builder with project parameters, but it is supported when you create a stored process. In our next release, this is supported with the new project prompts.