There is an issue with the user.department attribute from the Path object
You can retrieve the correct results using the user.department attribute from the Owner object instead
Examples:
Incorrect result:
FROM path
GET basename,
owner.user.name,
owner.user.department,
size as capacity
IF msu.containers = "3D" AND
type ='file'
format owner.user.department as csv
limit 10
Correct result:
FROM owner
GET path.basename,
user.name as Owner_Name,
user.department,
path.size as capacity
IF path.msu.containers= "3D" AND
path.type= "file"
format user.department as csv
limit 10