# Having a note type with over 127 fields and the "Exclude from unqualified searches (slower)" option enabled causes regular expression browser searches to fail

**URL:** <https://forums.ankiweb.net/t/having-a-note-type-with-over-127-fields-and-the-exclude-from-unqualified-searches-slower-option-enabled-causes-regular-expression-browser-searches-to-fail/43536>\
**Category:** Help\
**Created:** [April 12, 2024, 11:46pm UTC](https://forums.ankiweb.net/t/having-a-note-type-with-over-127-fields-and-the-exclude-from-unqualified-searches-slower-option-enabled-causes-regular-expression-browser-searches-to-fail/43536 "2024-04-12T23:46:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CoreyCV](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@CoreyCV](https://forums.ankiweb.net/u/CoreyCV)\
**Post date:** [April 12, 2024, 11:46pm UTC](https://forums.ankiweb.net/t/having-a-note-type-with-over-127-fields-and-the-exclude-from-unqualified-searches-slower-option-enabled-causes-regular-expression-browser-searches-to-fail/43536/1 "2024-04-12T23:46:01Z")

</div>

I am using anki-24.04-linux-qt6. If I have a note type that has over 127 fields and the “Exclude from unqualified searches (slower)” option enabled on one of those fields, then a browser search that uses the `w:` prefix or the `re:` prefix will produce a popup. On a small test collection the following message was produced:  
  
DbError { info: “SqlInputError { error: Error { code: Unknown, extended\_code: 1 }, msg: "too many arguments on function regexp\_fields", sql: "select c.id from cards c, notes n where c.nid=n.id and (((n.mid = 1712616038666 and regexp\_fields(?1, n.flds, 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131)) or (n.mid = 1712957410517 and n.flds regexp ?1) or (n.mid = 1712957838650 and n.flds regexp ?1) or (n.mid = 1712957410518 and n.flds regexp ?1) or (n.mid = 1712957410519 and n.flds regexp ?1) or (n.mid = 1712957410520 and n.flds regexp ?1) or (n.mid = 1712957410521 and n.flds regexp ?1) or (n.mid = 1712957410522 and n.flds regexp ?1))) order by n.sfld collate nocase asc, c.ord asc", offset: 84 }”, kind: Other }  
  
On my main collection it produces a longer message. The workaround I’m using is to simply have the option disabled on all fields of the related note type.

---

<div class="post-metadata">

**Author:** ![dae](https://sea2.discourse-cdn.com/flex002/user_avatar/forums.ankiweb.net/dae/32/65_2.png) [@dae](https://forums.ankiweb.net/u/dae)\
**Post date:** [April 13, 2024, 8:31am UTC](https://forums.ankiweb.net/t/having-a-note-type-with-over-127-fields-and-the-exclude-from-unqualified-searches-slower-option-enabled-causes-regular-expression-browser-searches-to-fail/43536/2 "2024-04-13T08:31:28Z")

</div>

Appreciate you letting us know, but I’m afraid this is unlikely to be fixed in the near future, as few users are going to hit it.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/1X/8f1279ababc5879d54e4838989f606cfe55af8c7.jpeg) [@system](https://forums.ankiweb.net/u/system)\
**Post date:** [May 13, 2024, 8:31am UTC](https://forums.ankiweb.net/t/having-a-note-type-with-over-127-fields-and-the-exclude-from-unqualified-searches-slower-option-enabled-causes-regular-expression-browser-searches-to-fail/43536/3 "2024-05-13T08:31:54Z")

</div>

Closed on May 13, 2024, 8:31am UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
