Ability to create user defined functions on row level
Can it be made possible to create defined functions in DV?
The user defined function must be used on a row level, i.e. in a sql statement.
With these functions the acceptance of DV by our endusers can be increased.
Especially the date / time functions are different from what they are familiar with in their end-user tools.
For example, we could create an add_months function that uses the TimeStampAdd function.
select add_months (date_field, -1) from tab;
selecting TimeStampAdd (SQL_TSI_MONTH, -1, date_field) from tab
Now, we have to rewrite existing applications whenever we want to connect them on DV.
With these functions we can simplify that transformation.
Comment actionsOfficial comment
thanks for posting your request to our online community.
Having the possibility to easily create user-defined functions that can be also mapped to existing DV functions would indeed improve the usability. One thing to consider is also how these functions can be pushed down to the underlying data sources, if supported.
We added your request to the wishlist and we will consider it in our Roadmap, but at the moment I cannot give you an exact estimation when this feature will be implemented.
I will follow up here as soon as I have more info.
Please sign in to leave a comment.