Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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/

 


     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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/

 


     Manoj
     Find me on LinkedIn