For your scenario, you could use the **View Parameters** option of derived views for passing the value for a field dynamically. You can add this option either using the GUI or use it in the view definition like below:
>CREATE OR REPLACE VIEW iv_student AS SELECT id, name, dept FROM bv_student USING PARAMETERS ( id : int );
This will create a new field "id" whose value should be passed dynamically during execution(everytime the user runs the query).
For detailed information, take a look at 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.
Hope this helps!