Filtering a dataset using multiple conditions

Ask the community
,
1

I’m trying to filter a dataset using a combination of .eq and .ge/.gt but whenever I add the .ge or .gt parameters the dataset returns no records

    $w("#dataset1").setFilter(wixData.filter() 
    .eq("cemetery", $w("#CemeteryDD").value) 
    .eq("block", $w("#SectionDD").value) 
    .eq("row", $w("#RowDD").value) 
    .gt("numeric_plot", $w("#PlotSearch").value)  <= works perfectly without this

The form field is configured:

318×634 11.1 KB

He database field is defined:


Am I missing something obvious?

2

Have you tried .gt(“numeric_plot”, Number($w(" #PlotSearch ").value)) so that it makes sure it is a number and not a string?

3

Wow, that worked … seems odd that two numeric fields combined don’t equate to a match but there you go. Thanks Andreas.