You can translate the question and the replies:

Creating Mandatory Fields

Hi, Is there a way to create a mandatory fields for views? PS: datasource is JDBC not JSON Thanks
user
25-08-2021 22:41:29 -0400

1 Answer

Hi, In order to set any field as **mandatory** during execution, then I could create a **selection view** on top of the base view with View parameter. The value of the View parameter can be assigned to the existing field of the selection view from the WHERE CONDITION tab. To get more information, you can refer to the [Parameters of Derived Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#parameters-of-derived-views) section of the Virtual DataPort Administration Guide. Alternatively, you can also **edit** the VQL code associated with the **base view** in order to change to the field as mandatory. Hope this helps!
Denodo Team
26-08-2021 02:49:51 -0400
You must sign in to add an answer. If you do not have an account, you can register here