Is it possible to pull data dynamically from schema in webapp?

[bhaskarc1289447]

We have a webapp. We need to pull the data dynamically to populate a drop-down. The data may be huge (500k rows). So is it possible to populate it dynamically in webapp? We cannot do query in javascript to pull data and preload the dropdown in webapp since the data is huge. Can we use something like ajax in webapp to pull data dynamically from DB to webapp?

[_Manoj_Kumar_ · Accepted solution]

Hello @bhaskarc1289447 

You can achieve it by adding your querying logic to jssp page. Here is a simple way to do it

1. Create a JSSP page and add your query def code with a dynamic where condition.
2. Return your querydef output as json data.
3. In your webapp, you can add select2 and pass the user input as a query string and pull data from the jssp using the parameter.

Link to an example on How to query data dynamically with jssp page and return json response

https://blog.floriancourgey.com/2018/11/create-jssp-dynamic-javascript-server-page-in-acc/