The following are a few examples of simple filters:

Include only issues whose current state is Submitted
DefectState == "Submitted"
Retrieve only new issues submitted by user jhasler
status == "New"
submittedBy == "jhasler"
Exclude all records that were submitted by users oarmstrong or hrondo
Owner != "oarmstrong"
Owner != "hrondo"
Exclude all issues that are associated with ChildProject1 or ChildProject2
Project != "ChildProject1"
Project != "ChildProject2" 

The AccuSync filter editor is similar to the Query Editor. See your AccuRev documentation for more information.