Department Attribute in DQL Report Displays Extra Characters

book

Article ID: 100046675

calendar_today

Updated On:

Description

Error Message

 

Cause

There is an issue with the user.department attribute from the Path object

Resolution

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

 

Issue/Introduction

When running a DQL query using the user.department from the Path object, the data is displayed with strange characters.