Desktop productivity for business analysts and programmers

Creating parameters based on PK ID of a table.

Reply
Occasional Contributor
Posts: 18

Creating parameters based on PK ID of a table.

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.
Community Manager
Posts: 2,884

Re: Creating parameters based on PK ID of a table.

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.

Chris
Ask a Question
Discussion stats
  • 1 reply
  • 95 views
  • 0 likes
  • 2 in conversation