This module provides two blocks one with a drop down list that allows for multiple selections and another block that will list items and provide users a way to make multiple selections. 

There is the option to select all / none which can be set on the block properties as well as a property to default all options as selected or unselected.  The blocks return the list of selected items along with text which can be used within a SQL in clause for advanced SQL