Hi,

How do I make Fuzzysearch search more than one field, my code is as follows but from within the data formatter > where > property I can only select one data field?


<div class="row machine-box" dmx-repeat:repeat1="serverconnect1.data.cat_id_Query.where(`age`, searchyear.value, &quot;fuzzySearch&quot"></div>

Hello Charlie,
It is not possible to apply where filter to more than one column. Just do this on the server side instead, using the contains filter - in the query builder.

Hi Teodor

Would I create a new seperate query just for the search/filter, is there a tutorial on how this might be achieved please?

No need of a separate query - just filter your current query: www.dmxzone.com/go/32764/dmxzone-app-connect-manual/32768/filtering-a-query-with-text-input

Thank you Teodor, using the 'filtering a query with text input' worked great.

A note for anyone reading this, you can have several GET Variables in your server action, I have one for filtering the records by category first then another for the query by text input on the results page. Actually in the Server Action query builder I added four table fields making sure to change And to Or - works like a treat!

Yes, that is exactly how it is supposed to be setup.