Spotfire Ideas Portal
ADD A NEW IDEA

sql support

    Showing 15 of 4798

    Support Oracle 18c

    No description provided
    almost 7 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

    Allow virtual columns to support IN clauses/multiple value filtering

    We have customers using virtual columns in an SQL view, e.g: Select *, {DECLARE p_postdate date } p_postdate from table where post_date=p_postdate This functionality needs to be expanded to support multiple values pf p_postdate (i.e, an IN claus...
    about 7 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

    Add an hashfunction base on the SHA-256 algoritme to TDV

    In case 02225472 I asked you "Dear Tibco-support-people, In TDV there is a sql statement HASHMD2, which hashs strings with the use of the MD2 hash-algoritme. Example: select hashmd2('hello tibco') results in b86f42e31e1aba5055b72b78381aa01c Unfort...
    almost 2 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

    SQL JSON parsing in TDV should be improved

    Using JSON_TABLE is cumbersome, and there are no examples on how to do JSON parsing in a simple way using a transformation (can it even be done?). As an example, Postgres has a simpler syntax allowing queries like this : SELECT id, data::json->...
    about 2 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

    Inclusion of more regular expressions in TDV just like it is present in Oracle

    There are several queries where we need regular expressions like REGEXP_LIKE ,some of the regular expressions are not supported so it would be nice if those can be inlcudes
    almost 7 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration
    This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us