Filter repeat in masonry

[gunnery]

In theory this should work to filter 2 items in the masonry repeat.

<div class="row" is="dmx-masonry" id="masonry1" dmx-bind:repeat="view_members.data.repeat.where(`member_name.lowercase()`, inp_filter.value.lowercase(), 'startsWith').where(`member_surname.lowercase()`, inp_filter.value.lowercase(), 'startsWith')" columns="1" columns-sm="1" columns-md="2" columns-lg="4" columns-xl="6">

However for some reason it is not working on either first name or surname.

If I use

<div class="row" is="dmx-masonry" id="masonry1" dmx-`bind:repeat="view_members.data.repeat.where(`member_name.lowercase()`, inp_filter.value.lowercase(), 'startsWith')" columns="1" columns-sm="1" columns-md="2" columns-lg="4" columns-xl="6">

Then works but only on the first name

Does anyone have any idea where I am going wrong with this ?

[Teodor]

When pasting code in the forum please follow:

How to format code in your posts

Code Formatting When pasting code in your posts, please use the following formatting options, in order to be sure your code is readable and well formatted for the rest of the users. Inline code formatting Surround a section of code with backticks (`) inline code formatting. Typing: `var x = 10;` Results in: var x = 10; This can also be done as var x = 10; inline. Multi-Line Blocks of Code Surrounding code with three backticks ``` will allow for code to span multiple lines Typing: ``` f…

[gunnery]

oops sorry about that, is that better??

[gunnery]

Hopefully someone can give me an idea where this is going wrong so I can carry on working

[Teodor]

I see you posted the same question an year ago:

Multiple masonry filters

I have 3 search querys I would like to link to a masonry repeat. [Screen Shot 2021-12-22 at 9.11.46 am] I have it working on one with no issues at all. div class=“row” is=“dmx-masonry” id=“masonry1” columns-sm=“1” columns-md=“2” columns-lg=“4” columns-xl=“4” dmx-bind:repeat=“view_orders.data.repeat.where((query1[0].firstName.lowercase() || query1[0].surName.lowercase()), inp_filterName.value.lowercase(), ‘fuzzySearch’)” What I need to be able to do if filter the above by either Customer N…

[gunnery]

you are correct I did ask the same thing and I have tried everything that is one there, but it is not working. It will work with one, but as soon as I add the other one they BOTH stop working.
This is where I am stuck as it should be working but it is not.

[patrick]

Could you explain what filter you want to exactly apply.

In the first expression you say: Filter view_members.data on member_name starts with inp_filter and member_surname starts with inp_filter.

I don’t think there are many members where both name and surname start with the same characters.

Internally the expression first executes the first where formatter and returns the filtered result and then the filtered result is passed to the second where which will then filter that even further.

I think for your situation it is better to use the Data View component, give view_members.data as Data Source and in the Filter use

member_name.lowercase().startsWith(inp_filter.value.lowercase()) || member_surname.lowercase().startsWith(inp_filter.value.lowercase())

The bind the data property from the Data View to your masonry repeat.

The advantage of the Data View is that you can have more complex filter, sorting and paging support.

[gunnery]

so what I want to be able to filter the list by either the first name (member_name) or surname (member_surname)

Cheers @Patrick that worked like a charm