Forum Discussion

Former_Member's avatar
Former_Member
Ideator I
8 years ago

User type of field mapping table

Hi, When I query Part table, I get GUIDs of Assigned Creator and Designated User (User type fields) from owned_by_id and managed_by_id columns respectively. I need to convert these GUIDs into actual user name value, so I queried innovator.User table with Id = Guid as condition, but I dont find any row related to that Guid. I also tried with config_id = Guid in User table but still same problem. Should I use some other table to get the actual user name?? I guess ARAS Innovator stores User details in innovator.User table.   Thanks.
User Management

5 Replies

  • Zahar_Chernov's avatar
    Zahar_Chernov
    Ideator I
    8 years ago
    Assigned Creator and Designated User are both of type Identity and not User  
  • Former_Member's avatar
    Former_Member
    Ideator I
    8 years ago
    oops ... My bad...Thank you Zahar for this info, could you please tell then, why User table is being used in Innovator??
  • Former_Member's avatar
    Former_Member
    Ideator I
    8 years ago
    I still have one confusion, when I open Assigned Creator lookup, I find those items which are present in User table... I know those are also present in Identity table (I mean it looks like, User table is a subset of Identity table)...
  • eli_donahue's avatar
    eli_donahue
    New Member
    8 years ago
    Hi Kovair, Every user has an identity with the same name and property is_alias=1. This alias identity is what allows admins to add users to group identities. Assigned Creator and Designated User are Identity properties so you can either assign a single person (is_alias=1 Identity) or a group Identity. Eli
    Eli Donahue Aras Labs Software Engineer
  • Former_Member's avatar
    Former_Member
    Ideator I
    8 years ago
    Hi, Please help me. I have linked the workflow to part item. When i am creating the new item in the part i have selected user in designated user field type. But i did not get any task. Usually when we select the designated user in the part form while creation of item then task to should come to MyInbasket for the user which we have selected in the designated user field type. other wise we should mention in the workflow itself?