Search code examples
redcap

REDCap report checkbox filter

I have a checkbox field with 5 options. I want to generate a report that only shows records where any of these 5 checkboxes have been checked. What filter logic should I use?

I have tried using the following filter and it is not working:

[checkbox(1)] = 1 OR [checkbox(2)] = 1 OR
[checkbox(3)] = 1 OR [checkbox(4)] = 1 OR
[checkbox(5)] = 1
Solution

  • There is nothing wrong with your logic expression there @Bdl, privided your checkbox field is named checkbox and the choices have values 1-5.