# List of values management

Users can specify a drop-down list of pre-defined values for both Table and Filter portlets. This pre-defined list is called a list of values. When used, the list of values will limit what a user can enter in a specific field.

To add a new list of values, go to *Settings* then *Lists of Values*.  Click the *Manage* button.

<div align="left"><img src="https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M0YsuDw2QeVbHpsFZvx%2F-M0YtGqVnB-k0YGj07XW%2Fimage.png?alt=media&#x26;token=060b1063-643f-494c-9854-28805d5c941a" alt=""></div>

Click the + icon to add a new list of values, then select the data source:

* Database: add name, connector and select statement.&#x20;
* Workflow: create a workflow with output and connect it to the list of values using the drop-down list. The workflow can also be created and connected directly from the list of values by clicking New - Add a name - Create.

Click *execute,* add the text and value columns, then save.&#x20;

* Text column: the value which will be shown in the drop down when using the list of values.
* Value column: the value which will be sent as the filter value

To edit an existing list of values, just click on the list of values in question and edit.

![](https://3419513391-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LtPTgZOYmpJka4jqs1v%2F-M0T1Ure2MFhxKZ7tzme%2F-M0T1YLukeLVy0DOFV73%2FLov4.gif?alt=media\&token=692115f5-19b4-4d89-9e92-b9565f3bfcec)