You can translate the question and the replies:

Passing fields as parameter

Hi Team, I would like to know how can I parameterized values on denodo quiries. e.g Whenever I execute a query a pop up must apear asking me to type in dates.
user
08-09-2021 04:20:17 -0400

1 Answer

Hi, In order to pass the values dynamically, I would use the [interpolation variable](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables). By using interpolation variables, paths and other parameters of data sources can be parameterized. Hence, I can provide the values of a field at runtime instead of design time. For example, if I need to create a base view that allows us to pass the value for a field at runtime, I would perform the following steps: * Create a base view by using the ‘[Create from Query](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries)’ option. * Write the query and replace the input parameters with interpolation variables like @VARIABLE. * Click OK and enter the values of the variables(any possible sample values) used in the query. You can refer to the similar community Question[ How to create base view which accepts parameter](https://community.denodo.com/answers/question/details?questionId=9060g0000004ElXAAU&title=How+to+create+base+view+which+accepts+parameter) for more information. Hope this helps!
Denodo Team
08-09-2021 06:56:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here