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
Unfortuetly, it is a bug and which is already raised with Development. Using eQL You can't search for multiple instances of a multi-value attribute.
As a workaround I suggest to use SSRS reporting.
Answer Verified By: Alex Talbott
We use ORACLE and Business Objects so I don't think we have SSRS.
Is there a time frame on getting this fixed. This seems like a big issue. Thanks for your help.
I've recieved reply from Managers that this issue is planed to be fixed in eB version 16.3
Is there a rough estimate for the release date for this? Thanks for all of your help.
Should be fourth quarter of this year
I pulled this from the EQL guide supplied by Bentley and had not seen it suggested yet in this thread:
If documents use multi-value attributes and you want to find documents that have two or more values of a particular attribute, numerical identifiers let you distinguish among the different attribute values. Here is an eQL query for finding documents with at least two values of the Dept attribute, one set to Acct and one set to HR:
Attributes["Global", "Dept"].Value LIKE 'ACCT'
AND Attributes["Global", " Dept"].Value LIKE 'HR'
AND IsTemplate = 'N'
Meaning - Find documents with at least two values for the Dept attribute where one value is ACCT and the other value is HR.
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.