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

Question

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 Answer

Hello @bhaskarc1289447

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

Create a JSSP page and add your query def code with a dynamic where condition.
Return your querydef output as json data.
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/

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded