Latest Activity

code

Lag() function used together with Group By

Hi, we are currently running VDP 7 20210818. The query can be delegated to an SQL Server. I try to use the Lag() function in a Group by VQL clause. Select lag(a.activity_id) over (partition by a.patient_id order by max(a.startdatetime)) as prev_activ...

code

VQL Display rows

denodo 8: VQL Option Display rows: seems to be that the max value there is 1000. is it possible to force to display all rows (enabling also retrieve all rows)?

code

SQLAlchemy Denodo Connection Issues

Hi there, I am trying to use sqlalchemy with denodo but I am running into a few issues. I have the dialect added as per the instructions from your sqlalchemy dialects page, and I can parse the connection string it seems. However, whenever I create a c...

code

JSON datasource - HTTP POST - ARRAY request and response FLATTEN

HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...

code

Denodo Usage metrics

Total Number of Users on platform Total number of objects created on daily basis How do I query and get the above information using catalog queries? Thanks

code

Has anyone successfully implemented HP Voltage custom decryption function?

We are unning into problems while loading native libraries and JARs. logger.debug("VOLT: build context - policyUrl: " + policyUrl); logger.debug("VOLT: build context - trustStoreDir: " + trustStoreDirectory); logger.debug("VOLT: build context - vibeS...

code

Solution manager account

Do we have to use admin account to login to solution manager,? is there a role or something similar to grant to indivisual id, so indivisual can login with his credentials. we dont want to use admin account to login to solution manager

code

Row_Number command

Hi. I am getting a SQL Error [1100]: Syntax error: Exception parsing query near '*'. Can someone show me how to properly code the below. I am trying to aggregate this to one record per key. With V5035_C12_POL_CT as (SELECT ROUTINE2.AGENT ,ROUTINE2.POL...

code

Complex filtering on blocks with labels

Hello, I am creating an app where teachers can search for resources. Each resource is tagged with topics which are used to flter results. I have a complex use case and am looking for some advice For example: Resource 1 is tagged with topic "Math...

code

What is a Scheduler Job misfire?

The only documentation I can find regarding the word misfire is located in the Denodo job Handler section. https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/handler_section Can ...