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 DocumentSELECT 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