Jump to content
We've recently updated our Privacy Statement, available here ×

jean.sebastien.lemay

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Posts posted by jean.sebastien.lemay

  1. I'm really struggling to get my query to work against my PostgreSQL database. Essentially, my query can be delimited by a timestamp, a parameter that the user can input, but which can also be empty. If no timestamp is provided, I must tell PostgreSQL to use '-infinity' instead. I tried writing the conditional statement below, but I get the error 'Could not determine data type of parameter $1' Can anyone tell me what's wrong with my query?

    SELECT *FROM logWHERE CASE  WHEN $P{timestampFrom} IS NULL THEN timestamp >= '-infinity'  ELSE timestamp >= $P{timestampFrom}  END[/code]

    $P{timestampFrom} is a sql.Timestamp parameter.

×
×
  • Create New...