Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Feb 23, 2019

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

No description provided
  • Attach files
  • 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.