Hi, I'd like to be able to generate a Process Inventory view for Org Units. For example, if I have five processes which Department X participates in, I would like to create a view of those 5 processes within the Business unit. It would be really useful if the inventory included items underneath the Department, for example I have teams within a department which also perform processes. I've done a little sketch which is attached. Is there a diagram with Mega which is best suited to this? Or a report which would then be updatable?
... View more
Hi, I'm trying to write a query which will return all diagrams which do not have a certain type of note on them. We've started adding 'Documentation' notes to diagrams to demonstrate the status a diagram is at, i.e Draft or Signed Off. I've written the query below to identify diagrams where these do not exist, but I'm having a problem where diagram have multiple notes on them. Select [Note] Into@docnoteWhere [Type] And [Type].[Name] ="Documentation" Select [Diagram] Where [Drawing Note] Notin@docnote Historically, we've added notes to diagram to record issues or questions we have with a process. And when I run the query above, it returns diagrams which contain both these notes. Ultimately, I only want a list of diagrams which do not have 'Documentation' notes regardless of whether they have other notes on. Does anyone have a solution for this? Many Thanks
... View more
Note that in standard HOPEX installation a certificate is installed with expiration on 3rd of February 2020. If your installation cease to work, please have your administrator sign-in and download the new certificate. Thank you for your understanding. Download Certificate+