Hi All,
I have a case where Users will pass some Id parameter say batch Ids upto 4k or 40k and we need to query all the data for the inputs from one particular view. In older version like 17.1 we used this executesqlquery() function which is available in sqlexpressions plugin to fetch all data. Since this plugin is deprecated now we include a stored procedure that will query data dynamically. But for few data like upto 1000. It works fine. But it seems to have certain character limit to be passed as a input parameter. If we cross it, stored procedure is not accepting those values. We are getting null values. If anyone knows any replacement or ideas on how to proceed with this it will be helpful.
Thanks & Regards,
Kavya
Discussion posts and replies are publicly visible
I think you need to re-design your solution here if possible. In my opinion to pass the input of 40K is not a good idea. Retrieve the data by breaking the inputs in smaller batches.