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")