How to filter a list and show only active items

Legacy Contributor

Trying to understand how to use a checkbox(Yes/NO) and once selected filter/show only active items. 

tdickens

This is how we have accomplished that.

1.  Have a checkbox titled "Active Only" on the form.

2.  Have a Data Change event for the checkbox.

3.  The Data Change event executes a Form Script method named: ChangeActiveOnly

4.  The Form Script method looks like this:

public void ChangeActiveOnly()
{
string activeOnly = ThisForm.Components["chkActiveOnly"].Value.ToString();
if (activeOnly == "1")
{
ThisForm.Variables("vActiveOnly").SetValue("Yes");
}
else
{
ThisForm.Variables("vActiveOnly").SetValue("No");
}
}

5.  The Permanent Filter Express looks like this:

DueDate >= FV(vBegDate) AND DueDate <= FV(vEndDate) AND (WorkflowStatus NOT IN ('Approved','Rejected') OR FV(vActiveOnly) = 'No')

6.  The Data Change even also executes the ClickRefresh event.  The ClickRefresh event is just a Collection Refresh.