Anyone run into the "Search query is too long" issue? I have my multi-valued field searches running well, and there are 10 of them, plus another 7 or so single value field... all on a big search form. The problem is that the resulting query is too long. If you have, for example, a multi-valued checkbox field called bed_types with and a user selects all 6 options (meaning the User is ok with any of the 6 options), the resulting query is quite long, and just for this one field:
Domino-generated search query:
FIELD bed_types = King OR FIELD bed_types = Single OR FIELD bed_types = Queen OR FIELD bed_types = Twin OR FIELD bed_types = Double OR FIELD bed_types = Non-Standard
... if just 4 or 5 more search fields are selected (with multiple options checked), the "Search query is too long" message is displayed. I believe my only other option is to perform a Lotus Script search (db.search), correct?
Anyone run into the "Search query is too long" issue? I have my multi-valued field searches running well, and there are 10 of them, plus another 7 or so single value field... all on a big search form. The problem is that the resulting query is too long. If you have, for example, a multi-valued checkbox field called bed_types with and a user selects all 6 options (meaning the User is ok with any of the 6 options), the resulting query is quite long, and just for this one field:
Domino-generated search query:
FIELD bed_types = King OR FIELD bed_types = Single OR FIELD bed_types = Queen OR FIELD bed_types = Twin OR FIELD bed_types = Double OR FIELD bed_types = Non-Standard
... if just 4 or 5 more search fields are selected (with multiple options checked), the "Search query is too long" message is displayed. I believe my only other option is to perform a Lotus Script search (db.search), correct?