AnsweredAssumed Answered

GEL Query:How do you use a > Greater Than?

Question asked by Lowell on Nov 29, 2011
Latest reply on Jul 25, 2018 by Mohan.K
I am trying to use a ">" character in the query. I have replaced it with > and get the same error. Any ideas on how to do a "Greater Than"?


<sql:query var="sdivid_duplicate_count">
select count(E1.divid) as dup1 from
(select count(C1.divid) Duplicate, C1.sdivid from
(select distinct O1.divid, O1.sdivid from trg_dep_obs_stage O1) C1 group by C1.sdivid) D1,
trg_dep_obs_stage E1
where D1.sdivid = E1.sdivid
and D1.duplicate > 1;
</sql:query>

I get the error:

BPM-0704: An error occurred while executing custom script: org.apache.commons.jelly.JellyTagException: null:21:53: <sql:query> select count(E1.divid) as dup1 from (select count(C1.divid) Duplicate, C1.sdivid from (select distinct O1.divid, O1.sdivid from trg_dep_obs_stage O1) C1 group by C1.sdivid) D1, trg_dep_obs_stage E1 where D1.sdivid = E1.sdivid and D1.duplicate &gt; 1: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00920: invalid relational operator at org.apache.commons.jelly.tags.sql.QueryTag.doTag(QueryTag.java:194) at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:247)

Outcomes