Jump to content

Gareth Cantrell

Hornbill Users
  • Posts

    160
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Gareth Cantrell

  1. @Steve Giller I was wondering specifically about the modifiers available in email templates.

    In the docs is states: 

    • {{.h_firstname|wiki}} = Allows HTML output from a template variable that contains wiki markup, Currently only basic formatting (Bold, Italic, Ordered & Unordered lists) are supported.

    Having links rendered would help when using a variable in the template such as: {{.h_description|wiki}} 

  2. Hi @Steve Giller

    To answer your questions:

    • These nodes were created from scratch (using "Add node between connected nodes")
    • The "Get Card/Site/Request" nodes occur at the start of the stage. Additionally, there is "Get Request Details" node immediately before the decision node in the previous screenshot above, and another "Get Site Details" a few nodes before that.
    • Yes, always the picker, for everything (and I just used it again to double-check all variables are correct)

    I should also note, that when the workflows fail, I change the "Update Card" node to a "Get Card Info" so that I can restart successfully and the Move Card works flawlessly - so I'm really unsure as to why the update card nodes fail.

  3. The content of the card is:

    &[global["flowcoderefs"]["getReqInformation"]["summary"]]
    
    '''Site''': &[global["flowcoderefs"]["getSiteInformation"]["siteCode"]]
    '''Risk''': &[global["flowcoderefs"]["getReqInformation"]["customFieldC"]]
    '''Service''': &[global["flowcoderefs"]["getReqInformation"]["catalogItem"]] (&[global["flowcoderefs"]["getReqInformation"]["service"]])

    customFieldC is one of the following values: Extreme, High, Medium, Low.

    There are nodes in the beginning of the stage that fetch Site Details and Request Details into getSiteInformation and getReqInformation respectively.

    There are 2 paths to update the card, depending on whether CustomC is set or not (if it's not set, we updated the card with customA (Critical, Major, Normal, Minor) and this is a required field in the capture:

    Screenshot2023-11-17at13_39_42.png.1f5851e0b7b03062d739709ebb9ab815.png

    I cannot see why updating the cards here would cause an error - the following node (Move Request) has always been there and uses the same CardId variable as 2 update nodes.

  4. Could we please ask that links be added to the |wiki modifier in email templates.

    For example, when raising linked requests, in certain cases we add the linked request as a link in the description using wiki markup e.g.: [[https://live.hornbill.com/...|SR00009999]] and this works fine in the request view.

    However, when rendered in the email notification, even with the |wiki modifier, it shows the markup rather than the rendered link.

  5. +1 and also extend this to Request Members.

    Use case for this is when raising a linked request in a different service or domain, all members of the team owning the original request need to have visibility on the linked request. For our immediate use case, this would be the Service Desk so that any member of the team could take over the original request and still have visibility on the linked request.

  6. @Sam P user has the Board User role, which should be sufficient.

    I have another update card node earlier in the same stage which has been working fine.

    It is only the newer update card nodes which are failing, and it makes no sense as the config the newer node is identical the one that is still working.

    The only difference, other than display name, is I use "Variable" in the new node and "Manual" in the working node when setting the cardId:
    Screenshot2023-11-13at17_16_30.thumb.png.40a7308c0bc0f9fddd0708a41cecde4e.png

  7. We have a process where we need to update the info on a card at various points.

    At the beginning of the stage, we have a "Get Card Information" node and use this later in the "Update Card" node, however it consistently gives errors.

    Prior to introducing the update card, we had a "Move Card on Board" node which always worked as expected, however, since introducing the update card immediately prior to the move card node, our users keep getting an error and I have to go into the failed workflows and change the update card to a get request information before the workflow will restart (even setting the card id to the actual id retrieved from database direct does not work).

    Is this a bug with the update card automation?

    Our Update Card automation looks like this:

    image.thumb.png.38d5b67cb7517843c8458769127e19b0.png

    and the error our users keep getting is:

    image.png.4e5a5975429eeb8f58fd52c4c389ce56.png

    Full error from the BPM log is:

    Execution Failed: Xmlmc method invocation failed for BPM invocation node 'stage-30f66116/flowcode-9ca9f78d': <methodCallResult status="fail">
    	<state>
    		<code>0207</code>
    		<service>apps</service>
    		<operation>updateCard</operation>
    		<error>/apps/com.hornbill.boardmanager/entities/Card/fc_modules/card.js(730): error X1001: Uncaught TypeError: Cannot read property &apos;record&apos; of undefined</error>
    		<flowcodeError>
    			<where>Execute</where>
    			<filename>/apps/com.hornbill.boardmanager/entities/Card/fc_modules/card.js</filename>
    			<lineNumber>730</lineNumber>
    			<columnPos>81</columnPos>
    			<message>Uncaught TypeError: Cannot read property &apos;record&apos; of undefined</message>
    			<errorCode>1001</errorCode>
    		</flowcodeError>
    	</state>
    </methodCallResult>

     

  8. I tried to copy the "Supplier User" role in Supplier Manager and removed all the canCreate-, canDelete and canUpdate- permissions, leaving only the canView- permissions in place.

    However, this doesn't work as expected and the user in this "view-only" role can still update and delete everything, despite not having those permissions assigned.

    How can I create a role which restricts access to the Supplier, and more importantly, the Contract information?

  9. @Andrew Parsons You assume correctly! 🙂

    If you want to find an email anywhere, including at the beginning of the line, you will need to be a bit more specific in your regex.

    For example, assuming your email addresses are ALWAYS of the format first.last@islington.gov.uk, you could use something like:

    (\w+\.\w+@islington.gov.uk)

    You will also need to set the "Regular Expression Flags" option to: u
    This will allow matching on Unicode characters such as ä.

    If you expect double-barrel last names, you may have to change the 2nd \w to: [\w-]+

  10. I was wondering how I could create a report in Supplier Manager to show the total contract value per supplier.

    I can achieve what I need in Database Direct using the following SQL, however I'm unable to get the same data out in a report.

    Does anyone know how to achieve this?

    SELECT 
        s.h_name as supplier
        , c.h_currency as currency
        , FORMAT(SUM(c.h_value),2) as "total contract value"
    FROM h_supplier_supplier_contracts c
    JOIN h_supplier_suppliers s ON s.h_id = c.h_supplier_id
    GROUP BY s.h_name, c.h_currency

     

  11. @Andrew Parsons .* means every character, which is why you're getting the "test2" back.

    You could instead try: \s?(.*@islington.gov.uk)

    This will match everything after an optional space character (which could be a space or a tab character)

    The brackets will ensure that only everything after the space is counted in the result

  12. Please consider as an enhancement to the group picker field, the ability to be able to filter a group by group id.

    I'm envisaging something similar to how we are able to apply a group id to the "Search co-workers (by group)" data query option.

    By way of a use case:

    We have different cost centres by location and have loaded them in the following hierarchy: ORG/LOCATION/CODE

    Not every capture form using cost centres needs the ability to pick a cross-location cost centre, which is where we'd like to filter the list by group (eg.: ORG/LOCATION/) to only show the cost centres applicable to that location.

  13. We'd like to request an enhancement to the the Access Control automations to be able to lock, at minimum, the Attachments section of a request.

    Currently, we can lock all the actions and the request details, but not the attachments (or any other part of the request).

    Our specific use-case is that when a request is closed, we need to lock down EVERYTHING as these specific requests are auditable as part of our financial year end audits, including the contents of the attachments.

     

×
×
  • Create New...