Creating a report that allows searching a Fixed Value Multi Value attribute.

I am trying to create a report that easily allows a user to enter one or more values of a Fixed Value Multi Value attribute.  We are useing eB 15.5.1.  The name of the attribute is "Compliance Doc Type".  Is there away to allow the user to specify one or more of the values that they want the document to have in a report?  All of my attemps have failed.  The below eQl returns 48 documents or all of the ones that have one or the other values.  If I replace the OR with an AND I get 0 documents returned.  Thanks for your help in advance.

 

START WITH Document
SELECT
   Id,
   Attributes["Global", "DOC DATE"].Value,
   Name,
   Class.Name
WHERE
   (
      Class.Name = 'COMPLIANCE REPORTS'
      OR Class.Name = 'COMPLIANCE CORRESPONDENCE'
      OR Class.Name = 'PERMIT MANAGEMENT'
   )
   AND        (
          Attributes["Global", "COMPLIANCE DOC TYPE"].Value = @ComplianceDocType1
          OR Attributes["Global", "COMPLIANCE DOC TYPE"].Value = @ComplianceDocType2
       )
   AND Name LIKE @TITLE
   AND Attributes["Global", "REPORT NAME"].Value = @ReportName
   AND Attributes["Global", "DOC DATE"].Value > @DocDate1
   AND Attributes["Global", "DOC DATE"].Value < @DocDate2
ORDER BY
   Attributes["Global", "DOC DATE"].Value

Parents Reply Children
No Data