mojahidm

+1 from us as well :-) Mojahid

Thank you for the info @Martyn Houghton Mojahid

Hi, We work with external customers quite significantly. During one of our meetings it was raised as a possible improvement for the Hornbill app to be associated to our customer portal. We would like our customers to be able to add, update and follow their requests, check FAQs and get information about service statuses. Is this something that you would be interested in progressing? If not, is there anything blocking us from doing it on our own? kind regards, Mojahid

Hi @Victor Looks like the culprit was the 'Select Ordering' tab. I needed to select 'Within Resolve Time' instead of 'Priority Name' Thank you for all your help I've no doubt I'll be back posting another thread when I try to do my next report Mojahid

Hi @Victor, what details were you after? Would it be the definition file? Or clarification of the issue...? With the report - I needed to be able to view the priority and how many incidents met the SLA and how many didn't. From the SQL I ran, I thought there would be another row for Priority 3 that stated 'Breached' or a '0' as it has a '0' in the within fix column. Second row in the screenshot below: The count is correct and I have four showing for priority 3 and two showing for priority 2, but it's not displaying the within fix as I expected. kind regards, Mojahid

Hi @Victor Thank you for the help. The report appears to work . I've just been going through the data to make sure it's what I expect. I'm still struggling with the Within Resolve/Fix column... I was expecting to see a priority 3 that breached: The sql I used to get this result was: SELECT * FROM h_itsm_requests AS hir JOIN h_sys_contact AS hsc ON hir.h_fk_user_id = hsc.h_pk_id AND hsc.h_company = 'UK_Review' AND hir.h_requesttype = 'Incident' AND hir.h_datelogged >= '18/03/01' Kind regards, Mojahid

Hi @Victor Unfortunately didn't work: I got the above error Kind regards, Mojahid

Hi @Victor I noticed the same thing when I checked out the result list - the last two are SRs kind regards, Mojahid

Another side note: I've recreated the report and it works fine. Like you said the report appears to have been corrupted (not sure why) Happy for this thread to be closed :-) Kind regards, Mojahid

Hi team, I'm trying to create a report where I will enter in a date range and a list of orgnizations (from a previously made simple list). From this, I would want the organization name, the priority name and the within fix I have named the report: Sandbox Official 2.Incidents Resolved Count Ver5 - Date and Org with Priority/Fix The issue I have is that no data is being returned. Please see following report construction: FILTERS: 1. REQUEST TYPE WILL BE INCIDENT: 2. DATE PROMPT FOR RESOLVED DATE 3. ORGANIZATION PROMPT SELECT ORDERING DATA PREVIEW I have run the following code in the database direct and can see that there should be data here: SELECT * FROM h_itsm_requests AS his JOIN h_sys_organizations AS hso ON his.h_org_id = hso.h_organization_id WHERE hso.h_organization_name = 'UK_Review' Any help would be much appreciated Kind regards, Mojahid

Hi @Bob Dickinson I've started to look at reports again. Taking 'Sandbox Official 1.Incidents logged Count Ver2 - Date and Org Works' as an example - the report itself is working fine. I can run it and I'm getting the data that I expected. However, when I make a change to it, the save button stays greyed out. I was hoping that the issue would resolve itself over time, but it doesn't appear to have done so Mojahid

Side Note: I am able to get data, when I go to Data Collection > Data Preview Mojahid

Hi @Bob Dickinson I attempted to duplicate one of the reports. As soon as I add the h_itsm_priority table, the save button greys out. It looks like it might be the way I'm joining the tables, as when I tried a join with h_itsm_requests and h_sys_organizations on the Organization ID - the save button wasn't greyed out anymore I'll keep digging :-)

I did notice one other thing just now. There is a report that I can amend and save. However, when I go out of it and try to amend a different report, the save button on the different report stays greyed out... Could it be that the report is currently locked for me to work with and not letting me work on another one? I tend to click on the breadcrumb menu 'Reports' to go out of the report itself: Also, when I go into this specific report, BEFORE I make any changes, the save button isn't greyed out: Mojahid

Hi, I'm having a weird issue when I try to save a report I do the following: 1. Go into a report: 2. Amend text in description (or anything at all) but the save button stays greyed out... Side Notes: - I am the owner of the report - I'm logged in as mojahid.miah - The report was a copy of an existing report - I have logged out and then back in - I've closed all my browser windows - cleared my history and tried again - The only way I can currently save the amended report is to use the drop down arrow and select 'Save as' - I go into any of my other reports and I now have the same issue, where I can't save any of them - I've tried a different browser (Usually use Chrome - tried Firefox) Not sure why this is happening but it's happened before. I went back to reports a few days later and it started allowing me to save again Mojahid

Thank you for the update @alextumber. It helps manage expectations :-) Mojahid

Hi @alextumber, was there any further update with regards to this? Mojahid

Hi @alextumber, yes that is exactly what we are after Mojahid

Hi, I'm newly dipping my toes into the Project Module to see if it is viable for our Projects and Implementations team. One of the key aspects that they currently use is a discussion thread, where co-workers and contacts can post to. I can see the above exists for Project Stakeholders to be able to utilise, but is there a way for contacts to do so as well? The closest I could find anything for, was the below: but the option to add a contact isn't present... Side Note: We use Hornbill predominantly for external companies

+1

+1

+1 from me also. I've gotten complaints about this when we ran through it with our UK team :-( As you can imagine, we want to make the logging process as painless as possible for our external customers so that they will utilise it, thereby improving our efficiency :-) Many Thanks

Hi @James Ainsworth Same for us. This is essential for us. We are planning to delay GO-LIVE for one of our teams, based on this. Many thanks :-)

+1

+1