Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
paulsiu

Senior Member
Registered:
Posts: 57
Reply with quote  #1 
I have a drop down that uses key/value pair. The issue is that sometimes an entry gets retired, so key = 555, value = special promotion may be disable for new actions, but existing actions are still valid. 

To filter out disabled items, we can set the drop down script something like this:

select value, key from table where active='Y'

Unfortunately, if the value doesn't show up in the drop down, it won't show up in the drop down control either, so if 555 special promotion is disable, all that is display is the key.

Obviously, we can change the key/value to just a value drop down, but that may have undesirable consequences. What are my other options? I thought of creating a readonly calc text field that sits on top of the drop down. This appears to work with a bad side effect that you cannot click on the control to display the drop down, only the down arrow. Unfortunately, it then triggered the bug where some of the calculated field become editable, which is really hard to fix.

Paul

0
BMellert

Guru
Registered:
Posts: 688
Reply with quote  #2 
I have altered the query for the drop down contents on occasion to something along the following:
     select value, key from table where active = 'Y' or key = <curkey>
where <curkey> is the value/variable from your project/solution.

This will show all values that are active ... or match the folders current value, especially on read-only / tab view.
This works well for display purposes.

You should consider whether if you allow editing but no longer want to allow the old value (555) you may want to either modify the or condition to look whether in the action as well or do some sort of check on form save.  It depends on your requirements in this case.
0
paulsiu

Senior Member
Registered:
Posts: 57
Reply with quote  #3 
Your suggestion is rated Awesome! It was extremely clever and save me tons of work.

Thank you.

Paul
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!