Foren

Home » Liferay Portal » English » 3. Development

Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
Shawn Li
A table report portlet template based on a single SQL statement
1. Februar 2013 20:13
Antwort

Shawn Li

Rang: New Member

Nachrichten: 8

Eintrittsdatum: 1. Februar 2013

Neue 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.

Hitoshi Ozawa
RE: A table report portlet template based on a single SQL statement
2. Februar 2013 03:41
Antwort

Hitoshi Ozawa

Rang: Liferay Legend

Nachrichten: 7990

Eintrittsdatum: 23. März 2010

Neue Beiträge

Are you going to make your portlet available?
David Ilechukwu
RE: A table report portlet template based on a single SQL statement
2. Februar 2013 16:47
Antwort

David Ilechukwu

Rang: Regular Member

Nachrichten: 114

Eintrittsdatum: 7. Juni 2010

Neue 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