Michael Taylor Posted September 8, 2017 Posted September 8, 2017 Hi, How do you get a link to display in custom sql in widgets ... which are then used in dashboards? I've the following sql, but it just displays the text SELECT h1.h_linked_entity_id AS category, h3.h_summary AS cat_summary, CONCAT('<a href=''https://live.hornbill.com/bits/servicemanager/request/view/',h2.h_pk_reference,'/''>',h2.h_pk_reference,'</a>') AS ticket_number, h2.h_summary AS ticket_summary, DATE_FORMAT (h2.h_datelogged, '%Y-%m-%d') AS LOGGED_DATE, IFNULL(h2.h_fk_user_name,'USER LEFT') AS customer FROM h_sm_relationship_entities h1, h_itsm_requests h2, h_itsm_requests h3 WHERE h1.h_entity_id = h2.h_pk_reference AND h1.h_linked_entity_id = h3.h_pk_reference AND h2.h_status = 'status.open' AND h2.h_ownerid = 'some_user@an_email_address.com' AND h2.h_pk_reference LIKE 'IN%' ORDER BY h1.h_linked_entity_id ASC, h2.h_pk_reference ASC Cheers Michael
TrevorKillick Posted September 8, 2017 Posted September 8, 2017 @Michael Taylor Can you post a screen shot of the widget you are trying to get a link to work in and are their any other types of widget you would want to have links available. Currently its not possible i can check with development to see if its something that could be catered for. Kind Regards Trevor Killick
Michael Taylor Posted September 8, 2017 Author Posted September 8, 2017 Here you go. Current requirement is to put a link around the ticket number column. Being able to use style tags would be helpful too. 1
TrevorKillick Posted September 8, 2017 Posted September 8, 2017 Thanks for that i will feed this back into development and let you know of any outcomes. Kind Regards Trevor Killick
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now