Steve Giller

This sounds like you need separate reports for each of these "Summary Contains" criteria. You can group by a column in SQL, but not in a portion of the data contained within a column.

I'm fairly sure there isn't a "Create New Report" button in Service Manager In-App Reporting. What are you expecting to see and where?

The setting asset.form.tags.addNew determines whether tags can be created by simply typing a new word into the "Tags" field on an Asset. The Asset Tags option from the 3-dots menu on the Asset Management page will allow a User with the Asset Management Admin Role to add, remove, and edit Asset Tags.

If you configure the scripts correctly, probably separating out the Create script from the Update script, you can have different Roles for a newly created User and an Updated User. If you make the scripts more granular you can update based on Group Membership (or any searchable LDAP parameter) by using precise LDAP queries in the import, so an Employees moving Job Roles will have their Hornbill privileges updated to match as long as you update AD accordingly.

What are you using to import from AD?

You can only view your own Tasks, or the Tasks of a User you manage, this is reflected in the list available to the Owner filter.

I can't help from experience, nor have I seen the Microsoft API for this, but I would imagine it's difficult to create a Calendar Event without specifying which Calendar you wish to place it on.

It was removed in the context of "Never say never" but as the Request List view is, by design, intended for active Requests we cannot make any assurances.

@Berto2002 Done (I hadn't spotted that as I rarely read the actual titles!)

@Alisha You're in the right area with String Utilities, but you need the Regex Substring option. As for the Regex Expressions to use - everyone hates Regex so you may be on your own there.

That would be correct, the result is the index of the match: I can't really explain where you're going wrong because you haven't said what you're trying to do.

Yes, no changes there for the time being.

Company Home is the default term - your Admins may have given it a different name. For:

@chriscorcoran The Customer Portal (note: this is for Contacts, not Users) is https://customer.hornbill.com/[INSTANCE_NAME] The Employee Portal (note: this is now for both Full and Basic Users) is https://live.hornbill.com/[INSTANCE_NAME] Signing in via will take you to your Default View, set by clicking your Icon in the top right corner as shown above. Selecting Company Home will take you to the Co-Worker's view of the Employee Portal, rather than the Request List. The link provided above of https://live.hornbill.com/[INSTANCE_NAME]/servicemanager/ is not a complete URL and will probably show a 404 page.

The page you (and other Users) are landing could simply be due to the Default View setting:

Hi @Adrian Simpkins I didn't spot this post - as far as I'm aware the system should work its way through the backlog in chunks. If you see the number stop reducing please let us know, but I imagine you'll have a good idea of whether this is processing as expected by this stage.

We have also seen some issues delivering to Customers with Exchange Online mailboxes, these seem to have cleared up now - are you still seeing issues or are things back to normal?

@Salma Sarwar Aside from what it says - that there's an invalid character in the data - I don't have anything more to offer, I'm afraid.

@YemsChas There are no immediate plans to add that functionality to the mobile App, unfortunately. It is on the list for a future update, but there are no timescales for this particular change.

The maximum number of rows for this is governed by the api.xmlmc.queryExec.maxResultsAllowed setting, and has a default of 1,000 and a maximum of 25,000 as you correctly stated.

@Alisha Advanced Request Task Completer is a right that sits within a Role, not a Role in itself. The name is also accurate - it allow completion of Request Tasks - it does not affect assignment of Tasks. There is a section on reassignment on the Tasks wiki page which details the rules around this. Rule 1 is, basically, ensure the Task has an Owner.

@samwoo The entity APIs are designed to be transactional and not for bulk data exports (they don't properly support pagination for a start, and are not optimised for use in this way...), so I expect that changes won't be made here as they serve their designed purpose. The recommended implementation of this should be to not use the data::entityXYZ APIs for this, but to write the appropriate reports in Hornbill to return the required data, then use the reporting service APIs to run the report and download & import the content into Power BI when the report run is complete.

An alternative/addition would be to have some text similar to "Please view the Request on [link] for full details" and use an ESP condition to hide the variable if it's empty in the template.

MariaDB has a SEC_TO_TIME() function that may assist here.

I'm aware that the errors and the way they are presented to the Users is an area that is under review. I don't think it's a priority at the moment so I have nothing to offer on timescales, but this is something that will be improved in a future update.