Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: CDF and SQL queries....

  1. #1

    Default CDF and SQL queries....

    Hi,
    I have some Select Component that I would like to use with a sql query but for an unknown reason, the component doesn't return anything:
    distrib_title_Selector =
    {
    name: "distrib_title_Selector",
    type: "select",
    parameter: "distrib_title",
    parameters: [],
    valueAsId: true,
    htmlObject: "Select_title",
    queryDefinition:
    {
    queryType: 'sql',
    jndi: "NSADWT",
    query: function(){
    var query = "SELECT 'All Distributor Title' AS dist_title FROM FCT_CUST_ARO_SNAPSHOT UNION SELECT DISTINCT PROD_MEM_TITLE AS dist_title FROM FCT_CUST_ARO_SNAPSHOT";
    return query;
    }
    },
    executeAtStart: true,
    preExecution:function(){},
    postExecution:function(){Dashboards.processChange(this.name);}
    };

    The reason of the usage of a SQL query is that i need to have an element in the list that say 'ALL...'.
    If anybody knows how to make the sql query working with the select component it would be awesome!
    Thanks
    Richad

  2. #2

    Default

    I solved my problem....
    Actually, the file in cdf/component with the extension .xaction.sql don't work well I guess...
    To make it work just uncomment the sql part in the regular files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.