Creating a Dataset from a Dynamic Dropdown List

[Stephen_Beck]

We have a user who has a keyword with a dynamic drop down list that they would like to convert to a dataset.  Is there a way to do this?

Steve Beck

[Bryan_Hurless]

Thank you for using the OnBase Community Stephen,

Unfortunately there is currently no way to do this directly from OnBase, however if you contact your first line of support they will be able to provide you with a solution that should solve this issue.

Thanks again for using the OnBase Community!

[Stephen_Beck]

Bryan, we are the first line of support. Should we contact our Hyland Tech Support team?

[Bryan_Hurless]

Stephen,

The first thing that you need to do is create a new Keyword Type and enable the "Use Keyword Data Set" setting.

Make sure you set the maximum length equal to or greater the maximum number of characters in the source Drop Down list Keyword.

Next, you would select the newly created Keyword type and click the "Data Set" button.

When the "Keyword Data Set Configuration" dialog opens, mark the "External" Checkbox and click the "External" button.

This will open the "External Keyword Data Set Configuration" dialog.

Basically you are going to be querying the source keyword table, and pulling back the existing values.  For more information on the External Data Set configuration refer to the System Administration MRG starting on page 429.

Make sure the query ends in " LIKE ‘_filter_%’ " See page 431 of the System Administration MRG for more information.

I hope this helps!

Thanks again for using the OnBase Community!