I have a report I am trying to run, but for some reason I get garbage text for half the fields I try to query.
Just wondering what might be going on here and if there is any way to fix it. It looks like the value it returns is a unique identifier (as it appears in several other key-value pairs).
I want this unique identifier but I want the actual string it is supposed to correspond to (for example this value should equal a part number, say PART12345.)
Is there a better way to run custom reports in ARAS? Can you query the SQL database directly without using their interface?
I am new to all of this, any help would be appreciated.
Example garbage value (Part Number returns ~31 character string identifier instead of the actual part number which is <10 characters.)