/build/static/layout/Breadcrumb_cap_w.png

what html tags can be used in k1000 reports?

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
  • 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. - chucksteel 10 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ