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
Hello Alex,
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.
Regards
Gintautas
Answer Verified By: Alex Talbott
Hi,
Let me understand the requirement.
When entering more than 1 value for Compliance doc type attribute, should only documents that contain both values be returned? or can documents be returned that contain one or the other?
And when only 1 value is entered, should only documents that contain that 1 value return? Meaning if a document contains more than 1 value for that attribute it should not return?
Thanks
Kind Regards
Natasha Pieterse
When entering only 1 value any document that contains that one value shoud be returned.
When entering more than 1 value documents should be returned that contain both values, not documents that contain one or the other.
The problem would be that eQL does not support AND clause when searching on same multi value attribute.
Query below would return 0 results even if you had Document which would meet condition of Where clause. This is related to eQL limitation.
START WITH Document
SELECT
Id
WHERE
Attributes["Global", "COMPLIANCE DOC TYPE"].Value = @ComplianceDocType1
AND Attributes["Global", "COMPLIANCE DOC TYPE"].Value = @ComplianceDocType2
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.