If you need to define a more complex filter than is possible using the Filter Builder, you can choose the Manual Filter radio button. When this option is selected, the Filter Builder is cleared from the page and an entry area is provided instead.
Type your query in the entry area. All of the date functions listed in the table shown for use in the Filter Builder can be used here, as well.
If you manually build a filter based on a Boolean field, the following values can be entered:
•True
•False
•Yes
•No
•0 (translates to false)
•1 (translates to true)
For more information on filters, visit this site: http://office.microsoft.com/en-us/assistance/HA011611751033.aspx.
•If you start defining a filter with the Filter Builder and then select the Manual Filter radio button, the Filter Builder will remain populated with your original filter for as long as you stay on the page. Nothing is brought into the Manual Filter entry area. Once you leave the Filtering page, only the manual filter is saved. Anything entered in the Filter Builder will be lost.
•If you start defining a filter with the Filter Builder and then click the Manually Edit CAML button, the filter is copied into the Manual Filter area and the Manual Filter radio button is selected. The Filter Builder will remain populated with your original filter for as long as you stay on the page, but any changes made in the Manual Filter area will not be reflected in the Filter Builder. Once you leave the Filtering page, only the manual filter is saved. Anything entered in the Filter Builder will be lost.
What this means is, there is a way to convert the contents to the Filter Builder to the Manual Filter, but not vice versa. Also, if you choose to go back to the Filter Builder after using the Manual Filter option and leaving the page, you will have to start from scratch with the Filter Builder.
•The filter that corresponds to the radio button that is selected when you leave the page is what will be saved.