Prathmesh Patel Posted January 29, 2018 Share Posted January 29, 2018 Hi, is there way a widget can be created to show the change calendar? then to be shown on the dashboard? Link to comment Share on other sites More sharing options...
Dan Munns Posted January 29, 2018 Share Posted January 29, 2018 Following for info +1 to be added if not currently possible. Link to comment Share on other sites More sharing options...
dwalby Posted January 29, 2018 Share Posted January 29, 2018 +1 for this also Link to comment Share on other sites More sharing options...
Conor Posted January 29, 2018 Share Posted January 29, 2018 Hi @Prathmesh Patel Firstly I have an example (below) of a widget that can be created to show the scheduled changes for the next 30 days, but in terms of getting the actual LIVE change calendar into a dashboard I'm not sure that is possible due to system rights and authentication, etc. I have seen a custom widget added with a screenshot of this months change calendar which works fine. The only thing is that the screenshot needs to be updated each month or each time the data changes. The Change calendar respects the rights of the user logging in to see it, so an IT person wouldn't be able to see changes for HR or any other department that they don't normally have the rights to see. As soon as it is put on a dashboard potentially anybody can see it, and it may go against pre set rights in the application. I'm not part of the development team for Service Manager so I may be wrong but I would think that is why it is not a standard feature. Anyway as I mentioned to display a list of data widget with a custom SQL query this is roughly the query required to show the upcoming changes over the next 30 days based on the scheduled date: select h_pk_reference, h_summary, h_ownerid, h_itsm_changerequests.h_start_time, h_itsm_changerequests.h_end_time from h_itsm_requests inner Join h_itsm_changerequests on h_pk_reference=h_fk_reference where h_requesttype='Change Request' and h_status='status.open' AND h_itsm_changerequests.h_start_time >= CURDATE() + INTERVAL 1 DAY AND h_itsm_changerequests.h_start_time < CURDATE() + INTERVAL 30 DAY limit 10 Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 31, 2018 Share Posted January 31, 2018 @Prathmesh Patel as Conor says there is no current way to display the change calendar on the dashboards, we have a story in our backlog to look at options for this and as it progresses we will update here. I have added all interested parties to this story Link to comment Share on other sites More sharing options...
Prathmesh Patel Posted January 31, 2018 Author Share Posted January 31, 2018 thank you Link to comment Share on other sites More sharing options...
dwalby Posted May 16, 2018 Share Posted May 16, 2018 @conorh - I've attempted to use your custom SQL query but it doesn't appear to return any results (the headers show). Please can you confirm that the SQL query is correct? Link to comment Share on other sites More sharing options...
Conor Posted May 21, 2018 Share Posted May 21, 2018 On 5/16/2018 at 3:16 PM, dwalby said: @conorh - I've attempted to use your custom SQL query but it doesn't appear to return any results (the headers show). Please can you confirm that the SQL query is correct? Hi @dwalby I have just tested the query and can confirm that it is correct. It is based on the start time that a change has been scheduled for so will only show once a change has been scheduled, and will show any changes that are scheduled to start from tomorrow until 30 days from now. Can you confirm that there are scheduled changes in your instance that are due to start in the next 30 days? Thanks Conor Link to comment Share on other sites More sharing options...
dwalby Posted May 21, 2018 Share Posted May 21, 2018 @conorh - You're right, my fault. Rather rarely we didn't have any scheduled changes at the time I looked at it. They're appearing now. Thanks for your help. Link to comment Share on other sites More sharing options...
dwalby Posted May 21, 2018 Share Posted May 21, 2018 @conorh is there a way of displaying the results in a grid, or at least scaling them so they all appear on one line? Currently when there's only 1 change scheduled for example the text is enlarged and wraps the text. Link to comment Share on other sites More sharing options...
Conor Posted May 22, 2018 Share Posted May 22, 2018 @dwalby It doesn't appear to be possible at the moment. I have the same, and on that type of widget the general look and feel tab mainly relates to the box itself rather than the content. I will have a chat with the designers to get their thoughts. One option is to set the height at 20%. In fact playing with the preview width and preview height options seems to help, 75% width and 33% height seems to get everything on the same line for me. I will have a chat with the designers as I say to see if we can help with this. Link to comment Share on other sites More sharing options...
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