Modern Text Search in AL and Business Central

Find more information at my blog www.hougaard.com or follow me on bsky.app/profi...
(Yes, sound is messed up, I have some new equipment ordered, so hopefully, this should be the last video with sound issues).
Source code can be found here: github.com/hou...

[@tristancliffe]

I've got a few custom fields. Let's say it's "Wife's Name" in the customer table. I have been unable to add OptimizeForTextSearch to that (or multiple) fields in AL - if I try, it gives an error (with not many details).
Does it work for you? (You might need to use your text generstor to fill the field with searchable data of course).

[@drewkipfer5404]

Same here

[@guidorobben6259]

There is difference in record count, so one has to loop more records.

[@npu3paka2]

I cannot wrap my mind around the &&. It’s like the universe is saying, 'Here, have some logic, but only if you really deserve it. Can someone explain what kind of wizardry makes &&keyword spit out its results and what is the meaning? Is it ANDing my soul with confusion?

[@YannSaintLaurent]

Yes please! What does the “&&” do?
I searched online but couldn’t find an answer. Thanks

[@DarkEsproc]

&&hoff*&&&erik* actually makes sense if the new "&&" operator means "at the beginning of a new word ..."
makes search a little more regex 🤣