What I normally do is add something like
AND | (@WHERE:PARAM:USER_DEF:INTEGER:z_act@ = inv.is_active OR @WHERE:PARAM:USER_DEF:INTEGER:z_act@ is null) |
to the filter section of the query and then assocate the param_z_act with the Yes No All lookup which is of type
<staticLookup autoSuggestEnabled="true" autoSuggestMaxSuggestions="10" code="Z_YES_NO_ALL" hiddenAttributeName="lookup_enum" sortStyle="alphanumeric" source="niku.com" status="active" update="true"><nls description="" languageCode="en" name="Yes No All"/>
<lookupValue code="0" enum="0" sortOrder="0" status="active"><nls description="" languageCode="en" name="No"/>
<lookupValue code="1" enum="1" sortOrder="0" status="active"><nls description="" languageCode="en" name="Yes"/>