Hi All,
I have created a CDT using Database View. Assume that the view is returning 10000 rows in DB. I have a rule with query entity with filter and a paging with batch size 10.
Will Appian pulls all 10000 records first and applies filter/batch?
OR
It applies filter and only pulls 10 records?
How the query works in Appian side?
Thanks,
Varsha
Discussion posts and replies are publicly visible
Hi,
Appian first apply filter in the view and pull the record based on the batchSize.
Thanks
Vinay