dynamic promptset

[SamahSohrab607228]

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.

[Anon Anon]

On a the Dropdown type for a PromptSet, the 'Dynamic' checkbox should give you the functionality.

For example:

The list of Guides a user can choose from is different based on the product and type they choose.

https://us.v-cdn.net/5019921/uploads/editor/t7/i9hik868t6pv.png" width="1391">

TheData Reference is pointing to a SQL variable that takes the values from the previous selections and returns a list

https://us.v-cdn.net/5019921/uploads/editor/uf/4c2i2902lzg9.png" width="1600">

So it looks like:

https://us.v-cdn.net/5019921/uploads/editor/f7/fxj0l20ywn77.jpg" width="1600">

[SamahSohrab607228]

Jennifer, Can you provide more details on this? Where are the values for the Guide field stored? Are they in a static variable of it's own?

Also I'm not sure I understand your query? Why are you looking at &$CLIENT#?

[Legacy User]

Hello Samah,

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.

Thanks,

Arun