Hi Team,
I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data...
Thanks and Regards,
Vigneshkumar Radhakrishnan
Discussion posts and replies are publicly visible
Hi ,
You may create a stored procedure and create an expression rule to fetch that data using executeStoredProcedure function.Thank You.
And may you please provide some more details that how you are using that data?I mean, in a grid, and so on?
Hi Ravi, Im trying to use large amount of Number(Integer) from table and trying to access in process model. Can you please share more about stored procedure and executeStoredProcedure function?
May you please provide some more details that how you are using that data in the process model and why you need whole data at once?And also you may try again that query by apply selection on it (only keep those fields/columns that you need in the process).Thank You.
And talking about stored procedure, so in stored process you can join the tables and pass parameters for filtering and all.And call that stored procedure in Process model also with smart service or function.Thank you.