Is is possible to change the value (or ignore) of a Data View filter based if a checkbox is checked.

I want to apply a filter (isActive == 1) if a checkbox has been checked, but show all records if it has not. Can I add that condition to my data view?

<dmx-data-view id="student_view" dmx-bind:data="students.data.students" sorton="UserLastName" page="studentPage" pagesize="15" dmx-bind:page="query.studentpage" filter="isActive == 1"></dmx-data-view>

Hi Lee,
Is the "isActive" the filter itself or would you like to use it in order to trigger another filter?

isActive is the filter, it is a field in the record (value either 0 or 1). There is a checkbox input on the page ( id="displayAll", checked value = 1).

I wanted to use the 'checked' property to ignore the filter (or, if it's easier, to uncheck the box to hide records with is active == 0)

What should happen on your page when the checkbox is checked and what when it is not checked?
* Checked = show only isActive == 1
* Unchecked = show only isActive == 0

Is that right?

Checked no filter show all records ( isActive == 0 AND isActive == 1) unchecked show only isActive == 1.

I could re-arrange it in another manner if that makes it easier to accomplish. The goal is to be able to hide records that are marked as inactive.

Lee i am not really sure i understand you. Your first post says one thing, your last one says another thing. Once again - what should happen when:

- Checkbox is not checked - which records should be displayed?
- Checkbox is checked - which records should be displayed?

If the box is not checked, display isActive == 1
If the box is checked, display isActive == 1 AND isActive == 0 (ALL records, i.e. NO filter)

I think this should work as a filter for your data view:

displayAll.checked.then(isActive , isActive == '1')

No results are returned when I use that as a filter.

Oops, it did work perfectly. Thank you. (I had a typo in the filter definition!)

Is it possible to build that filter-string using the [lightning bolt] picker?

Can you send a link to your page please? Maybe the app connect data formatter includes are not on the page - try formatting something small just to get the includes on the page first.

Thank you, it worked perfectly (once I corrected a typo). Is it possible to build that filter-string using the [lightningbolt] picker?

This reply was removed on 12/19/2017 5:36:21 PM.
See the changelog

Yes, just use the "then" filter.

yes it is easy to do if you are from movies programming background