Hi Tony, i dont think there is a quick work around. i guess, what you can do is to write your own formatter very similar to existing TSV, CSV or HTML ones, and within that, split the query into multiple queries each containing fewer than 1K values, execute, compile and then stream them back.
Syed On 25 September 2012 21:04, Tony R Miqueli <[email protected]>wrote: > I have a Filter setup as 'upload' that needs to accept over 1000 values > in some cases. When the query runs we get an exception from Oracle because > the max number of values allowed in a SQL 'IN' statement is 1000. > > Does anyone know of a workaround for this? > > Thank you all so much in advance! > > T > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
