Question

How to consume the batched data ?

Forum|Forum|3 years ago
July 7, 2023
3 replies
0 views

Hi All,

I have written the expression rule to fetch data from the tables and I have given batch size = 50.

Now I want to know what' the right way to consume the data so that I can get everything based on the given filters. As it would contain data more than 50 rows so how can I consume the data properly ?

Any example process models will really be helpful.

Thanks

stefanhelzle0001

Brainy

You cannot load "everything" into Appian. It will break sooner or later. Please try to explain, in detail, what you want to achieve, and we might be able to come up with ideas.

S

sourabhs2166Author

for example i have some processIds for which I have to fetch the data and we are fetching these processIds from DB table. now for fetching processIds I am using expression rule, and expression rule is having batch size of 50. now what I want is to fetch all the processIds and get the required data from somewhere else. so how can I make sure that I have checked for all the processIds not only for 50 processIds.
let me know if I am still not very clear.

stefanhelzle0001

Brainy

It is very clear what you try to do. And depending on the data volume, it will break sooner or later.

First, you need to identify the total number of items to fetch. Then you can divide that number by 50 to get the number of iterations to make. Then use a foreach to fetch the data.

Sign up

Login with SSO

Login to the community

Login with SSO