I am using GeoEvent server filter to filter envent data then i am getting ORA-01795 Error. T
Error: Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000:: OBJECTID IN ( 409156 , 409184 , 409185 , 409225 , 409226 , 409247 , 409268 , 409276 , 409279 , 409281 , 409289 , 409290 , 409294 , 409300 , 409308 , 409316 , …..)
You cannot have more than 1000 literals in an IN clause.
But there are alternatives see here: