> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-2/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/self-service-visualization-2/applying-filters/global-filter/lov-settings.md).

# LOV Settings

The user can enable the filter and lookup for specific dimensions via the Data Type Definition step for a Data Store. All the selected (enabled) dimensions list with the sub-values, while for the disabled ones, no sub-values appear. This operation applies to both Local and Global filters.

* Navigate to the ***Data Type Definition*** page for a Data Store (the image displays the Data Type Definition page for the Data Store where Dimensions like ***gender**, **skills,*** and ***ename*** are enabled for the filter lookup function, but ***source, previous\_organisation,*** and ***team*** are disabled from the filter lookup.

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2Fw9eg6JsmRiYAWXBfqVFP%2Fimage.png?alt=media&amp;token=2bde1158-d591-473c-9019-d422b57ebd32" alt=""><figcaption><p>Selecting LOV filtering</p></figcaption></figure>

* Create a story based on the same Data Store and save it with relevant views.
* Access the global filter panel.
* Select any of the disabled Dimension values (E.g., the ***State*** dimension is selected from the Filter panel in the following image).
  * *The sub-values for the **State** dimension do not get displayed.*&#x20;
  * *Only **Like** and **Not Like** options can be applied to the disabled dimensions.*

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2FalFLMPwYKpG1GaUTVUxb%2Fimage.png?alt=media&amp;token=26f5b97b-c27c-4507-9904-d184d0c004c6" alt=""><figcaption><p><em><strong>LOV disabled Dimension Value</strong></em></p></figcaption></figure>

* Select any of the enabled Dimension values (E.g., the division as Dimension value has been selected in the given image).
  * The sub-values for the division dimension get displayed.
  * It displays all the filter operations ***In***, ***Not In***, ***Like***, and ***Not Like*** options for the enabled dimension. &#x20;

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2F7YU8ZbdIqULk3fLiHnSt%2Fimage.png?alt=media&amp;token=18e2f526-640d-4d14-9f16-6596392bc6a9" alt=""><figcaption><p><em><strong>LOV enabled Dimension Value</strong></em></p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>&#x20;*&#x20;

* *The disabled Dimension values from the LOV do not display the sub-values and there will be only **Like** and **Not Like** options available for the **disabled** dimensio*n.
* The enabled Dimension values from the LOV display the sub-values and there will be ***In***, ***Not In***, ***Like***, and ***Not Like*** options available for the enabled dimension.
  {% endhint %}

## Applying Like & Not Like filter options

The user can successfully apply the ***Like*** or ***Not Like*** option.&#x20;

* Open the ***Global Filter panel***.
* Select a disabled dimension value.
* Select an option out of [***Like***](#user-content-fn-1)[^1] or ***Not Like*** choices (E.g., ***Like*** option has been selected in this case).
* Manually provide a sub-value to filter the Story (E.g., ***C19\_75*** is the selected sub-value from the vehicleId dimension).
* Click the ***Apply*** icon.

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2FBWa6gjtcZlgXFqFGO5Ya%2Fimage.png?alt=media&amp;token=decf089a-1f7b-4364-9f51-df7744013555" alt=""><figcaption><p><em><strong>Applying Like option on a disabled value</strong></em></p></figcaption></figure>

* The Story Views get filtered by the selected sub-value.

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2FqnwTsj1nQYCCyblyEsDb%2Fimage.png?alt=media&amp;token=e77df82d-35c6-491f-aa2c-e4186ceb2e07" alt=""><figcaption></figcaption></figure>

* Select the ***Not Like*** as the filter operation for the same sub-value.

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2F2gBIKOELwr8wCpA145VT%2Fimage.png?alt=media&amp;token=81599884-79f8-4ec4-b65e-c8a98ad78b5f" alt=""><figcaption></figcaption></figure>

* The concerned views get filtered, excluding the entered values (E.g., The ***Story*** displays filtered data with the values except the C19\_75 vehicleId data).

<figure><img src="https://750268497-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRaZBXhWvWF2Al5nTd3kg%2Fuploads%2FItoewoZdsf2V7NkjwoKv%2Fimage.png?alt=media&amp;token=6d627ed8-902c-4fc7-9908-f4115c6dfe5b" alt=""><figcaption><p><em><strong>The Report Views get filtered except the filter value selected as Not In option</strong></em></p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The **Like** and **Not Like** operations are available in the **View Filter*** ***panel** as well.*
{% endhint %}

[^1]: