Unique Values in Record Producer Select Box

[stevenm]

I have a record producer where they want multiple items in a select box to have different names but the same value.  The values being used for mapping in the script.

I have the Unique Values checkbox UN-checked but it will not display those duplicate valued items.  Attached are screen shots.  Thoughts as to how I get all items displayed?

As you can see it won't display Emergency or Surgery even though Unique is unchecked.  What am I missing?

[Chuck Tomasi]

Can you explain what you are trying to do and why you want multiple choices with the same value? Somewhere, that's going to be used and you won't know which choice it came from, right?

Perhaps another alternative would be to use a unique value and then map to that to that sys_id via script or lookup table afterwards.

Example:

Clinical Documention & OB --> value1

Emergency --> value2

Surgery --> value3

Now you know which choice was picked and they show in the list separately... you can then map to that single sys_id in the script area of the record producer or a lookup table that saves the value. Think "incident priority is impact & urgency values".

Custom data lookup

[stevenm]

My requester want to see a list of team names for the users.  But some of those teams will map to the same assignment group when I create an ENHC. So they want to list Cinical Doc, Emergency, and Surgery but all three of those will map to the Clinical Informatics assignment group.  It seems if I don't have that Unique Values Only box checked that all three should list in the select box.  Does that make sense?

[stevenm · Accepted solution]

Your suggestion worked but I'm wondering what is the Unique Values Only checkbox for if it filters out duplicates when unchecked?

[Jim Coyne]

If you want to avoid maintaining unclear logic/scripting in the future, I would suggest you create a new custom table with 3 fields on it:
- String field for the name of the Service Line
- Reference field to the Group table
- Active field (you will need to keep old records)

That way you can have any number of Service Lines and set the appropriate assignment group.