Jump to content

jean.sebastien.lemay

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

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...