Q&A

Lag() function used together with Group By
answered 21-03-2022 08:25:17 -0400

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...

Answers: 1

VQL Display rows
answered 21-03-2022 08:10:38 -0400

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)?

Answers: 1

SQLAlchemy Denodo Connection Issues
answered 21-03-2022 08:04:19 -0400

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...

Answers: 2

SQLAlchemy Connection

JSON datasource - HTTP POST - ARRAY request and response FLATTEN
answered 21-03-2022 04:15:04 -0400

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...

Answers: 1

ARRAY JSON FLATTEN JSON Datasource

Denodo Usage metrics
answered 18-03-2022 02:26:42 -0400

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

Answers: 3

Has anyone successfully implemented HP Voltage custom decryption function?
answered 17-03-2022 09:00:14 -0400

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...

Answers: 1

Solution manager account
answered 17-03-2022 08:02:18 -0400

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

Answers: 1

#solution manager admin

Row_Number command
answered 16-03-2022 09:34:54 -0400

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...

Answers: 1

Complex filtering on blocks with labels
answered 16-03-2022 08:56:13 -0400

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...

Answers: 1

search GraphQL Custom Input Filter

What is a Scheduler Job misfire?
answered 16-03-2022 08:08:08 -0400

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 ...

Answers: 3

Denodo Scheduler 7.0