Skip to Main Content
Spotfire Ideas Portal

Use Oracle Lead and Lag functions between Oracle database and spotfire information link

No description provided
  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Feb 25, 2019

      Please file a support request at https://support.tibco.com and our team will have a look at this issue. Thanks, Thomas

    • Guest
      Reply
      |
      Feb 23, 2019

      I am using the following in a select statement but gets an error:

      Lead( "DATETIME#1", 1, 0) OVER (ORDER BY  "DATETIME#1") AS "NEXT_DATETIME#2" and received
      the error "Failed to execute query: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes:

      Note: DATETIME#1 is already defined as DateTime type column in information link and trying to create and populate DATETIME#2 column from the leading rows of DATETIME#1 column values.

      Doing this from the SQL environment of the information link.