Edward Clarke Community Service Partners Director of Information Technology

Hello,

I have been writing a small program that will collect our computer inventory and store that in DocuWare.  Everything is working great.  I have a question on checking a document in/out.  I want to be able to check a document out and attach the new specs sheet to the old one and check it back in.  I've followed the example https://developer.docuware.com/dotNet_CodeExamples/8949abfb-4386-4e6d-81fc-e0b674ec3fb4.html 

Is there a way to make this sync vs async?  I would want my program to wait while the file is being downloaded from DocuWare so I can merge my spec sheets together and then initiate an upload.

Hi Simon,

Thank you - I was able to resolve item #1.  I'm still a little stuck on item #2.  I've attached a copy of my store dialog.  I would like it if I can select the RIN from the drop down list and then it populates the name from the client name.  Example, I select 123 and it is associated with Doe, Jane - I would want that to be automatically filled in.  Same if I edit the client name field and remove Doe, Jane and put Doe, John and it would update the RIN field with 124.  Is that possible?  I thought there was a way to filter an index field based off the entry in another.  

Phil,

This was very helpful - thank you.

Ed

I have two questions on this - I'm use to the 6.8 version of DocuWare so I'm not sure how to do this in 7.1.  

1. I have my store dialog working where I have 1 field pull from a fixed list of available document types.  When a user searchs and right clicks to edit the index entrires - they can type what ever they want.  How do you prevent this in 7.1 making sure it's only in the available select list?

2. On store dialog - field one is where they will type an ID - how do I now make that an external sql query to pull back the name of the client in the "client name" field?  So if I type 1234 and I go to the next field I'd like to be able to run a query to fill that in so we don't get staff members spelling a name differently each time.

Oh Ok - we don't have workflow manager.  This is my one rule and I'm just wondering if there are too many conditions?

Vendor = A Better Door & Dock Services OR A Better Door & Window OR ABERON CONSTRUCTION CO. OR Ace Hardware OR Advanced Disposal Services OR Albert Brother's Inc. OR Aleck Plumbing OR Ambrosino's Italian Market & Deli OR Ameren Illinois OR American Environmental Waste Company OR American Pest Control Inc. OR AMPEST Exterminating & Wildlife Control OR Anderson Elevator Co OR Ants Pest Control Service OR ARAB Termite & Pest Control OR Atteberry & Marshall Heating & Air OR Ben's Lawn Care OR Bill Spencer Htg. & Air OR BRILLIANT PROMOS OR By Design Landscape OR Camfield Family Plumbing, Inc OR Central IL Home Inspection Service, Inc. OR Central Illinois Appliance Repair OR Charleston Water Department OR Chris Moran OR City of Country Club Hills OR CliftonLarsonAllen OR Colley Elevator Co OR Color Your World, Ltd OR Community Service Partners, Inc. OR CONNOR FOSTER LAND SURVEYING OR Consolidated Communications OR Cook County Clerk OR Costello Wholesale Floor Co OR CR Neff Plumbing, Heating & AC LLC OR CTF Illinois OR CULLIGAN WATER CONDITIONING OR D.E.W. Plumbing OR De Re TIre & Auto OR Dillon Maintenance Inc. OR Donor Perfect OR Effective Signs OR Elmer & Son Locksmiths, INC OR Eltron, Inc OR Enterprise Fleet Management OR Epoch Property Inspectios, Inc OR Ernie's Glass OR Eternally Green Lawn Care Inc. OR Evergreen Mechanical OR Fairway Recognition OR Fire Equipment Services and Sales, Inc OR FIRE PROTECTION COMPANY OR First Midwest Banks OR Frankfort Fire Protection District OR Friends and Family OR Getz Fire Equipment OR GORDON APPRAISAL SERVICE OR Grainger OR Green Promoting OR Guardian-Appleton OR Illiana Lawn Irrigation OR Illinois Charity Bureau Fund OR Illinois Office of the State Fire Marshal OR Illinois Partners for Human Service OR Illinois Secretary Of State{Auto Vehicle OR Illinois Tollway OR Image 360 OR Internal Revenue Service OR John Hancock Life Insurance Company OR JP Morgan Chase Bank OR JVD Sports OR Kirchner Building Centers OR Kitchens Baths & More OR Knights of Columbus 4698 OR KONE Inc. OR KristinZKreations OR Lagestee-Mulder, Inc. OR Lancaster Bingo Company OR Las Fuentes Association OR LD Mechanical Contractors Inc OR Leadz Networkers OR Lorenz Supply Company OR M & G Graphics, Inc. OR M&S Pest Control Inc OR McQuellon's Appliance Company OR Midlothian Country Club OR Midwest Softwash OR Miles McBride OR Mueller Roofing OR Park Ace Hardware OR Party Linens, LLC OR Perma Graphic Printers Inc OR Perma-Seal OR Pest Pro & Turf Solutions Inc OR Philadelphia Insurance Companies - OR Phillips Interiors OR Phoenix Fire Systems Inc OR Postmaster Of Tinley Park OR Precise Tree Care OR Proshred OR Proven Business System OR Red Hawk Fire & Security OR Reifsteck Reid & Company Architects OR Ridge Plumbing OR Robert J. Huguelet, Jr. OR Royse's Plumbing, Heating and AC OR Ruff, Freud, Breems & Nelson, Ltd. OR Sam's Club OR Schrey Systems OR Scott Overhead Door, Inc. OR Secretary of State.. OR Security Unlimited Inc OR Service Experts OR Seyfarth Shaw LLP OR Shady Oaks Camp OR Smithereen Pest Management Services OR Stuard & Associates, Inc. OR Superior Mowing OR T&H TIMING LLC OR T&L Lawncare and Landscaping OR TERMINIX INTERNATIONAL OR The Gorman Group OR The Hartford Group, Inc. OR The Hot Corner OR THE SHERWIN WILLIAMS CO OR The Village of Tinley Park OR Thompson Elevator Inspection Service Inc. OR TIAA BANK OR Todays Conferencing, Inc. OR UCP Seguin of Greater Chicago OR United Health Care OR Van Bruggen Signs Inc. OR Verizon OR Village Center Business Condo Assoc OR Village of Flossmoor OR Village of Frankfort OR VILLAGE OF HAZEL CREST OR Village of Homewood OR Village of Orland Hills OR Village of Orland Park OR Village of South Holland OR Village Of Tinley Park (deleted) OR Vital Lawncare and Landscape, Inc. OR VSP OR Ward Contracting & Building Restoration OR WEX BANK OR Whitney Roofing OR Will County Collector OR Williams Rental OR Willow Brook Community Assoc, Inc OR Woodmac Industries

I tried it with "Vendor = " and I listed 3 names and it triggers.  Or is it because of the single quotes and the "&" sign?

<event timestamp="2019-06-27T13:12:15.9237624-05:00" level="Error" logger="DocuWare.EventTrigger.Producer.EmailProducer" SequenceID="28" Thread="25" DomainName="CSP" WindowsUserName="administrator"><message>Problems with rule 11efc4c1-b20d-4b8c-a5d5-b8ee17be8038 for file cabinet [CSF_Fina from organization 40ea4089-5606-4cb2-9097-b80804240e1b]! VENDOR = A Better Door &amp; Dock Services OR A Better Door &amp; Window OR ABERON CONSTRUCTION CO. OR Ace Hardware OR Advanced Disposal Services OR Albert Brother's Inc. OR Aleck Plumbing OR Ambrosino's Italian Market &amp; Deli OR Ameren Illinois OR American Environmental Waste Company OR American Pest Control Inc. OR AMPEST Exterminating &amp; Wildlife Control OR Anderson Elevator Co OR Ants Pest Control Service OR ARAB Termite &amp; Pest Control OR Atteberry &amp; Marshall Heating &amp; Air OR Ben's Lawn Care OR Bill Spencer Htg. &amp; Air OR BRILLIANT PROMOS OR By Design Landscape OR Camfield Family Plumbing, Inc OR Central IL Home Inspection Service, Inc. OR Central Illinois Appliance Repair OR Charleston Water Department OR Chris Moran OR City of Country Club Hills OR CliftonLarsonAllen OR Colley Elevator Co OR Color Your World, Ltd OR Community Service Partners, Inc. OR CONNOR FOSTER LAND SURVEYING OR Consolidated Communications OR Cook County Clerk OR Costello Wholesale Floor Co OR CR Neff Plumbing, Heating &amp; AC LLC OR CTF Illinois OR CULLIGAN WATER CONDITIONING OR D.E.W. Plumbing OR De Re TIre &amp; Auto OR Dillon Maintenance Inc. OR Donor Perfect OR Effective Signs OR Elmer &amp; Son Locksmiths, INC OR Eltron, Inc OR Enterprise Fleet Management OR Epoch Property Inspectios, Inc OR Ernie's Glass OR Eternally Green Lawn Care Inc. OR Evergreen Mechanical OR Fairway Recognition OR Fire Equipment Services and Sales, Inc OR FIRE PROTECTION COMPANY OR First Midwest Banks OR Frankfort Fire Protection District OR Friends and Family OR Getz Fire Equipment OR GORDON APPRAISAL SERVICE OR Grainger OR Green Promoting OR Guardian-Appleton OR Illiana Lawn Irrigation OR Illinois Charity Bureau Fund OR Illinois Office of the State Fire Marshal OR Illinois Partners for Human Service OR Illinois Secretary Of State{Auto Vehicle OR Illinois Tollway OR Image 360 OR Internal Revenue Service OR John Hancock Life Insurance Company OR JP Morgan Chase Bank OR JVD Sports OR Kirchner Building Centers OR Kitchens Baths &amp; More OR Knights of Columbus 4698 OR KONE Inc. OR KristinZKreations OR Lagestee-Mulder, Inc. OR Lancaster Bingo Company OR Las Fuentes Association OR LD Mechanical Contractors Inc OR Leadz Networkers OR Lorenz Supply Company OR M &amp; G Graphics, Inc. OR M&amp;S Pest Control Inc OR McQuellon's Appliance Company OR Midlothian Country Club OR Midwest Softwash OR Miles McBride OR Mueller Roofing OR Park Ace Hardware OR Party Linens, LLC OR Perma Graphic Printers Inc OR Perma-Seal OR Pest Pro &amp; Turf Solutions Inc OR Philadelphia Insurance Companies - OR Phillips Interiors OR Phoenix Fire Systems Inc OR Postmaster Of Tinley Park OR Precise Tree Care OR Proshred OR Proven Business System OR Red Hawk Fire &amp; Security OR Reifsteck Reid &amp; Company Architects OR Ridge Plumbing OR Robert J. Huguelet, Jr. OR Royse's Plumbing, Heating and AC OR Ruff, Freud, Breems &amp; Nelson, Ltd. OR Sam's Club OR Schrey Systems OR Scott Overhead Door, Inc. OR Secretary of State.. OR Security Unlimited Inc OR Service Experts OR Seyfarth Shaw LLP OR Shady Oaks Camp OR Smithereen Pest Management Services OR Stuard &amp; Associates, Inc. OR Superior Mowing OR T&amp;H TIMING LLC OR T&amp;L Lawncare and Landscaping OR TERMINIX INTERNATIONAL OR The Gorman Group OR The Hartford Group, Inc. OR The Hot Corner OR THE SHERWIN WILLIAMS CO OR The Village of Tinley Park OR Thompson Elevator Inspection Service Inc. OR TIAA BANK OR Todays Conferencing, Inc. OR UCP Seguin of Greater Chicago OR United Health Care OR Van Bruggen Signs Inc. OR Verizon OR Village Center Business Condo Assoc OR Village of Flossmoor OR Village of Frankfort OR VILLAGE OF HAZEL CREST OR Village of Homewood OR Village of Orland Hills OR Village of Orland Park OR Village of South Holland OR Village Of Tinley Park (deleted) OR Vital Lawncare and Landscape, Inc. OR VSP OR Ward Contracting &amp; Building Restoration OR WEX BANK OR Whitney Roofing OR Will County Collector OR Williams Rental OR Willow Brook Community Assoc, Inc OR Woodmac Industries</message><exception>DocuWare.Common.Exceptions.DWException: Problems with rule 11efc4c1-b20d-4b8c-a5d5-b8ee17be8038 for file cabinet [CSF_Fina from organization 40ea4089-5606-4cb2-9097-b80804240e1b]! VENDOR = A Better Door &amp; Dock Services OR A Better Door &amp; Window OR ABERON CONSTRUCTION CO. OR Ace Hardware OR Advanced Disposal Services OR Albert Brother's Inc. OR Aleck Plumbing OR Ambrosino's Italian Market &amp; Deli OR Ameren Illinois OR American Environmental Waste Company OR American Pest Control Inc. OR AMPEST Exterminating &amp; Wildlife Control OR Anderson Elevator Co OR Ants Pest Control Service OR ARAB Termite &amp; Pest Control OR Atteberry &amp; Marshall Heating &amp; Air OR Ben's Lawn Care OR Bill Spencer Htg. &amp; Air OR BRILLIANT PROMOS OR By Design Landscape OR Camfield Family Plumbing, Inc OR Central IL Home Inspection Service, Inc. OR Central Illinois Appliance Repair OR Charleston Water Department OR Chris Moran OR City of Country Club Hills OR CliftonLarsonAllen OR Colley Elevator Co OR Color Your World, Ltd OR Community Service Partners, Inc. OR CONNOR FOSTER LAND SURVEYING OR Consolidated Communications OR Cook County Clerk OR Costello Wholesale Floor Co OR CR Neff Plumbing, Heating &amp; AC LLC OR CTF Illinois OR CULLIGAN WATER CONDITIONING OR D.E.W. Plumbing OR De Re TIre &amp; Auto OR Dillon Maintenance Inc. OR Donor Perfect OR Effective Signs OR Elmer &amp; Son Locksmiths, INC OR Eltron, Inc OR Enterprise Fleet Management OR Epoch Property Inspectios, Inc OR Ernie's Glass OR Eternally Green Lawn Care Inc. OR Evergreen Mechanical OR Fairway Recognition OR Fire Equipment Services and Sales, Inc OR FIRE PROTECTION COMPANY OR First Midwest Banks OR Frankfort Fire Protection District OR Friends and Family OR Getz Fire Equipment OR GORDON APPRAISAL SERVICE OR Grainger OR Green Promoting OR Guardian-Appleton OR Illiana Lawn Irrigation OR Illinois Charity Bureau Fund OR Illinois Office of the State Fire Marshal OR Illinois Partners for Human Service OR Illinois Secretary Of State{Auto Vehicle OR Illinois Tollway OR Image 360 OR Internal Revenue Service OR John Hancock Life Insurance Company OR JP Morgan Chase Bank OR JVD Sports OR Kirchner Building Centers OR Kitchens Baths &amp; More OR Knights of Columbus 4698 OR KONE Inc. OR KristinZKreations OR Lagestee-Mulder, Inc. OR Lancaster Bingo Company OR Las Fuentes Association OR LD Mechanical Contractors Inc OR Leadz Networkers OR Lorenz Supply Company OR M &amp; G Graphics, Inc. OR M&amp;S Pest Control Inc OR McQuellon's Appliance Company OR Midlothian Country Club OR Midwest Softwash OR Miles McBride OR Mueller Roofing OR Park Ace Hardware OR Party Linens, LLC OR Perma Graphic Printers Inc OR Perma-Seal OR Pest Pro &amp; Turf Solutions Inc OR Philadelphia Insurance Companies - OR Phillips Interiors OR Phoenix Fire Systems Inc OR Postmaster Of Tinley Park OR Precise Tree Care OR Proshred OR Proven Business System OR Red Hawk Fire &amp; Security OR Reifsteck Reid &amp; Company Architects OR Ridge Plumbing OR Robert J. Huguelet, Jr. OR Royse's Plumbing, Heating and AC OR Ruff, Freud, Breems &amp; Nelson, Ltd. OR Sam's Club OR Schrey Systems OR Scott Overhead Door, Inc. OR Secretary of State.. OR Security Unlimited Inc OR Service Experts OR Seyfarth Shaw LLP OR Shady Oaks Camp OR Smithereen Pest Management Services OR Stuard &amp; Associates, Inc. OR Superior Mowing OR T&amp;H TIMING LLC OR T&amp;L Lawncare and Landscaping OR TERMINIX INTERNATIONAL OR The Gorman Group OR The Hartford Group, Inc. OR The Hot Corner OR THE SHERWIN WILLIAMS CO OR The Village of Tinley Park OR Thompson Elevator Inspection Service Inc. OR TIAA BANK OR Todays Conferencing, Inc. OR UCP Seguin of Greater Chicago OR United Health Care OR Van Bruggen Signs Inc. OR Verizon OR Village Center Business Condo Assoc OR Village of Flossmoor OR Village of Frankfort OR VILLAGE OF HAZEL CREST OR Village of Homewood OR Village of Orland Hills OR Village of Orland Park OR Village of South Holland OR Village Of Tinley Park (deleted) OR Vital Lawncare and Landscape, Inc. OR VSP OR Ward Contracting &amp; Building Restoration OR WEX BANK OR Whitney Roofing OR Will County Collector OR Williams Rental OR Willow Brook Community Assoc, Inc OR Woodmac Industries ---&gt; DocuWare.Common.Parsers.WrongConditionException: Wrong condition!
    Field : VENDOR
    Value : = A Better Door &amp; Dock Services OR A Better Door &amp; Window OR ABERON CONSTRUCTION CO. OR Ace Hardware OR Advanced Disposal Services OR Albert Brother's Inc. OR Aleck Plumbing OR Ambrosino's Italian Market &amp; Deli OR Ameren Illinois OR American Environmental Waste Company OR American Pest Control Inc. OR AMPEST Exterminating &amp; Wildlife Control OR Anderson Elevator Co OR Ants Pest Control Service OR ARAB Termite &amp; Pest Control OR Atteberry &amp; Marshall Heating &amp; Air OR Ben's Lawn Care OR Bill Spencer Htg. &amp; Air OR BRILLIANT PROMOS OR By Design Landscape OR Camfield Family Plumbing, Inc OR Central IL Home Inspection Service, Inc. OR Central Illinois Appliance Repair OR Charleston Water Department OR Chris Moran OR City of Country Club Hills OR CliftonLarsonAllen OR Colley Elevator Co OR Color Your World, Ltd OR Community Service Partners, Inc. OR CONNOR FOSTER LAND SURVEYING OR Consolidated Communications OR Cook County Clerk OR Costello Wholesale Floor Co OR CR Neff Plumbing, Heating &amp; AC LLC OR CTF Illinois OR CULLIGAN WATER CONDITIONING OR D.E.W. Plumbing OR De Re TIre &amp; Auto OR Dillon Maintenance Inc. OR Donor Perfect OR Effective Signs OR Elmer &amp; Son Locksmiths, INC OR Eltron, Inc OR Enterprise Fleet Management OR Epoch Property Inspectios, Inc OR Ernie's Glass OR Eternally Green Lawn Care Inc. OR Evergreen Mechanical OR Fairway Recognition OR Fire Equipment Services and Sales, Inc OR FIRE PROTECTION COMPANY OR First Midwest Banks OR Frankfort Fire Protection District OR Friends and Family OR Getz Fire Equipment OR GORDON APPRAISAL SERVICE OR Grainger OR Green Promoting OR Guardian-Appleton OR Illiana Lawn Irrigation OR Illinois Charity Bureau Fund OR Illinois Office of the State Fire Marshal OR Illinois Partners for Human Service OR Illinois Secretary Of State{Auto Vehicle OR Illinois Tollway OR Image 360 OR Internal Revenue Service OR John Hancock Life Insurance Company OR JP Morgan Chase Bank OR JVD Sports OR Kirchner Building Centers OR Kitchens Baths &amp; More OR Knights of Columbus 4698 OR KONE Inc. OR KristinZKreations OR Lagestee-Mulder, Inc. OR Lancaster Bingo Company OR Las Fuentes Association OR LD Mechanical Contractors Inc OR Leadz Networkers OR Lorenz Supply Company OR M &amp; G Graphics, Inc. OR M&amp;S Pest Control Inc OR McQuellon's Appliance Company OR Midlothian Country Club OR Midwest Softwash OR Miles McBride OR Mueller Roofing OR Park Ace Hardware OR Party Linens, LLC OR Perma Graphic Printers Inc OR Perma-Seal OR Pest Pro &amp; Turf Solutions Inc OR Philadelphia Insurance Companies - OR Phillips Interiors OR Phoenix Fire Systems Inc OR Postmaster Of Tinley Park OR Precise Tree Care OR Proshred OR Proven Business System OR Red Hawk Fire &amp; Security OR Reifsteck Reid &amp; Company Architects OR Ridge Plumbing OR Robert J. Huguelet, Jr. OR Royse's Plumbing, Heating and AC OR Ruff, Freud, Breems &amp; Nelson, Ltd. OR Sam's Club OR Schrey Systems OR Scott Overhead Door, Inc. OR Secretary of State.. OR Security Unlimited Inc OR Service Experts OR Seyfarth Shaw LLP OR Shady Oaks Camp OR Smithereen Pest Management Services OR Stuard &amp; Associates, Inc. OR Superior Mowing OR T&amp;H TIMING LLC OR T&amp;L Lawncare and Landscaping OR TERMINIX INTERNATIONAL OR The Gorman Group OR The Hartford Group, Inc. OR The Hot Corner OR THE SHERWIN WILLIAMS CO OR The Village of Tinley Park OR Thompson Elevator Inspection Service Inc. OR TIAA BANK OR Todays Conferencing, Inc. OR UCP Seguin of Greater Chicago OR United Health Care OR Van Bruggen Signs Inc. OR Verizon OR Village Center Business Condo Assoc OR Village of Flossmoor OR Village of Frankfort OR VILLAGE OF HAZEL CREST OR Village of Homewood OR Village of Orland Hills OR Village of Orland Park OR Village of South Holland OR Village Of Tinley Park (deleted) OR Vital Lawncare and Landscape, Inc. OR VSP OR Ward Contracting &amp; Building Restoration OR WEX BANK OR Whitney Roofing OR Will County Collector OR Williams Rental OR Willow Brook Community Assoc, Inc OR Woodmac Industries
   at DocuWare.Common.Parsers.SearchFDRParser.GetConditionFromFDRTerm(FDRTerm term, Boolean addWildcard)
   at DocuWare.Common.Parsers.SearchFDRParser.GetConditionFromFilter(SearchFilter filter)
   at DocuWare.Common.Parsers.SearchFDRParser.GetConditionsFromFilter(SearchFilter filter)
   at DocuWare.EventTrigger.Producer.EmailProducer.GetSearchFilterCondition(Guid ruleGuid, Guid organizationGuid, SimpleFilter simpleFilter, DataSet metadata, DataSet oldValues)
   --- End of inner exception stack trace ---</exception></event>

Hi Josef,

I do have AuotIndex but not sure what you mean by a FC field (APUser).  Is there an kb on this?

Ed

I have 4 people who have different vendors they approve invoices for.  

OK.

I want to setup a notification for a few people about new invoices in the system.  I am basing it on "Status" and "Vendor" - I don't see the option in the Notificaton settings to say "Status=New" AND "Vendor=A OR Vendor=B"

Do I have to set this up for each vendor?