How Appian Query Entity works with SQL View?

Varsha K R over 5 years ago

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?

It applies filter and only pulls 10 records?

How the query works in Appian side?

Thanks,

Varsha

Discussion posts and replies are publicly visible

Top Replies

josep over 5 years ago +2

Help Varsha, Internally the query entity is creating a query before hiting the database. So if you explicitly request the paging info(1,-1) <- where batcsize as -1 means “bring everything”, internally…
Vinay Katta over 4 years ago in reply to josep +1
Certified Senior Developer

Hi josep, Does this mean if we navigate paging for paging grid 5 times to view 5 different pages, Appian will query database 5 times?
Peter Lewis over 4 years ago in reply to Vinay Katta +1
Appian Employee

Yes, that is correct. What actually happens when you click the next page button is that the start index is updated to 11 and the query is executed again with the new paging information. A new query is…

Parents

0 Vinay Kumar Rai over 5 years ago

Hi,

Appian first apply filter in the view and pull the record based on the batchSize.

Thanks

Vinay
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Vinay Kumar Rai over 5 years ago

Hi,

Appian first apply filter in the view and pull the record based on the batchSize.

Thanks

Vinay
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data