Hi Community,

I am working on augmented attribute in new Studio experience. There is a requirement that business wants to track the user who made a change to the augmented attribute. As each augmented attribute has it's own table in the data model, I am using the Changed By attribute in the view but it shows some alphanumeric value (some coded output and not an existing user).

I tried adding additional attribute with the name USER_EMAIL in augmented table where it uses USER_NAME() as PQL formula. It does show correct user email in preview of record in KM but when I try adding same column in view it throws error "PQL Error - A PQL error is preventing this query from executing.

COLUMN_REFERENCE: Column with name a"user_email"] cannot be found on table b<data model table>_AUG_<Augmented Attribute Name>]."

Is there a way to get correct username from augmented table into the view?

Any help would be appreciated.

My Best

Hamood