Populate Table component from SQL Server table

[Pieter3033]

Hi all,

Is it possible to fully populate the Table component with a external table, in this case SQL Server table.

I am not sure if I missed some information on the website or does SQLPage not support direct table population.

I have tried the traditional INSERT INTO method, but I don't see how the syntaxes will match.

Then I attempted to use a SELECT method as the input, but I then realized the row_level_parameter only accepts one value.
See below for reference:

I then attempted to use a while loop to populate one by one, with the discovery that I believe SQLPage does not have While loop support. /Please correct me if I'm wrong/
See below for reference:

[Pieter3033]

Now I realize that the above loop will create a table component for the ammounts of id's, but when I attempt to implement it inside of the row_level_parameter I can't see how the syntaxes will match

[lovasoa]

You are getting into very complicated things. You just need to select from your table directly.

select 'table' as component;
select Username from JC_User_Info;

That's all. That will populate the table component with a single column named Username and the values from the JC_User_Info table.

[lovasoa]

After opening the table component, you can make any arbitrarily complex SQL query, with joins, aggregate, subqueries, and anything you want, and the results will be displayed as a table in the browser.

[lovasoa]

The documentation needs to be self-contained, so it only gives very simple examples with select statements with static data and without a from clause, but you are not limited to this simplistic case when building your application.

You can have a look at the official repository of examples to see more realistic usage of the components, where data is queried from actual databases.

[Pieter3033]

Oh my...👀

Thank you for the assistance. It is appreciated.
I will definitely have to thoroughly examine the examples.