Hello everyone
I have created the following eQL statement, which I constructed to help me find a particular file format. I'm trying to add a WHERE statement that only displays results / entries where "Files, Name" appears in the AuditDetails.Properties.Description column. However, I'm not sure how to achieve this. I've tried "AuditDetails.Properties.Description LIKE 'Files, Name'" but I get an error message in ALIM front end that reads "Error parsing the eqlText. For more information see the ParseResult.Errors. The FirstError was: The Criteria does not support PseudoColumn 'AuditDetails.Properties.Description'." I'm wondering if the LIKE statement is not the correct one to use for this particular field / column. Does anyone have any ideas? Is what I'm trying to do achieveable?
START WITH Document SELECT Id, Name, Code, ApprovalStatus, Attributes["Global", "Suitability Status"].Value, Files.Name, Files.FileFormat.Name, AuditDetails.Person.FirstName, AuditDetails.Person.Surname, AuditDetails.Properties.Description, AuditDetails.AuditDate WHERE Files.FileFormat.Name LIKE 'UNKNOWN MIME TYPE' ORDER BY Name
Kind regards
Chris
Hi Chris,We dont have to use any function as LIKE to change in display of the result. Please try below:AuditDetails.Properties.Description File_Name
It should change the display. Please check the below screen shot where I changed different labels show in result:
Please let me know if this is what you are looking for.