User FullName in animation

[IvanDeMarco97]

Hi everyone,

Is it possible to have the logged in user's fullname on a text animation?
With the USERNAME() function I only find the user's name and not the FullName of him...

Thanks!

Ivan

[BevanWeiss]

Where would you get this "user's fullname" from?
Because the GeoSCADA database doesn't contain any such field as a default.

If you want to find the FullName of the CDBUser Object, there's two ways I can think of.

1. Standard Indirect Animation.  If you know the path to your users (i.e. you only have them in one group), then you can just use =['{path to users}' + USERNAME() + '.FullName']
2. SQL Indirect Animation.  You can use =['?SELECT FullName FROM CDBUser WHERE Name = ''' + USERNAME() + '''']

[IvanDeMarco97]

Thanks for the reply.
I need to animate all objects on the page based on a user property.
The users path might change so concatenating strings is not good.
The query works but I don't like that it runs continuously (for all logged in users)...
Can I animate objects with a parameter from a built-in mimic from another layer? So I could make a script with the "Mimic_load" method and set the parameter.

Thanks!

[BevanWeiss]

I need to animate all objects on the page based on a user property.

---

This doesn't sound at all like your original request.
What is the final outcome / system requirement that you are trying to achieve?

[IvanDeMarco97]

I created a boolean Metadata on the CDBUser table.
Now I want a "Text" object to be colored green if this property is true, otherwise it is colored red.
Since I don't know the user path because it might change I'm thinking of a flexible way to do it...
I hope I have explained myself

[BevanWeiss]

Are you sure that your boolean isn't better represented as some kind of security permission (or group membership)?
Having an EXISTS("CGroup that only the right security permissions can see") animation will be far more performant than trying to look back to a dynamic user object metadata.

Other options are setting a REGISTRY value at logon or similar, you'd set the REGISTRY at Mimic_Load for the post logon display.
You could always raise a support ticket to request another function (like USERNAME()) that gets the fullname of the logged in user.  There is an Ideas forum here to do similar.