Im trying to bold some text in my sql results but so far the only html tag the k1000 seems to allow is <br>.  Everything else like <b></b> get the greater and less then symbols replaced.  Is there a way to use bold or other html tags in reports?   For example, the bold here doesnt work but the new lines work.

select HD_TICKET.ID,
       HD_TICKET.TITLE ,
       HD_TICKET.RESOLUTION ,
              DATE_FORMAT(HD_TICKET.TIME_CLOSED, '%m-%d %H:%i') as TIME_CLOSED,
       ifnull((select FULL_NAME from USER where HD_TICKET.OWNER_ID = USER.ID),' Unassigned') as OWNER_NAME,
       (select FULL_NAME from USER where HD_TICKET.SUBMITTER_ID = USER.ID) as SUBMITTER_NAME,
GROUP_CONCAT('<b> *** ',HD_TICKET_CHANGE.TIMESTAMP,' *** </b><br>','Edited by:',(select FULL_NAME from USER where HD_TICKET_CHANGE.USER_ID= USER.ID) ,'<br>',HD_TICKET_CHANGE.COMMENT,'<br>' SEPARATOR '<br>') as Comments
from HD_TICKET
left join HD_STATUS on HD_STATUS_ID = HD_STATUS.ID
left join HD_PRIORITY on HD_PRIORITY_ID = HD_PRIORITY.ID
left join HD_IMPACT on HD_IMPACT_ID = HD_IMPACT.ID
left join MACHINE on HD_TICKET.MACHINE_ID = MACHINE.ID
left join HD_TICKET_CHANGE on HD_TICKET_CHANGE.HD_TICKET_ID=HD_TICKET.ID and HD_TICKET_CHANGE.COMMENT is not null and NOT HD_TICKET_CHANGE.COMMENT=''
where HD_STATUS.STATE = 'closed' and HD_TICKET.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 1 DAY)
group by ID
order by OWNER_NAME, HD_PRIORITY.ORDINAL, HD_STATUS.ORDINAL, HD_IMPACT.ORDINAL

1 Comment   [ + ] Show Comment

Comments

  • That's clever. I never thought to put HTML tags in a report like that. This might be something you need to contact support for and find out what they say.
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share