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