While searching for any document, in the search result I also want related 'Project Number' column to be visible along with the usual columns like number, title, revision etc.
Is there any eQL query or report which I can edit coz that will be more helpful?
Try below for eB version 15.6:
START WITH Document SELECT Id, Code + ' ' + IFNULL( Middle, '' ) Number, Revision, Name, Projects.Project.Name, Class.Path, ApprovalStatus, DISPLAY_NAME( ApprovalStatus ) ApprovalStatusDisplay, State, DISPLAY_NAME( State ) StateDisplay, DateEffective, Scope.Name WHERE ( Code LIKE @SearchString OR Middle LIKE @SearchString OR Name CONTAINS @SearchString ) AND IsTemplate = 'N' ORDER BY Code, Middle, Revision
Hi Manav,
Thankyou for the query, it really helped.
But what I want is 'Project No.' to be added among the columns (PNs and JNs) and not necessarily the project name.
So I just edited your query and added Projects.Project.Code instead and it was successful. Thanks for helping out.
Good to hear that - Could you please mark the eQL post as answered.Have a nice day!