Query Database Smart Service: Hi All, I was using that query DB

rishub356 over 8 years ago

Query Database Smart Service:

Hi All,
I was using that query DB & it returns at max 10 rows only. I need to use the query DB node in my process model & I wanted to fetch may be 200 or 300 records at a time. I can't use batches of 10 & was wondering if there is something we can do to get more records in Query DB node?

Thanks

Discussion posts and replies are publicly visible

Parents

0 ChristineH
Certified Lead Developer
over 8 years ago

This is the default setting for the query DB node:
forum.appian.com/.../Query_Database_Smart_Service.html.
You can change the property (forum.appian.com/.../Configuring_Relational_Databases.html) with care! Keep in mind, the more data you return in a process the larger your footprint is and the more memory you consume!

Can you use a query rule instead?

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

This is the default setting for the query DB node:
forum.appian.com/.../Query_Database_Smart_Service.html.
You can change the property (forum.appian.com/.../Configuring_Relational_Databases.html) with care! Keep in mind, the more data you return in a process the larger your footprint is and the more memory you consume!

Can you use a query rule instead?

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data