Filtering data with a checkbox

Wappler General How To
#1

I tried to filter a recordset with only one checkbox, but that doesn’t work. It looks like changing the checked state of the checkbox is not passing any values to the serverconnect. Maybe this code is not correct?:

...
          <form id="form1">
            <div class="form-group">
              <div class="form-check">
                <input class="form-check-input" type="checkbox" value="1" id="aktiv" name="aktiv">
                <label class="form-check-label" for="aktiv">Filter Aktiv</label>
              </div>
            </div>
          </form>
         ...
 <dmx-serverconnect id="serverconnect1" url="../../../../dmxConnect/api/CMS/cms-ad/de/Aktuell/News/NewsDataTable.php" dmx-param:aktiv="form1.aktiv.value"></dmx-serverconnect>
...
Filtering Database Query with Multiple Checkboxes
#2

Hi Andre,
What’s the reason to use the form with a separate server action/with GET variable instead of server connect form?

#3

Hi Teodor. I’m not doing updates with the form, just filtering a DataTable.

#4

Try using a checkbox group component for that.
Then assign the checkbox group value as a get param value.
The checkbox group value will change when the checkbox is checked/unchecked.

#5

What do you mean exactly with «Then assign the checkbox group value as a get param value.»? Do I have to do this with an event?

#6

Just select the checkbox group value as a value in the data picker :slight_smile:

#7

I cannot select the value of the group only of the checkbox itself and then no value is passed.

#8

Hi Andre,
Are you sure you added the component called “Checkbox group”? Its value can easily be selected in the data picker:

Screenshot_10
Screenshot_10.jpg684×1311 120 KB

#9

ok finally got it. So I add value=1 to the group and bind the input parameter (for the GET) in the server connect to group field value? Like this?

15
Bildschirmfoto 2019-03-05 um 09.01.15.png1814×1326 421 KB

#10

No, you should select the checkbox group value - it changes when the checkbox gets checked/unchecked:

Screenshot_13
Screenshot_13.jpg467×696 57.5 KB

And you should set the checkbox value to 1. No value should be set to the group itself.
The checkbox group component value changes dynamically, depending on what the checkbox(es) value(s) insider is(are). If you have one checkbox with a value of 1 then, when you check it, the group value becomes 1.

#11

Finally works, thanks Teodor. The required checkbox group structure for this case has to be like this (just in case anyone else needs this):

16

51
Bildschirmfoto 2019-03-05 um 10.07.51.png811×181 33.7 KB

Or choose

Screenshot_20

and remove the not needed checkboxes

#12