Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: multiple values for select where in not working

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2006
    Posts
    7

    Default multiple values for select where in not working

    Hi,

    I'm trying to set up a report which select several records in a select with where in (${parameter}). To do that the parameters will be received as string and converted using CSVARRAY. Thats works and I can see that the parameters are passed to database query but I always get an error at postgres saying:

    ERROR: operator does not exist: bigint = character varying at character 6475
    HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

    The config is as follow:

    parameter1 is a string an receive the multiple value list coma separated: 1401,2270,2271,1886,1695,1799,1770,1666,1194,1190,1187,1183,1180,1143,1142,1129,1130

    parameter2 is defined as object, hidden, with postprocesing formula=CSVARRAY([parameter1];0;","

    At query definition we have:
    select bla,bla from tablename where id in (${parameter2})

    And when we run the report on the PRD gui to test it we always get the error:
    ERROR: operator does not exist: bigint = character varying at character 6475
    HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.


    Any ideas?

    Thanks!!

    Edit: We are using postgresql 9.5 and PRD 7.0.0.0-25
    Last edited by echacuen; 09-08-2017 at 07:29 PM.

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.