投稿済み Mon, 24 Jan 2022 22:26:27 GMT 、投稿者 Brian Harris Director of IT
Hello everyone - 
  I am hoping someone else has tried to figure out the limitations on custom URL's.

Some basics:
#1 there is docuware KBA-35654 "Long URLs are not processed correctly".  This document talks about increasing the maximum allowable URL coming into IIS.  While the document talks about setting it to 4098 characters, at the bottom, it states that "you can set the values randomly up to 2097151".  If anyone has played with this setting, you will need to stop DW services, IISReset, and start DW services.

#2 Browsers have URL character limits of:
Chrome: 2mb
Edge: 2mb
Firefox: 65,536
Opera: unlimited
Safari: 80,000

Figuring out the limit:
To try to figure out how to break up my URL into smaller queries, I tried figuring out what the character limit was. I tried on the low end and work my way up to hit the breaking point.  But, I began to realize that there is more than just a character limit. There is a query logic limit.

How is this manifested?  Anyone with a DW system can make a very simple query and paste into the URL builder. When I test, I build a query with known DWDOCID's separated with OR statements [DWDOCID]=1 OR [DWDOCID]=2

In my first batch of testing, I thought that the character limit was somewhere at 2780 characters. When I hit a query that worked, versus one that did not.  Even when I had set DW to a much higher limit on the URL length.

Testing query logic limit:
The logic limit seems to be 139 different pieces.  Below are two queries, one that works (top) versus one that does not work (below):

works (139 parts, 2915 characters):
[DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377 OR [DWDOCID]=2953376 OR [DWDOCID]=2953375 OR [DWDOCID]=2953374 OR [DWDOCID]=2953373 OR [DWDOCID]=2953372 OR [DWDOCID]=2953371 OR [DWDOCID]=2953370 OR [DWDOCID]=2953369 OR [DWDOCID]=2953368 OR [DWDOCID]=2953367 OR [DWDOCID]=2953366 OR [DWDOCID]=2953365 OR [DWDOCID]=2953364 OR [DWDOCID]=2953363 OR [DWDOCID]=2953362 OR [DWDOCID]=2953361 OR [DWDOCID]=2953360 OR [DWDOCID]=2953359 OR [DWDOCID]=2953358 OR [DWDOCID]=2953357 OR [DWDOCID]=2953356 OR [DWDOCID]=2953355 OR [DWDOCID]=2953354 OR [DWDOCID]=2953353 OR [DWDOCID]=2953352 OR [DWDOCID]=2953351 OR [DWDOCID]=2953350 OR [DWDOCID]=2953349 OR [DWDOCID]=2953348 OR [DWDOCID]=2953347 OR [DWDOCID]=2953346 OR [DWDOCID]=2953345 OR [DWDOCID]=2953344 OR [DWDOCID]=2953343 OR [DWDOCID]=2953342 OR [DWDOCID]=2953341 OR [DWDOCID]=2953340 OR [DWDOCID]=2953339 OR [DWDOCID]=2953338 OR [DWDOCID]=2953337 OR [DWDOCID]=2953336 OR [DWDOCID]=2953335 OR [DWDOCID]=2953334 OR [DWDOCID]=2953333 OR [DWDOCID]=2953332 OR [DWDOCID]=2953331 OR [DWDOCID]=2953330 OR [DWDOCID]=2953329 OR [DWDOCID]=2953328 OR [DWDOCID]=2953327 OR [DWDOCID]=2953326 OR [DWDOCID]=2953325 OR [DWDOCID]=2953324 OR [DWDOCID]=2953323 OR [DWDOCID]=2953322 OR [DWDOCID]=2953321 OR [DWDOCID]=2953320 OR [DWDOCID]=2953319 OR [DWDOCID]=2953318 OR [DWDOCID]=2953317 OR [DWDOCID]=2953316 OR [DWDOCID]=2953315 OR [DWDOCID]=2953314 OR [DWDOCID]=2953313 OR [DWDOCID]=2953312 OR [DWDOCID]=2953311 OR [DWDOCID]=2953310 OR [DWDOCID]=2953309 OR [DWDOCID]=2953308 OR [DWDOCID]=2953307 OR [DWDOCID]=2953306 OR [DWDOCID]=2953305 OR [DWDOCID]=2953304 OR [DWDOCID]=2953303 OR [DWDOCID]=2953302 OR [DWDOCID]=2953301 OR [DWDOCID]=2953300 OR [DWDOCID]=2953299 OR [DWDOCID]=2953298 OR [DWDOCID]=2953297 OR [DWDOCID]=2953296 OR [DWDOCID]=2953295 OR [DWDOCID]=2953294 OR [DWDOCID]=2953293 OR [DWDOCID]=2953292 OR [DWDOCID]=2953291 OR [DWDOCID]=2953290 OR [DWDOCID]=2953289 OR [DWDOCID]=2953288 OR [DWDOCID]=2953287 OR [DWDOCID]=2953286 OR [DWDOCID]=2953285 OR [DWDOCID]=2953284 OR [DWDOCID]=2953283 OR [DWDOCID]=2953282 OR [DWDOCID]=2953281 OR [DWDOCID]=2953280 OR [DWDOCID]=2953279 OR [DWDOCID]=2953278 OR [DWDOCID]=2953277 OR [DWDOCID]=2953276 OR [DWDOCID]=2953275 OR [DWDOCID]=2953274 OR [DWDOCID]=2953273 OR [DWDOCID]=2953272 OR [DWDOCID]=2953271 OR [DWDOCID]=2953270 OR [DWDOCID]=2953269 OR [DWDOCID]=2953268 OR [DWDOCID]=2953267 OR [DWDOCID]=2953266 OR [DWDOCID]=2953265 OR [DWDOCID]=2953264 OR [DWDOCID]=2953263 OR [DWDOCID]=2953262 OR [DWDOCID]=2953261 OR [DWDOCID]=2953260 OR [DWDOCID]=2953259 OR [DWDOCID]=2953258 OR [DWDOCID]=2953257 OR [DWDOCID]=2953256 OR [DWDOCID]=2953255 OR [DWDOCID]=2953254 OR [DWDOCID]=2953253 OR [DWDOCID]=2953252 OR [DWDOCID]=2953251 OR [DWDOCID]=2953250 OR [DWDOCID]=2953249 OR [DWDOCID]=2953248 OR [DWDOCID]=2953247 OR [DWDOCID]=2953246

does not (140 parts, 2936 characters):
[DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377 OR [DWDOCID]=2953376 OR [DWDOCID]=2953375 OR [DWDOCID]=2953374 OR [DWDOCID]=2953373 OR [DWDOCID]=2953372 OR [DWDOCID]=2953371 OR [DWDOCID]=2953370 OR [DWDOCID]=2953369 OR [DWDOCID]=2953368 OR [DWDOCID]=2953367 OR [DWDOCID]=2953366 OR [DWDOCID]=2953365 OR [DWDOCID]=2953364 OR [DWDOCID]=2953363 OR [DWDOCID]=2953362 OR [DWDOCID]=2953361 OR [DWDOCID]=2953360 OR [DWDOCID]=2953359 OR [DWDOCID]=2953358 OR [DWDOCID]=2953357 OR [DWDOCID]=2953356 OR [DWDOCID]=2953355 OR [DWDOCID]=2953354 OR [DWDOCID]=2953353 OR [DWDOCID]=2953352 OR [DWDOCID]=2953351 OR [DWDOCID]=2953350 OR [DWDOCID]=2953349 OR [DWDOCID]=2953348 OR [DWDOCID]=2953347 OR [DWDOCID]=2953346 OR [DWDOCID]=2953345 OR [DWDOCID]=2953344 OR [DWDOCID]=2953343 OR [DWDOCID]=2953342 OR [DWDOCID]=2953341 OR [DWDOCID]=2953340 OR [DWDOCID]=2953339 OR [DWDOCID]=2953338 OR [DWDOCID]=2953337 OR [DWDOCID]=2953336 OR [DWDOCID]=2953335 OR [DWDOCID]=2953334 OR [DWDOCID]=2953333 OR [DWDOCID]=2953332 OR [DWDOCID]=2953331 OR [DWDOCID]=2953330 OR [DWDOCID]=2953329 OR [DWDOCID]=2953328 OR [DWDOCID]=2953327 OR [DWDOCID]=2953326 OR [DWDOCID]=2953325 OR [DWDOCID]=2953324 OR [DWDOCID]=2953323 OR [DWDOCID]=2953322 OR [DWDOCID]=2953321 OR [DWDOCID]=2953320 OR [DWDOCID]=2953319 OR [DWDOCID]=2953318 OR [DWDOCID]=2953317 OR [DWDOCID]=2953316 OR [DWDOCID]=2953315 OR [DWDOCID]=2953314 OR [DWDOCID]=2953313 OR [DWDOCID]=2953312 OR [DWDOCID]=2953311 OR [DWDOCID]=2953310 OR [DWDOCID]=2953309 OR [DWDOCID]=2953308 OR [DWDOCID]=2953307 OR [DWDOCID]=2953306 OR [DWDOCID]=2953305 OR [DWDOCID]=2953304 OR [DWDOCID]=2953303 OR [DWDOCID]=2953302 OR [DWDOCID]=2953301 OR [DWDOCID]=2953300 OR [DWDOCID]=2953299 OR [DWDOCID]=2953298 OR [DWDOCID]=2953297 OR [DWDOCID]=2953296 OR [DWDOCID]=2953295 OR [DWDOCID]=2953294 OR [DWDOCID]=2953293 OR [DWDOCID]=2953292 OR [DWDOCID]=2953291 OR [DWDOCID]=2953290 OR [DWDOCID]=2953289 OR [DWDOCID]=2953288 OR [DWDOCID]=2953287 OR [DWDOCID]=2953286 OR [DWDOCID]=2953285 OR [DWDOCID]=2953284 OR [DWDOCID]=2953283 OR [DWDOCID]=2953282 OR [DWDOCID]=2953281 OR [DWDOCID]=2953280 OR [DWDOCID]=2953279 OR [DWDOCID]=2953278 OR [DWDOCID]=2953277 OR [DWDOCID]=2953276 OR [DWDOCID]=2953275 OR [DWDOCID]=2953274 OR [DWDOCID]=2953273 OR [DWDOCID]=2953272 OR [DWDOCID]=2953271 OR [DWDOCID]=2953270 OR [DWDOCID]=2953269 OR [DWDOCID]=2953268 OR [DWDOCID]=2953267 OR [DWDOCID]=2953266 OR [DWDOCID]=2953265 OR [DWDOCID]=2953264 OR [DWDOCID]=2953263 OR [DWDOCID]=2953262 OR [DWDOCID]=2953261 OR [DWDOCID]=2953260 OR [DWDOCID]=2953259 OR [DWDOCID]=2953258 OR [DWDOCID]=2953257 OR [DWDOCID]=2953256 OR [DWDOCID]=2953255 OR [DWDOCID]=2953254 OR [DWDOCID]=2953253 OR [DWDOCID]=2953252 OR [DWDOCID]=2953251 OR [DWDOCID]=2953250 OR [DWDOCID]=2953249 OR [DWDOCID]=2953248 OR [DWDOCID]=2953247 OR [DWDOCID]=2953246 OR [DWDOCID]=2953245

Is 139 really the limit?
Not really, from other testing I've done, I realized that if you group with (), you can get longer queries.  So, the example above stopped at 139 terms. I tried playing with picking short DWDOCID's and long ones, but the 139 was stricter than character limit.

I then tried grouping portions with ().  Sometimes 5 at a time, 10 at a time, 20, etc.  Below, using this method, I could get 328 portions by grouping it 10 at a time.

below works (6955 characters!, 10 inside each parenthesis)
([DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377) OR ([DWDOCID]=2953376 OR [DWDOCID]=2953375 OR [DWDOCID]=2953374 OR [DWDOCID]=2953373 OR [DWDOCID]=2953372 OR [DWDOCID]=2953371 OR [DWDOCID]=2953370 OR [DWDOCID]=2953369 OR [DWDOCID]=2953368 OR [DWDOCID]=2953367) OR ([DWDOCID]=2953366 OR [DWDOCID]=2953365 OR [DWDOCID]=2953364 OR [DWDOCID]=2953363 OR [DWDOCID]=2953362 OR [DWDOCID]=2953361 OR [DWDOCID]=2953360 OR [DWDOCID]=2953359 OR [DWDOCID]=2953358 OR [DWDOCID]=2953357) OR ([DWDOCID]=2953356 OR [DWDOCID]=2953355 OR [DWDOCID]=2953354 OR [DWDOCID]=2953353 OR [DWDOCID]=2953352 OR [DWDOCID]=2953351 OR [DWDOCID]=2953350 OR [DWDOCID]=2953349 OR [DWDOCID]=2953348 OR [DWDOCID]=2953347) OR ([DWDOCID]=2953346 OR [DWDOCID]=2953345 OR [DWDOCID]=2953344 OR [DWDOCID]=2953343 OR [DWDOCID]=2953342 OR [DWDOCID]=2953341 OR [DWDOCID]=2953340 OR [DWDOCID]=2953339 OR [DWDOCID]=2953338 OR [DWDOCID]=2953337) OR ([DWDOCID]=2953336 OR [DWDOCID]=2953335 OR [DWDOCID]=2953334 OR [DWDOCID]=2953333 OR [DWDOCID]=2953332 OR [DWDOCID]=2953331 OR [DWDOCID]=2953330 OR [DWDOCID]=2953329 OR [DWDOCID]=2953328 OR [DWDOCID]=2953327) OR ([DWDOCID]=2953326 OR [DWDOCID]=2953325 OR [DWDOCID]=2953324 OR [DWDOCID]=2953323 OR [DWDOCID]=2953322 OR [DWDOCID]=2953321 OR [DWDOCID]=2953320 OR [DWDOCID]=2953319 OR [DWDOCID]=2953318 OR [DWDOCID]=2953317) OR ([DWDOCID]=2953316 OR [DWDOCID]=2953315 OR [DWDOCID]=2953314 OR [DWDOCID]=2953313 OR [DWDOCID]=2953312 OR [DWDOCID]=2953311 OR [DWDOCID]=2953310 OR [DWDOCID]=2953309 OR [DWDOCID]=2953308 OR [DWDOCID]=2953307) OR ([DWDOCID]=2953306 OR [DWDOCID]=2953305 OR [DWDOCID]=2953304 OR [DWDOCID]=2953303 OR [DWDOCID]=2953302 OR [DWDOCID]=2953301 OR [DWDOCID]=2953300 OR [DWDOCID]=2953299 OR [DWDOCID]=2953298 OR [DWDOCID]=2953297) OR ([DWDOCID]=2953296 OR [DWDOCID]=2953295 OR [DWDOCID]=2953294 OR [DWDOCID]=2953293 OR [DWDOCID]=2953292 OR [DWDOCID]=2953291 OR [DWDOCID]=2953290 OR [DWDOCID]=2953289 OR [DWDOCID]=2953288 OR [DWDOCID]=2953287) OR ([DWDOCID]=2953286 OR [DWDOCID]=2953285 OR [DWDOCID]=2953284 OR [DWDOCID]=2953283 OR [DWDOCID]=2953282 OR [DWDOCID]=2953281 OR [DWDOCID]=2953280 OR [DWDOCID]=2953279 OR [DWDOCID]=2953278 OR [DWDOCID]=2953277) OR ([DWDOCID]=2953276 OR [DWDOCID]=2953275 OR [DWDOCID]=2953274 OR [DWDOCID]=2953273 OR [DWDOCID]=2953272 OR [DWDOCID]=2953271 OR [DWDOCID]=2953270 OR [DWDOCID]=2953269 OR [DWDOCID]=2953268 OR [DWDOCID]=2953267) OR ([DWDOCID]=2953266 OR [DWDOCID]=2953265 OR [DWDOCID]=2953264 OR [DWDOCID]=2953263 OR [DWDOCID]=2953262 OR [DWDOCID]=2953261 OR [DWDOCID]=2953260 OR [DWDOCID]=2953259 OR [DWDOCID]=2953258 OR [DWDOCID]=2953257) OR ([DWDOCID]=2953256 OR [DWDOCID]=2953255 OR [DWDOCID]=2953254 OR [DWDOCID]=2953253 OR [DWDOCID]=2953252 OR [DWDOCID]=2953251 OR [DWDOCID]=2953250 OR [DWDOCID]=2953249 OR [DWDOCID]=2953248 OR [DWDOCID]=2953247) OR ([DWDOCID]=2953246 OR [DWDOCID]=2953245 OR [DWDOCID]=2953244 OR [DWDOCID]=2953243 OR [DWDOCID]=2953242 OR [DWDOCID]=2953241 OR [DWDOCID]=2953240 OR [DWDOCID]=2953239 OR [DWDOCID]=2953238 OR [DWDOCID]=2953237) OR ([DWDOCID]=2953236 OR [DWDOCID]=2953235 OR [DWDOCID]=2953234 OR [DWDOCID]=2953233 OR [DWDOCID]=2953232 OR [DWDOCID]=2953231 OR [DWDOCID]=2953230 OR [DWDOCID]=2953229 OR [DWDOCID]=2953228 OR [DWDOCID]=2953227) OR ([DWDOCID]=2953226 OR [DWDOCID]=2953225 OR [DWDOCID]=2953224 OR [DWDOCID]=2953223 OR [DWDOCID]=2953222 OR [DWDOCID]=2953221 OR [DWDOCID]=2953220 OR [DWDOCID]=2953219 OR [DWDOCID]=2953218 OR [DWDOCID]=2953217) OR ([DWDOCID]=2953216 OR [DWDOCID]=2953215 OR [DWDOCID]=2953214 OR [DWDOCID]=2953213 OR [DWDOCID]=2953212 OR [DWDOCID]=2953211 OR [DWDOCID]=2953210 OR [DWDOCID]=2953209 OR [DWDOCID]=2953208 OR [DWDOCID]=2953207) OR ([DWDOCID]=2953206 OR [DWDOCID]=2953205 OR [DWDOCID]=2953204 OR [DWDOCID]=2953203 OR [DWDOCID]=2953202 OR [DWDOCID]=2953201 OR [DWDOCID]=2953200 OR [DWDOCID]=2953199 OR [DWDOCID]=2953198 OR [DWDOCID]=2953197) OR ([DWDOCID]=2953196 OR [DWDOCID]=2953195 OR [DWDOCID]=2953194 OR [DWDOCID]=2953193 OR [DWDOCID]=2953192 OR [DWDOCID]=2953191 OR [DWDOCID]=2953190 OR [DWDOCID]=2953189 OR [DWDOCID]=2953188 OR [DWDOCID]=2953187) OR ([DWDOCID]=2953186 OR [DWDOCID]=2953185 OR [DWDOCID]=2953184 OR [DWDOCID]=2953183 OR [DWDOCID]=2953182 OR [DWDOCID]=2953181 OR [DWDOCID]=2953180 OR [DWDOCID]=2953179 OR [DWDOCID]=2953178 OR [DWDOCID]=2953177) OR ([DWDOCID]=2953176 OR [DWDOCID]=2953175 OR [DWDOCID]=2953174 OR [DWDOCID]=2953173 OR [DWDOCID]=2953172 OR [DWDOCID]=2953171 OR [DWDOCID]=2953170 OR [DWDOCID]=2953169 OR [DWDOCID]=2953168 OR [DWDOCID]=2953167) OR ([DWDOCID]=2953166 OR [DWDOCID]=2953165 OR [DWDOCID]=2953164 OR [DWDOCID]=2953163 OR [DWDOCID]=2953162 OR [DWDOCID]=2953161 OR [DWDOCID]=2953160 OR [DWDOCID]=2953159 OR [DWDOCID]=2953158 OR [DWDOCID]=2953157) OR ([DWDOCID]=2953156 OR [DWDOCID]=2953155 OR [DWDOCID]=2953154 OR [DWDOCID]=2953153 OR [DWDOCID]=2953152 OR [DWDOCID]=2953151 OR [DWDOCID]=2953150 OR [DWDOCID]=2953149 OR [DWDOCID]=2953148 OR [DWDOCID]=2953147) OR ([DWDOCID]=2953146 OR [DWDOCID]=2953145 OR [DWDOCID]=2953144 OR [DWDOCID]=2953143 OR [DWDOCID]=2953142 OR [DWDOCID]=2953141 OR [DWDOCID]=2953140 OR [DWDOCID]=2953139 OR [DWDOCID]=2953138 OR [DWDOCID]=2953137) OR ([DWDOCID]=2953136 OR [DWDOCID]=2953135 OR [DWDOCID]=2953134 OR [DWDOCID]=2953133 OR [DWDOCID]=2953132 OR [DWDOCID]=2953131 OR [DWDOCID]=2953130 OR [DWDOCID]=2953129 OR [DWDOCID]=2953128 OR [DWDOCID]=2953127) OR ([DWDOCID]=2953126 OR [DWDOCID]=2953125 OR [DWDOCID]=2953124 OR [DWDOCID]=2953123 OR [DWDOCID]=2953122 OR [DWDOCID]=2953121 OR [DWDOCID]=2953120 OR [DWDOCID]=2953119 OR [DWDOCID]=2953118 OR [DWDOCID]=2953117) OR ([DWDOCID]=2953116 OR [DWDOCID]=2953115 OR [DWDOCID]=2953114 OR [DWDOCID]=2953113 OR [DWDOCID]=2953112 OR [DWDOCID]=2953111 OR [DWDOCID]=2953110 OR [DWDOCID]=2953109 OR [DWDOCID]=2953108 OR [DWDOCID]=2953107) OR ([DWDOCID]=2953106 OR [DWDOCID]=2953105 OR [DWDOCID]=2953104 OR [DWDOCID]=2953103 OR [DWDOCID]=2953102 OR [DWDOCID]=2953101 OR [DWDOCID]=2953100 OR [DWDOCID]=2953099 OR [DWDOCID]=2953098 OR [DWDOCID]=2953097) OR ([DWDOCID]=2953096 OR [DWDOCID]=2953095 OR [DWDOCID]=2953094 OR [DWDOCID]=2953093 OR [DWDOCID]=2953092 OR [DWDOCID]=2953091 OR [DWDOCID]=2953090 OR [DWDOCID]=2953089 OR [DWDOCID]=2953088 OR [DWDOCID]=2953087) OR ([DWDOCID]=2953086 OR [DWDOCID]=2953085 OR [DWDOCID]=2953084 OR [DWDOCID]=2953083 OR [DWDOCID]=2953082 OR [DWDOCID]=2953081 OR [DWDOCID]=2953080 OR [DWDOCID]=2953079 OR [DWDOCID]=2953078 OR [DWDOCID]=2953077) OR ([DWDOCID]=2953076 OR [DWDOCID]=2953075 OR [DWDOCID]=2953074 OR [DWDOCID]=2953073 OR [DWDOCID]=2953072 OR [DWDOCID]=2953071 OR [DWDOCID]=2953070 OR [DWDOCID]=2953069 OR [DWDOCID]=2953068 OR [DWDOCID]=2953067) OR ([DWDOCID]=2953066 OR [DWDOCID]=2953065 OR [DWDOCID]=2953064 OR [DWDOCID]=2953063 OR [DWDOCID]=2953062 OR [DWDOCID]=2953061 OR [DWDOCID]=2953060 OR [DWDOCID]=2953059 OR [DWDOCID]=2953058 OR [DWDOCID]=2953057) 

Has anyone else tried to figure this out?  Right now, I'm probably going to use grouping by 10/20 method, coming up with a limit of x characters or 300 searches.

Regards

 
投稿済み Mon, 11 Apr 2022 18:16:16 GMT 、投稿者 Brian Harris Director of IT
I've continued to experiment on figuring out how to get the longest possible free query based solely on DWDOCID.<br> <br> <strong>METHOD 1:&nbsp;</strong><br> Each DWDOCID are listed separated with OR statements.<br> <em>Example:</em> <table style="border-collapse:collapse; width:191pt; border:none" width="254"> <colgroup> <col style="width:191pt" width="254"> </colgroup> <tbody> <tr height="20" style="height:15.0pt"> <td height="20" style="border:none; height:15.0pt; width:191pt; padding:0px; vertical-align:bottom; white-space:nowrap" width="254"><span style="font-size:11pt"><span style="color:black"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:Calibri,sans-serif"><em>[DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380</em><br> <br> Result:<br> Maximum documents that can be retrieved is: 140.</span></span></span></span></span></span><br> <span style="font-size:11pt"><span style="color:black"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:Calibri,sans-serif">If you try to pull 141, you will get an error message of "Oops! 422 Unprocessable Entity. Wrong Query!<br> If you try to pull 480, you will get a 404 error.<br> <br> <strong>METHOD 2:</strong><br> Pairs of DWDOCID's are encapsulated in parenthesis.<br> <em>Example:</em></span></span></span></span></span></span> <table style="border-collapse:collapse; width:191pt; border:none" width="254"> <colgroup> <col style="width:191pt" width="254"> </colgroup> <tbody> <tr height="20" style="height:15.0pt"> <td height="20" style="border:none; height:15.0pt; width:191pt; padding:0px; vertical-align:bottom; white-space:nowrap" width="254"><span style="font-size:11pt"><span style="color:black"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:Calibri,sans-serif"><em>([DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378)</em></span></span></span></span></span></span><br> <br> Result:<br> Maximum documents that can be retrieved is: 274<br> If you try to pull 275, you will get the Oops! message. If you try to pull 456, you will get 404 error.<br> <br> <strong>Method 3:</strong><br> Three DWDOCID's are encapsulated in parenthesis.<br> <em>Example:<br> ([DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382) OR ([DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379)</em></td> </tr> </tbody> </table> <br> <span style="font-size:11pt"><span style="color:black"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="font-family:Calibri,sans-serif">Result:<br> Maximum documents that can be retrieved is: 408<br> If you try to pull 409, you will get the Oops! message. If you try to pull 468, you will get 404 error.<br> <br> <strong>Method 4:</strong><br> Four DWDOCID's are encapsulated in parenthesis.<br> <em>Example:<br> ([DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377 OR [DWDOCID]=2953376)</em><br> <br> Result:<br> Maximum documents that can be retrieved is: 462<br> If you try to pull 463, you will get 404 error.<br> <br> <strong>Method 5:</strong><br> Steadily increasing the number of ID's in parenthesis has marginal rate of return from this point onward with a recap of:<br> 1 - 140<br> 2 - 274<br> 3 - 408<br> 4 - 462<br> 5 - 463<br> 6 - 465<br> 7 - 467<br> 8 - 470<br> 9 - 475<br> 10 - 478<br> 11 - 482<br> 12 - 486<br> 20 - 490<br> 50 - 492<br> ​​​​​​​90 - 495</span></span></span></span></span></span><br> <br> &nbsp;</td> </tr> </tbody> </table>
投稿済み Wed, 10 Jul 2024 09:43:14 GMT 、投稿者 Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
Hi Brian,

thank you for your testing. I have just referenced this thread from here: Link

also, because the formatting in your last message broke, here it is again:
 

I've continued to experiment on figuring out how to get the longest possible free query based solely on DWDOCID.

METHOD 1: Each DWDOCID are listed separated with OR statements. Example: [DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380

Result: Maximum documents that can be retrieved is: 140. If you try to pull 141, you will get an error message of "Oops! 422 Unprocessable Entity. Wrong Query! If you try to pull 480, you will get a 404 error.

METHOD 2: Pairs of DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378)

Result: Maximum documents that can be retrieved is: 274 If you try to pull 275, you will get the Oops! message. If you try to pull 456, you will get 404 error.

Method 3: Three DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382) OR ([DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379)

Result: Maximum documents that can be retrieved is: 408 If you try to pull 409, you will get the Oops! message. If you try to pull 468, you will get 404 error.

Method 4: Four DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377 OR [DWDOCID]=2953376)

Result: Maximum documents that can be retrieved is: 462 If you try to pull 463, you will get 404 error.

Method 5: Steadily increasing the number of ID's in parenthesis has marginal rate of return from this point onward with a recap of: 1 - 140 2 - 274 3 - 408 4 - 462 5 - 463 6 - 465 7 - 467 8 - 470 9 - 475 10 - 478 11 - 482 12 - 486 20 - 490 50 - 492 90 - 495

フォーラムに投稿するためにはログインが必要です。