Hi List,
I’ve come across something weird and wondered if anyone could help.
I’m creating a new SQL view. The query:
select * from TRO_ORDERS where DATE_FROM <= %from_date% and (DATE_TO >= %to_date% or DATE_TO is null)
With the “SQL view parameters” filled in correctly, I then press “refresh” for it to load the attributes, but I get an Oracle error:
“ORA-00942: table or view does not exist”
However that table does exist. If I take the SQL generated from the logs and put it directly into SQL Developer, it works fine with no error but I get no results.
The SQL from the logs is:
select * from (select * from TRO_ORDERS where DATE_FROM <= 20130102 and (DATE_TO >= 20130102 or DATE_TO is null)) VTABLE where 1 = 0
If I trim this down (removing the stuff that GeoServe rappears to have added) to:
select * from TRO_ORDERS where DATE_FROM <= 20100102 and (DATE_TO >= 20100102 or DATE_TO is null)
That works and does return results.
Can anyone advise what’s going on? GeoServer can add the TRO_ORDERS layer just fine as a regular layer, so I’m not sure why it is having issues as a SQL View.
I’ve had a similar SQL view working previously too, so I know it can work.
Thanks,
Jonathan
This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
