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

Hi Alex,

I used below query and it gives me all the document contains either attribute or both:

I got below result where three documents mentioned with all three posibilities:

Note: I tried the above query on 15.6.1.

I apologize, that my original post is not completely clear and my eQL statement is miss leading.  The EQL statement that I posted works in 15.5.1 but it is when I switch it to an AND that I get no results and therefor doesn't work.  Can you please try your example with an AND and see if this has been resolved in 15.6.1.  If you have access to 16.3.1 and could test there as well it would be a huge help.  I was told that it would be resolved there but have not seen anything officially.  Sorry for the confusion.

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

Hi Alex,

after changing it to AND, its still working on both 15.6.1 and 16.3.1 for me.
Only in one condition I am not able to get the result, when I Check Box for both, but pass the parameter only for Name:

Could you please share the screen print as above, to check what went wrong.

HI Alex,

while working another SR related to the multivalue search issue similar to one reported here I found you has asked for official confirmation of fix in later version. I have confirmed that this was fixed for eB16.3 and higher versions.

thanks,

Roberto Garcia