Filter by multiple fields

@megansauer
Well, i’ll show you the right part of my CODE, wich is what you will need to get it to work…

I hope you are able to break the code down and understand it.

 //Filter-C-Boxes-------------------------------------------
 for (let a=0; a < CBoxes.length; a++) {
 //      console.log("MEMcboxes[a] = ", MEMcboxes[a])
 if (MEMcboxes[a]!==undefined && MEMcboxes[a]!=="undefined" && MEMcboxes[a]!==""){
 for (let b=0; b < MEMcboxes[a].length; b++) {
 //              console.log("MEM-AB:",MEMcboxes[a][b])
 if (MEMcboxes[a][b]!==undefined && MEMcboxes[a][b]!=="undefined" && MEMcboxes[a][b]!==""){  
                        query = await query.eq(CBoxes[a], MEMcboxes[a][b])  
                    }
 else {  }
                }
            }
 else {  }
        }
        query.find()
        .then(async res => {
            itemDATA = await res.items          
            result_COUNTER(res.length, itemDATA)
        })

And here you see the CODE in action…
https://www.media-junkie.com/pflegeservice

It’s the appearing Check-Box-Menu, which automaticaly fades in when a TAG-FIELD exsist in your DATABASE. If in your DATABASE no TAG-FIELD exist no drop-down-menu expands.

Switch between the given PRESET-DATABASES (1-3 + main-preset) and you will recognize it’s function.

You can also play around and setup the DB-PRESETs like you want. All included DATABASES in this example you will find when you click on DATABASES.

Take a look which DATA-Collections and their REFERENCE-FIELDS are given in this example. Chenge the PRESET-SETTINGS and take a look what happens.

The Settings-Menu you will find here…

This example works totaly —> DATASET-FREE!

The used element in this example are “Check-Box-Groups” …

…which represents the values of TAG-FIELDS in your DB.

Surely it would also be possible to use “Selection-Tags” instead of “Check-Box-Groups” to show the DATA from DB.