Issues with Creating Query (Postgres DB)

Ignition
,
1

I am trying to create a simple named query from a Postgres DB and I keep getting an error:

GatewayException: java.sql.SQLException: Unknown SQL type: 2003
caused by Exception: java.sql.SQLException: Unknown SQL type: 2003

===================Query======================================
select id, lastmodified, time, measuringlocation, userequationresults, morphologytype, uts, oxygen, siequivalent from thermalanalyses where measuringlocation= :measuringloc
order by lastmodified desc

is there a solution or workaround for this issue?

2

Tidied up query.

SELECT 
    id, 
    lastmodified, 
    time, 
    measuringlocation, 
    userequationresults, 
    morphologytype, 
    uts, 
    oxygen, 
    siequivalent 
FROM thermalanalyses 
WHERE measuringlocation = :measuringloc
ORDER BY lastmodified DESC

Answered a month before you asked:

1 Like