Active IQ Unified Manager Discussions

WFA drop down query locking

cscott
3,189 Views

Hello,

     I am hoping I am missing something easy in setting up an SQL query with a drop down box.  How do I set a drop down box to only accept the query output?

 

I have custom comment fields in DFM that are used to provide certain volumes based off of other input.  However, a customer can still type text freeform into the query box, and I need to restrict that.  The input box should only accept the query output for security reasons in this situation.  

 

Thank you,

Scott

1 ACCEPTED SOLUTION

korns
3,183 Views

I believe that is controlled by the 'Lock Values:' attribute on a User Input field. If it is checked, the user will not be able overide but only choose one of the query results. When it's not checked they can type something else into the field.

View solution in original post

2 REPLIES 2

korns
3,184 Views

I believe that is controlled by the 'Lock Values:' attribute on a User Input field. If it is checked, the user will not be able overide but only choose one of the query results. When it's not checked they can type something else into the field.

cscott
3,172 Views

Oh geez,

      I had tried that, but had an issue with my SQL query that I did not catch so there were no results and I thought that locking it was breaking the field.

 

Thank you very much!

Scott

Public