Steve Giller

@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.

I can't comment on the technical side, but in practical terms the image will appear in the timeline, and if there is no accompanying text then the contents of {{RequestLastActivity.H_content}} will be empty. I don't think there's any reliable option to guarantee text content - images can be pasted so even a filename for the image isn't a given.

That may depend on where in the product you're producing the report, could you give some specifics, please?

I'm not sure what you mean by "node" so could you clarify where the update is being made, and by whom or what (if it's a Business Process , for example) please?

You're never going to get any results. You're joining h_sys_tasks to itself, and matching a Request URN to a Task ID I'm assuming that you're needing a Request ID which would be in h_itsm_requests

Based on: the table you require is h_sys_user_profiles If you need attributes of a User Account it's h_sys_accounts

I've seen this enhancement request before:

Application is a Mandatory field - this will need populating with the Application that the Board belongs to.

@Salma Sarwar The latest version has just been released, this now caters for local files on a network share, e.g. , "Image":{ "Action":"Both" , "UploadType": "LOCAL" , "InsecureSkipVerify": false , "ImageType": "jpg" , "URI": "\\\\server\\folder1\\folder2\\{{.emailaddress}}.jpg" } The Wiki has been updated, with the new UploadType of "LOCAL"

It will do that in the editor, what does it look like to the recipient? Also - do bear in mind that you have no control over what the recipient uses to view the email. They may be using anything from Outlook to a web client to a plain-text viewer and not all email clients will support what you're doing.

It's the cog icon bottom left. It is possible you don't have the required Role(s) - if you can't access it you will need to speak to an Administrator for your Instance, maybe Paul?

In your Instance, navigate to: Admin -> Hornbill Solution Center -> Roadmap Library I can't link you directly as I don't have access to your Instance.

Current enhancements are listed under Admin -> Hornbill Solution Center -> Roadmap Library If there are no responses to this thread or updates on the Library boards then there is currently nothing to report.

We're aware of an issue that prevents the Save button from activating when changes are made. I'll update this thread when we have further details.

The h_class field holds the values for Full (1) or Basic (3) Users

Having checked with the Developers I have to report that currently the SQL User Import does not support local files for the image. However we are investigating if this can be provided, and will update this thread shortly.

Without the full logs it's tricky to diagnose, but for Active Directory LDAP Response 49 with a code 52e is Invalid Credentials - this would suggest that the Credentials stored in your KeySafe for accessing Active Directory have expired, this is usually due to a password change.

You could try with: DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 220 DAY), INTERVAL 220 DAY) but I can't be sure that would work, I'm not sure how happy SQL is with nested functions. Also, depending on the WHERE clause, that may just return the last 440 days. Update: BETWEEN DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 220 DAY), INTERVAL 220 DAY)AND DATE_SUB(CURDATE(), INTERVAL 220 DAY) would be from -440 days to -220 days, I believe, but do get someone more familiar with SQL to check first.

Did you change the JSON to use the mapped drive? For example: "URI": "Q:\folder1\folder2\{{.emailaddress}}.jpg"

The wiki states for the Upload Type parameter: "UploadType": "URL" /* options : URI/URL ; local (network) drive or HTTP(S) served image */ but the URI you provide is a UNC path, which is not the same thing. If you map the Fileshare to a local drive letter does that allow you to download the image? Alternatively, the File URI scheme may work, so something like: "URI": "file:\\\\fileshare\\folder1\\folder2\\{{.emailaddress}}.jpg"

This is in progress, I believe the estimate is 2-3 Service Manager releases away, but all subject to development going smoothly.

This is optional, and is available to ensure that the results have a unique reference, as this node only has an "outcome" it is not required.