Replacement for sqlexpressions plugin having executesqlquery() function

Certified Senior Developer

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

Parents Reply Children
No Data