Darn, I thought I'd found the problem: I was missing the "DW_" from the front of the INVOICE_DATE field in my WHERE clause (I was referencing the sql name of the field - check my second pic and you'll see what I mean). I fixed it but that didn't solve the problem, which surprised me quite a bit, tbh. I'm on version 126.96.36.19941 (early October's release, I believe) so I'll grab the latest release and see if that helps.
For sure, Phil. Three pics uploaded:
I really hope I'm missing something simple here. I have a hard time believing that I'm the only person that's trying to reference a date-type GV in a WHERE clause - others must be doing it successfully.
Hi Phil, are you seeing something similar with parsing dates in WHERE clauses? I'm testing an upgrade to DW7 and noticed that a duplicate invoice check that I'd built was broken and am trying to diagnose it with the help of this thread as well as this one: https://www.docuware.com/forum/english-forums/docuware-help-technical-pr...
I've gradually stripped away the various criteria from the WHERE clause and found that the INVOICE_DATE = GV_InvoiceDate bit was the problem - as soon as I take that part out it works. As a matter of fact just leaving that part in by itself doesn't work. I've tried using the Assign Data task using both External Data and File Cabinet as the source but it just refuses to match the date. I've tried putting single quotes around the GV the way we had to prior to DW7 and that didn't help.
What now? I have a couple of DW7 upgrades scheduled shortly and if there's a bug with using LIKE in workflow then I need to know about it. Where is this info?
Hi Jay, you totally can do this. How comfortable are you in SQL? Here's the SQL for a custom view I setup in DW6.12 (but I'm sure it'll work in earlier version) that returns a list of the users with their groups and roles:
SELECT dbo.DWUser.name, dbo.DWGroup.name AS GroupName, dbo.DWGroup.guid, dbo.DWRoles.name AS RoleName FROM dbo.DWGroup INNER JOIN dbo.DWUserToGroup ON dbo.DWGroup.gid = dbo.DWUserToGroup.gid INNER JOIN dbo.DWUser ON dbo.DWUserToGroup.uid = dbo.DWUser.uid INNER JOIN dbo.DWUserToRole ON dbo.DWUser.uid = dbo.DWUserToRole.uid INNER JOIN dbo.DWRoles ON dbo.DWUserToRole.rid = dbo.DWRoles.rid WHERE (dbo.DWGroup.name <> N'Public')
It also returns the GUID of the group but you probably don't need that. Once you have that in place you can reference it in a workflow Assign Data task as an external data source and assign the results (using whatever criteria you need) to a variable that's been declared as a "List of Users" type and then assign the task to that.
Hopefully that's enough to get you started - lemme know how it goes.
ah, that makes sense. And now the designer gets a bona fide task as well. Nice. Thanks, Phil.
Quick question about one of the new features in Workflow Manager in DW7. The "What's New" PDF says: "If there is an error in an automatic decision when completing a task, the workflow designer receives a task with a description of the error and appropriate decision options". Can you give some more detail regarding "if there is an error in an automatic decision when completing a task"? Does this mean that if DW encounters an error when attempting, for example, a Condition task or an Assign Data task, it will trigger this new feature? The upgraded workflows I'm looking at still have the Error ouptut for those kinds of tasks.
Good to hear, Tobias. What about trays that are automatically created by a user synchronization workflow? Will the administrator automatically have access to those in the next version as well?
I have a client schedule for an upgrade from 6.11 to 6.12 this weekend. Are the DW6.12 installation files updated with this hotfix?
Hi Stefan, using an iFrame is definitely supported, all you have to do is make a modification to the web.config file. I've attached a screencap from the pdf on how to do it (we can't upload PDFs, apparently). It works in every version after 6.5. Let me know if you can't read the screencap and I'll type it out.