Does anyone know of a way to dynamically disable a drop down in a promptset based on a choice the user made in another drop down? Or change the values of a drop down?
If not, this may be a good feature request.
On a the Dropdown type for a PromptSet, the 'Dynamic' checkbox should give you the functionality.
The list of Guides a user can choose from is different based on the product and type they choose.
TheData Reference is pointing to a SQL variable that takes the values from the previous selections and returns a list
So it looks like:
QUERY_DOCU.GUIDES is a variable VARA.SQLI object and the "select query" to the database is written there.
This variable "QUERY_DOCU.GUIDES" is being used in the Data Reference of the promptset for the Guide Drop-Down line item and that field has also been marked dynamic.
So whenever the promptset is activated, it calls the QUERY_DOCU.GUIDES for fetching the query result each time dynamically.
Retrieving data ...