22 results found

1. URL builder - IN statement

   REQUEST:
   Add the ability to use an "IN" statement when calling Docuware through URLs.

   REASON:
   Queries will fail once you exceed the length limitation. It is not uncommon for us to have the query portion of the URL in the thousands of characters. The main cause is repetition of field names.

   EXAMPLE 1 (simple):
   A query that currently looks like:
   ([documenttype]="FAI" or [documenttype]="FAI-R" OR [documenttype]="GMTX" OR [documenttype]="RECEIVER") [document_id] = "123"

   would be shortened to:

   [documenttype] IN ("FAI","FAI-R","GMTX","RECEIVER") AND [documentid] = "123"

   EXAMPLE 2 (actual generated query):
   ([DOCUMENTTYPE]="Sales Order" AND [DOCUMENTID] LIKE "090918*" AND [COMPANY]="MD") OR ([DOCUMENTTYPE]="Customer PO" AND [DOCUMENTID] = "10913245")
   OR [DWDOCID]=1373586 OR [DWDOCID]=1373589 OR [DWDOCID]=1373590 OR [DWDOCID]=1373592 OR [DWDOCID]=1373593 OR [DWDOCID]=1376222 OR [DWDOCID]=1420585
   OR [DWDOCID]=1425268 OR [DWDOCID]=1425269 OR [DWDOCID]=1425270 OR [DWDOCID]=1425271 OR [DWDOCID]=1425272 OR [DWDOCID]=1425273 OR [DWDOCID]=1425274
   OR [DWDOCID]=1425275 OR [DWDOCID]=1425276 OR [DWDOCID]=1425277 OR [DWDOCID]=1425287 OR [DWDOCID]=1425288 OR [DWDOCID]=1425289 OR [DWDOCID]=1425290
   OR [DWDOCID]=1425291 OR [DWDOCID]=1425292 OR [DWDOCID]=1425293 OR [DWDOCID]=1427706 OR [DWDOCID]=1427707 OR [DWDOCID]=1427708 OR [DWDOCID]=1427709
   OR [DWDOCID]=1427710 OR [DWDOCID]=1427711 OR [DWDOCID]=1432094 OR [DWDOCID]=1432095 OR [DWDOCID]=1432096 OR [DWDOCID]=1432097 OR [DWDOCID]=1432098
   OR [DWDOCID]=1432099 OR [DWDOCID]=1432100 OR [DWDOCID]=1432101 OR [DWDOCID]=1466435 OR [DWDOCID]=1466436 OR [DWDOCID]=1466437 OR [DWDOCID]=1466438
   OR [DWDOCID]=1466439 OR [DWDOCID]=1467401 OR [DWDOCID]=1467402 OR [DWDOCID]=1254582 OR [DWDOCID]=1303013 OR [DWDOCID]=1359511 OR
   ([DOCUMENTTYPE]="Shipper" AND [DOCUMENTID]="000300") OR ([DOCUMENTTYPE]="C of C" AND [DOCUMENTID]="000300")
   OR ([DOCUMENTTYPE]="Export License" AND [DOCUMENTID]="NLR")

   would be shortened to:

   ([DOCUMENTTYPE]="Sales Order" AND [DOCUMENTID] LIKE "090918*" AND [COMPANY]="MD") OR ([DOCUMENTTYPE]="Customer PO" AND [DOCUMENTID] = "10913245")
   OR [DWDOCID] IN (1373586,1373589,1373590,1373592,1373593,1376222,1420585,1425268,1425269,1425270,1425271,1425272,1425273,1425274,1425275,1425276,
   1425277,1425287,1425288,1425289,1425290,1425291,1425292,1425293,1427706,1427707,1427708,1427709,1427710,1427711,1432094,1432095,1432096,1432097,
   1432098,1432099,1432100,1432101,1466435,1466436,1466437,1466438,1466439,1467401,1467402,1254582,1303013,1359511) OR
   ([DOCUMENTTYPE]="Shipper" AND [DOCUMENTID]="000300") OR ([DOCUMENTTYPE]="C of C" AND [DOCUMENTID]="000300")
   OR ([DOCUMENTTYPE]="Export License" AND [DOCUMENTID]="NLR")

   REQUEST:
   Add the ability to use an "IN" statement when calling Docuware through URLs.

   REASON:
   Queries will fail once you exceed the length limitation. It is not uncommon for us to have the query portion of the URL in the thousands of characters. The main cause is repetition of field names.

   EXAMPLE 1 (simple):
   A query that currently looks like:
   ([documenttype]="FAI" or [documenttype]="FAI-R" OR [documenttype]="GMTX" OR [documenttype]="RECEIVER") [document_id] = "123"

   would be shortened to:

   [documenttype] IN ("FAI","FAI-R","GMTX","RECEIVER") AND [documentid] = "123"

   EXAMPLE 2 (actual generated query):
   ([DOCUMENTTYPE]="Sales Order" AND [DOCUMENTID] LIKE "090918*"… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Integration  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. Generate MS Office files (Word/Excel)

   It would be nice to generate MS Office files (like proposals) with pre-filled fields (like Company name, etc) from file cabinet to send it to customer.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Integration  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   Not currently planned  ·  AdminDocuWare Product Management (Product Owner, DocuWare) responded

   Thank you for your idea. Right now we are focusing on other topics, so we are not considering this idea for future releases. If the demand for this topic increases, we might add it to future plans.