Hello there.
I have created a system report that searches for any container that shows as "checked out" (see below) but this returns all the files in the container rather than just the file that's checked out. Is it possible to create a report that just lists the file that's checked out? For info, we're using AssetWise ALIM.
START WITH Document SELECT Id, Code, Name, Revision, Files.Name, CurrentCheckout.Person.Status, CurrentCheckout.Person.Code, CurrentCheckout.Person.FirstName, CurrentCheckout.Person.Surname, CurrentCheckout.CheckoutDate WHERE CurrentCheckout.CheckoutDate > '01/Jan/2015' AND Files.Name NOT LIKE '%(eB Historic%' ORDER BY Code, Name, Revision, Files.Name, CurrentCheckout.Person.FirstName, CurrentCheckout.Person.Surname, CurrentCheckout.Person.Status, CurrentCheckout.Person.Code, CurrentCheckout.CheckoutDate
Many thanks
Chris
HI Chris,
Without knowing what version of ALIM you are using, I cannot guarantee the eQL below will work. It definitely works in 16.7 versions, but it could give inaccurate results in the Person values if more than one user has a file checked out on the same document.
START WITH Document SELECT Id, Code, Name, Revision, Files.CurrentCheckout.FileName, CurrentCheckout.Person.Status, CurrentCheckout.Person.Code, CurrentCheckout.Person.FirstName, CurrentCheckout.Person.Surname, Files.CurrentCheckout.CheckoutDateWHERE CurrentCheckout.CheckoutDate > '01/Jan/2015' AND Files.CurrentCheckout.FileName IS NOT NULLORDER BY Code, Name, Revision, Files.CurrentCheckout.FileName, CurrentCheckout.Person.FirstName, CurrentCheckout.Person.Surname, CurrentCheckout.Person.Status, CurrentCheckout.Person.Code, Files.CurrentCheckout.CheckoutDate
Hi Brian
Many thanks for the quick response! My apologies - we are running version 16, having been upgraded from 15.6. Your eQL has worked so I would like to take this opportunity for your help on this matter.
Regards