Portal Filtering

[Matt Malyschko]

I have a field in a portal that I wish to filter by, let's call it Time.

Time may be 8am, 9am, etc.

I have created a field called FilterTime, which contains values: 8am, 9am, etc. etc. and displayed it as a checkbox set across the top of the portal.

Obviously, I want the records in the portal to display when they match the selected filters.

I have the filter set up to filter records as shown:

If ( IsEmpty(FilterValues(Items::Time; Protocols::FilterTime)) = False; 1; 0)

This works fine.

However, I also want an 'all' field in the filter, which will display all the times. Evidently, the filtervalues does not return anything because there is no 'All' time in the list of items.

Please help?! :D

[comment]

However, I also want an 'all' field in the filter, which will display all the times.

Did you mean an 'all' value? If so, try =

not IsEmpty ( FilterValues ( Items::Time ; Protocols::FilterTime ) ) 

or

Protocols::FilterTime = "All"

Or you could use =

not IsEmpty ( FilterValues ( Items::Time ; Protocols::FilterTime ) ) 

or

IsEmpty ( Protocols::FilterTime )

which will apply the filter only if a value is checked - otherwise all related records will be shown.

[Matt Malyschko]

Did you mean an 'all' value? If so, try =

not IsEmpty ( FilterValues ( Items::Time ; Protocols::FilterTime ) )

or

Protocols::FilterTime = "All"

Or you could use =

not IsEmpty ( FilterValues ( Items::Time ; Protocols::FilterTime ) )

or

IsEmpty ( Protocols::FilterTime )

which will apply the filter only if a value is checked - otherwise all related records will be shown.

Thanks!