How Appian Query Entity works with SQL View?

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