This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

user manager update

Hi All,

I have one user custom field that containing the user manager "personnelnumber" information .According to this attribute,i want to update the user manager field value"UID_PersonHead".

example.Created one user xyz and custom field value update as 6767

If any user exist in person table with personnelnumber=6767 then this user name should update as Manager of XYZ user.

Can you please suggest?Trying to update manager template but it is not working

Regards,

PS

Parents
  • Yes,I know the UID_Personhead attribute ,I am calling below function form this attribute template but this is not working while when I am testing this script from test tool it is getting correct result.I am not sure that is it problem with custom field ?

    Here "Q1C_SupervisorID" is my custom field.

    Public Function QDC_VI_AssignManager( ByVal Q1C_SupervisorID As String) As String

    Dim f As ISqlFormatter = Connection.SqlFormatter
    Dim strWhere As String=f.Comparison("PersonnelNumber",Q1C_SupervisorID,ValType.String)


    Return connection.GetSingleProperty("Person","uid_person",strWhere).String

    End Function

    Regards,

    PS

Reply
  • Yes,I know the UID_Personhead attribute ,I am calling below function form this attribute template but this is not working while when I am testing this script from test tool it is getting correct result.I am not sure that is it problem with custom field ?

    Here "Q1C_SupervisorID" is my custom field.

    Public Function QDC_VI_AssignManager( ByVal Q1C_SupervisorID As String) As String

    Dim f As ISqlFormatter = Connection.SqlFormatter
    Dim strWhere As String=f.Comparison("PersonnelNumber",Q1C_SupervisorID,ValType.String)


    Return connection.GetSingleProperty("Person","uid_person",strWhere).String

    End Function

    Regards,

    PS

Children
No Data