Foren
A table report portlet template based on a single SQL statement
Shawn Li, geändert vor 11 Jahren.
A table report portlet template based on a single SQL statement
New Member Beiträge: 8 Beitrittsdatum: 02.02.13 Neueste Beiträge
A single SQL statement actually gives you all the information to create a full-fledged web portlet for a simple table report:
(1) Number of rows.
(2) Number of columns
(3) Column names
Based on XSLT and JSP, I created a table report portlet template based on a single SQL statement.
This is a simple SQL statement running on MySql:
This is a simple table report portlet built within 5 minutes on the template:
This is the xslt style sheet which is built automatically by the template sysytem. You can do further modification for your own need.
(1) Number of rows.
(2) Number of columns
(3) Column names
Based on XSLT and JSP, I created a table report portlet template based on a single SQL statement.
This is a simple SQL statement running on MySql:
This is a simple table report portlet built within 5 minutes on the template:
This is the xslt style sheet which is built automatically by the template sysytem. You can do further modification for your own need.
Hitoshi Ozawa, geändert vor 11 Jahren.
RE: A table report portlet template based on a single SQL statement
Liferay Legend Beiträge: 7942 Beitrittsdatum: 24.03.10 Neueste Beiträge
Are you going to make your portlet available?
David Ilechukwu, geändert vor 11 Jahren.
RE: A table report portlet template based on a single SQL statement
Regular Member Beiträge: 154 Beitrittsdatum: 07.06.10 Neueste Beiträge
Sounds interesting Shawn!
Have you tried running your report with data in one of the rows not containing anythings (is equal to NULL)?
Please keep us posted on how this turns out.
Cheers
Have you tried running your report with data in one of the rows not containing anythings (is equal to NULL)?
Please keep us posted on how this turns out.
Cheers