Skip to Content

@prompt variable not using associated dimension's Index awareness

Mar 07, 2017 at 01:38 PM


avatar image

I have a dimension, Lists\Surgeon Group, that defines the Select (GROUP.NAME) and the Primary Key awareness (GROUP.ID). Both values are Characters. I've also defined a list-of-values for the dimension that displays the values from the GROUP.NAME.

I reference this dimension in a prompt:

@Prompt( 'Select one or more Surgeon Groups(s)', 'A', 'Lists\Surgeon Group', multi, Constrained)

Unfortunately, the prompt is returning the GROUP.NAME value, rather than the GROUP.ID.

Are key values supported in @prompt variables? If so, what am I missing?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
craig buchanan Mar 08, 2017 at 03:03 PM

I needed to use the primary_key keyword:

@Prompt('Select one or more Surgeon Groups(s)','A','Lists\Surgeon Group', multi, primary_key)
10 |10000 characters needed characters left characters exceeded