Latest Activity


Denodo Parameter Error - without search methods

I created a view with a parameter. If there is specific value typed into that parameter the view processes just fine.However, I need the parameter field to be blank, so when you open the view the end user has the option to type in the parameter they ar...

search methods Parameter


How to apply text function on field that is used for search method

Hello, I want to apply a text function to a field that is used as query parameter for a base view. The reason for that is because we receive some input parameters (for example a number) and I need to add a prefix. If I receive "12345" I need to add "c...

Denodo 7 search methods


Merge search parameters for derived view to other 3 underlying views

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

VQL Denodo 7.0 search methods join Derived views


View statistics questions

I recently inherited Denodo admin duties and am investigating a scheduled job which is failing. The job gathers a list of all base tables in Denodo, then runs the following VQL: CALL GENERATE_SMART_STATS_FOR_FIELDS('SMART_THEN_ATSOURCE_THROUGH_VDP','B...

generate_stats search methods VDP resultset Statistics timeout


Confused behavior of Multiplicity in search methods

All, I have been evaluating verson 6.0 express edition. I have a base view generated from Oracle , Name : emp , There Date type column EmpJdate , is nothing but employee joining date. In serach methods I have following setup for EmpJdate Type - Date Op...

search methods Express 6.0 Multiplicity



I have created a base view for client(client_id text, client_type text, name text, surname text) coming from a jdbc data source. Five tuples: Client_id text any OPT ANY { } YES. I changed the Output tuple to NO but still when I query the base view usi...

search methods


Search methods and subquery

I am using a webservice source in which I have a parameter in the connection definition. I would like to obtain value(s) for this parameter from another view using a subquery. However during excecuting the whole query an error mesage pops up indicating...

subquery search methods parameter