Stack Overflow
Stack Overflow

Questions tagged [vql]

Vault Query Language (VQL) is a query language for the Veeva Vault similar to SQL.

Vault Query Language (VQL) queries share most of the same syntax as queries, such as SELECT, FROM, WHERE, FIND, etc.

Further information about VQL standards and specifications can be found at: https://developer.veevavault.com

For detailed information about the VQL syntax, such as; how to structure queries, and how to retrieve fields from a single object (document, product, etc.), see Query Syntax & Structure.

11 questions
2
votes
1 answer

Denodo Dive Split function URL

I'm trying the below code to select the last part of the URL: select 'http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs' , field_1[0].string from ( select SPLIT('([^\/]+$)',…
guess_work0205
  • 21
  • 2
0
votes
1 answer

Denodo column DISTINCT values concatenation

I'm looking for ways to concatenate two or more row values using the "|" separator. I found and used the GROUP_CONCAT() function, but it doesn't work for me using the "DISTINCT" clause. Here is an example of a working and non-working query: Working…
Rahul Hendawe
  • 902
  • 1
  • 14
  • 39
0
votes
1 answer

Temp Tables and Looping VQL/Denodo question

Suppose I had a query that would return something like this, except 1000 of records. lets call this EncounterTable EncId | StartDate | EndDate | Weight 1 1/1/2022 1/4/2022 .5 2 12/28/2021 …
DapperDanh
  • 555
  • 2
  • 5
  • 17
0
votes
0 answers

Is there a VSCode Extension for Denodo VQL highlighting and formatting?

The title says it all. I am looking for a VSCode extension to format and syntax highlight Denodo VQL Queries. Any help is appreciated. Thanks. Link to VQL:…
picklebrain
  • 1
0
votes
1 answer

Denodo/VQL ISO_WEEK

I wanted to work with iso week in Denodo. I could not find any functions or calculations. I wanted to use this code below: GETWEEK("ISO_WEEK", ADDWEEK(CURRENT_DATE(), 1)) Obviously there is no ISO_WEEK function. Have you encountered such a problem…
Ezgi Turalı
  • 1
  • 1
0
votes
0 answers

How to download very big table via python (using JDBC)

I have a very big table that I can access either through a Denodo front-end or through denodo-virtual client + jaydebeapi driver in Python, making queries in VQL and saving results to pandas like describe in the manual This table is so big that the…
euh
  • 319
  • 2
  • 11
0
votes
1 answer

Denodo: SPLIT and FLATTEN in the same query statement

regarding to the FLATTEN documentation you have to create a view containing a split first, before you can use…
user9898927
  • 73
  • 8
0
votes
1 answer

Denodo VQL, use union to add a record to view

I'm trying to add a specific record to a view in VQL using UNION but it gives me an error saying com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: The field properties can only be specified for derived fields. Does anyone know how…
mie
  • 1
  • 1
0
votes
1 answer

Is there a Denodo 8 VQL function or line of VQL for throwing an error in a VDP scheduler job?

My goal is to load a cache when there is new data available. Data is loaded into the source table once a day but at an unpredictable time. I've been trying to set up a data availability trigger VDP scheduler job like described in this Denodo…
Floor
  • 5
  • 3
0
votes
2 answers

How to declare a variable in denodo?

There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr =…
thrashrider
  • 1
  • 2
0
votes
1 answer

How to select id's of multiple products using VQL?

I currently have the following query to select the id of a single product, like so: client.post(`https://merck-nextgen.veevavault.com/api/v18.3/query?q=SELECT id FROM product__v WHERE name__v = '${VOLT_CREDENTIALS.get('cred').productName }'` , args…
Alexander Solonik
  • 9,838
  • 18
  • 76
  • 174