Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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/

 

View solution in original post

0 Replies

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/