SID-01179: Change the display format of data from database

Status:	Unanswered	TWiki version:	5.0.1	Perl version:
Category:	DatabasePlugin	Server OS:	RedHat Linux 7.5	Last update:	14 years ago

Hi support,

I am wondering is there a way I can change the display format of my sql query result? Or can I choose to use my own css class to display the output.

For example: I have page like below:

%DATABASE_SQL{description="user@database" sql="select job_id, start_time, finish_time, time_used from job_logs" format="|$JOB_ID|$START_TIME|$FINISH_TIME|$TIME_USED|" header="|*job* |*start* |*finish* |*time used* |"}%

I want to use my own table template to display the output instead of the default one provided by twiki. Or if I want to change let's say the first column align center and last column align right. Or I want to change the border weight of the table, is there a way I can do this on a sql generated table?

Thanks very much.

Best regards, Can

-- CanLu - 2011-05-18

Discussion and Answer

Further to my above question, is it possible to conditional format the sql output? For example we have a sql pulling the data from intra-day jobs running logs table. My users want me to highlight the rows where running status is false, i.e. change the row font color to red. Appreciate any thought you may have on it.

-- CanLu - 2011-05-18

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- PeterThoeny - 2011-07-08

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.