Hello! We have Appian running with SQL server backend, and I want to find out where is user's first name and last name is stored. I searched all the tables but I can't seem to find it (I only see a table called dbo.usr, which only has the username, but no columns for first name and last name, and other fields such as Nickname/Email/City/State/Country/etc). Is this something stored in the database at all, and if not, where can I locate those data?
Thanks in advance!
Discussion posts and replies are publicly visible
Interestingly, the user information isn't actually stored in a database at all; instead, it's stored in the Personalization Engine. The engines are in-memory data sources that can only be queried using Appian UIs.
Can you talk a bit more about your question - what are you hoping to do with this data? There are lots of ways to expose user information depending on your use case.
Interesting! My team and I want to find a way to retrieve the first name and last name, so that we can use them in our database views to perform ORDER BY operation. We want to add functionality to sort by user's first or last name.
Ah yeah that makes sense - unfortunately there isn't a great work around for this. I've seen customers that have created their own user table / CDT that stores this information so that you can more easily join on it, but unfortunately there's no way to directly sort by the data from the user information stored in Appian.