Q&A BY TAG 'syntax'

You must sign in to ask a question. If you do not have an account, you can register here

INSERT INTO with SELECT
answered 18-10-2021 04:32:01 -0400

Hi Team, Could you please confirm the below limitation of VQL syntax. Working - INSERT INTO view2 SELECT col1 FROM view1; Working - INSERT INTO view2 (col1) VALUES ("abc"); Not working - INSERT INTO view2 (col1) SELECT col1 FROM view1; Not working - ...

Answers: 3

VQL insert syntax

Syntax for a Condition: Last Ten Years
answered 13-08-2015 04:08:01 -0400

Hello, Here is my current condition: todate('MM/dd/yyyy', ITEM.datefiled) >= todate('MM/dd/yyyy','08/12/2005') I would like to modify this so that it will only bring back the last ten years from whatever date it is currently. Thank you

Answers: 1

date itpilot condition field syntax

Find Element by Beginning of ID or Name
answered 24-03-2015 06:35:27 -0400

Hello, I am trying to find an element which is a textbox by name or id. The last 5 digits of the ID and name change daily.(example below) I was wondering if there is a way to FindElement that starts with, or contains, or islike a certain phrase rat...

Answers: 3

Denodo Element By Find FindElementbyXPath syntax ID ITPilot