NetTalk Central

Author Topic: Maximum size of NetWebBrowse search  (Read 2986 times)

Ubaidullah

  • Full Member
  • ***
  • Posts: 125
    • View Profile
Maximum size of NetWebBrowse search
« on: March 29, 2021, 03:32:41 AM »
Hi Bruce,

What needs to be done to increase the length of the search filter in a NetWebBrowse? When the user types in a lot of text with spaces in between the filter (as seen in debugview) seems to cut off around the 500th character.

This is what the user is entering:
00669150 02802890 03389270 04004062 04004080 04114808 04698577 4698884 04701244 04710046 04710050 04818098 04818118


And, this is what I am seeing in DebugView:
Filter: ( INSTRING('00669150',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('02802890',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('03389270',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04004062',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04004080',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04114808',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04698577',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('4698884',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04701244',UPPER(ITEM:NUMBER),1,1) <> 0 OR INSTRING('04710046',UPPER(ITEM:NUMBER),1,1) <> 0)


The last two terms are missing.

I would like to either increase the filter length or write my own SQL filter. With the SQL filter, the search could be a lot more shorter.

Regards,
Ubaidullah Nubar.

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Maximum size of NetWebBrowse search
« Reply #1 on: March 29, 2021, 09:31:52 PM »
Hi Ubaidullah,

you absolutely can create your own filter constructor and optimize it for your backend and use case.
The code is in p_web.MakeFilter.
You can find the original code in netweb.clw, but feel free to override it with whatever you like...

that said, I've bumped it in 12.12 so the returned filter can be any length.

cheers
Bruce