Hi, There is a table having 2lakh + records, by using this table I want to

anilkumark over 8 years ago

Hi,
There is a table having 2lakh + records, by using this table I want to implement search functionality. There are about 10 text fields, based up on the inputs I want to generate the grid. Can any one help me how to implement this search functionality.

Thanks!

Discussion posts and replies are publicly visible

Parents

0 ashish.deshmukh
A Score Level 1
over 8 years ago

As suggested by lakshmim, you can implement it using Appian default functions and you can use Appian recipes for reference. Along with that you can have a look at the Appian suggested best practices to handle large amount of data, below link explains it in detailed manner
forum.appian.com/.../Database_Performance_Best_Practices.html

Further you can take a look at the below documentation which explains various ways to fetch data from DB and the pros/cons of each.
forum.appian.com/.../Querying_Data_From_an_RDBMS.html

Hope this is helpful.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashish.deshmukh
A Score Level 1
over 8 years ago

As suggested by lakshmim, you can implement it using Appian default functions and you can use Appian recipes for reference. Along with that you can have a look at the Appian suggested best practices to handle large amount of data, below link explains it in detailed manner
forum.appian.com/.../Database_Performance_Best_Practices.html

Further you can take a look at the below documentation which explains various ways to fetch data from DB and the pros/cons of each.
forum.appian.com/.../Querying_Data_From_an_RDBMS.html

Hope this is helpful.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data