Daryl Foxhoven

I have a customer that wants to setup a condition so that any Invoice scanned is less than 4 pages, it goes to a clerk for review (as their AR invoices should be a minimum of 4 pages).  I initially thought I could at least capture the system field for DWTOTALPAGES in Workflow designer, but appears it's not available which is mind boggling to me why system fields would not be available.  I then though perhaps I could capture it via AutoIndex job....again...I can use DWTOTALPAGES as a match condition, but I cannot use it to populate an index field.  Seems very antiquated that it's not available....does anyone have a workaround or know how you might be able to accomplish this?

Thanks!

Does anyone know how of if it's possible (and if not, will it be) how to use a Multi-Column select list with Forms.  We have a Form that is being filled out, and once the user fills out the Room #, we want the Resident Name to be filtered so that not all resident names show up but ONLY the resident Name for that Room #.  I know this can be done in DocuWare, but when I try to use it in Forms, it ONLY ever pulls the one column, so the Room # is the ONLY thing that shows up for Resident Name....it's almost like it doesn't support Multi-Column?

So has anyone figured out a way to utilize Multi-Column Select list along with Default Select List?  Here's my business case:  Client is a financial advisor...so they have documents that belong to more than one name (joint accounts, etc.)...so we created Last Name and First Name to be Keyword fields so they could enter more than one name.  We're using a multi-column select list so when they chose the Last Name...the it filters the FIrst Name so they're not going through an entire list.  The issue is they're always getting new clients, so they need to be able to store a new document and type in a new Last Name and First Name.  However, once they store that document, the next time they go to store the document, that name does not show up b/c it is not in the .csv that the multi-column select list is pulling from.  We're trying to avoid them having to manually manage the select list for every new account...anyone figure out a workaround or is there a configuration I'm missing??

So I have a situation where in my workflow I need to count the # of entries that meet a certain index criteria.  In my case, I'm counting the # of Packing Slips that have the same invoice # that meets the index value of the invoice (that triggers the workflow).  I'm trying to use an Arithmetic Expression with the following and it's not working.

COUNT (DW_INVOICE__= GV_Packing_List_Invoice_No) AND (DW_DOCUMENT_TYPE = 'Packing List')

DW_INVOICE = Invoice # of the document that triggered the workflow
GV_Packing_List_Invoice_No = GV that is capturing the Invoice # of the Packing Slip in an earlier step

Thanks!!

So we have a prospect that would like users in the field to enter their time sheets when they arrive to a job using Forms, but we need a way to ensure they are at the job site and not sitting at home.  Is there a way to use the location services of a cell phone to auto enter the address/coordinates the user is at when launching and filling out a Form?  If so, how?

Joe,
I'm using "-" in the Group name (ex:  Dept Head-Aging)....so I did what you suggested and took out the : and replaced with -, however, my SQL query returns zero results...even though I know there's a Doc in there for that user (here's my Statement)

DEPARTMENT IN (SELECT substring(name,1,charindex('-',name,1)-1) FROM dwsystem.dbo.dwgroup WHERE gid IN (SELECT 

gid FROM dwsystem.dbo.DWUserToGroup WHERE uid IN (SELECT uid FROM dwsystem.dbo.dwuser WHERE name = 

'bsikora')) AND NAME <> 'Public')


I've also tried this Statement, which gives me a result in SQL, but gives me the following error "Invalid length parameter passed to the RIGHT function"  when I put it in DocuWare's SQL Statement in File Cabinet Permissions:

DEPARTMENT IN (SELECT right([name], charindex('-', reverse([name])) - 1)

 


FROM dwsystem.dbo.dwgroup WHERE gid IN (SELECT

 

gid FROM dwsystem.dbo.DWUserToGroup WHERE uid IN (SELECT uid FROM dwsystem.dbo.dwuser WHERE (name =

 

CURRENTUSERLONGNAME()))AND NAME <> 'Public')

Josef,
Wondering if you know why I might be getting the error with the statement you provided?

Josef,
Not sure how I missed that, but it's there now, but now I get a new error: "Invalid length of parameter passed to the LEFT of SUBSTRIING function"


DEPARTMENT IN (SELECT substring(name,1,charindex(':',name,1)-1) FROM dwsystem.dbo.dwgroup WHERE gid IN (SELECT 

gid FROM dwsystem.dbo.DWUserToGroup WHERE uid IN (SELECT uid FROM dwsystem.dbo.dwuser WHERE name = 

CURRENTUSERLONGNAME())) AND NAME <> 'Public')

Josef, 

I made the substring change you mentioned above and I get the following error "Incorrect syntax near the keyword 'FROM'.  Incorrect syntax near the keyword 'AND'.  Here is my syntax:

DEPARTMENT IN (substring(name,1,charindex(':',name,1)-1) FROM dwsystem.dbo.dwgroup WHERE gid IN (SELECT 

gid FROM dwsystem.dbo.DWUserToGroup WHERE uid IN (SELECT uid FROM dwsystem.dbo.dwuser WHERE name = 

CURRENTUSERLONGNAME())) AND NAME <> 'Public')

So in versions of DocuWare where we use MySQL, we've been able to use a SQL Statement so that we can create 1 file cabinet profile to utilize the logged in user and the Groups we created to allow the Profile to be "dynamic" based upon in this case, the Department index field.  So this allows us to setup security that will look at the logged in user, the index field for department, and then determine if that user is in that Group and provide access to those Dept documents.  Does anyone know of a way to accomplish this with MS SQL as I've not been able to get it to work.  Here is the query we use for MySQL:

DEPARTMENT IN (SELECT SUBSTRING_INDEX(name, ':', 1)FROM dwsystem.dwgroup WHERE gid IN (SELECT 

gid FROM dwsystem.DWUserToGroup WHERE uid IN (SELECT uid FROM dwsystem.dwuser WHERE name = 

CURRENTUSERLONGNAME()))AND NAME <> 'Public')


Thanks!