Can you pass data directly into a table (no query)

[al881]

I have a query that takes some time. This query pulls back data (groups) etc.

I then have a table. I want to pass some of the data to the table and display it. 

(I do not want to pass params into the tables dataset, since i can do this)

But I want the data to display from the previous query. The tables dataset will be a dummy query.

Here is an example:

select names from table where dates = xxxxxx group by names.

Then I want to display those names on the table.

Regards and thanks

 

 

[hozawa]

If you're using a database, how are you planning to extract data from it without a query. You may try using Beans as a datasource but you'll still have to have a query to extract data from the database to fill the Beans. If't a query is taking long time, a better alternative is to tune your database table such as adding indexes.

[al881]

My point was about redundant SQL calls. The main one and the tables dataset are identical. I want to pass the data from the first query to the table.

 

I found an example but doesn't seem to work.