AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Hi Sree, would I have to run the script that you sent the last, only once as TDAdmin and that should help me populate the names, right. Then If I happen to add any new users, I would probably have to run it again. Am I right in stating that. Also, Your code for the other Assigned To Full name worked that you suggested to Rajesh Haldar. But would it take effect only for new defects or changed defects. How can I set it up for all my older defects also. I need to set the Detected By Field also similary and I tried the code for the same too. Vladimir and Sree, Thanks for all your help.
0 Likes
SreeKrishnan Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Yes you need to run the script just once to populate the US_FULLNAME on the users table. I would suggest you comment out the script after you run once and make it availabel whenever you need it to synchronize the user table.

The other way to keep this away from the QC worklow is to have a external VB script. The script will be similar to the one on the post with minor changes.




0 Likes
SreeKrishnan Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Try this out for the existing defects
I have BG_USER_01 (user defined field for Assign To), BG_USER_02 (user defined field for detected_by). You need to replace BG_USER_01 and 02 with the user defined fields that you created in your project.

Also just run this once and comment out the code pl.

Note: You need the UserFullName function from the earlier post for this script to work. If you have already got this on your workflow have it available for this script to work.


Enter this one under Function CanLogin(DomainName, ProjectName, UserName)


If User.IsInGroup("TdAdmin")Then
Set tdc = TDConnection
Set com = tdc.command
Set com1 = tdc.command
com.CommandText = "Select * from BUG"
Set recset = com.Execute

while recset.EOR = 0
com1.CommandText = "Update BUG set BG_USER_01 = '" & UserFullName(recset("BG_RESPONSIBLE")) & "' , BG_USER_02 = '" & UserFullName(recset("BG_DETECTED_BY")) & "' where BG_BUG_ID = '" & recset("BG_BUG_ID") & "' "

Set recset1 = com1.Execute
recset.next
wend
Set recset = nothing
Set recset1 = nothing
Set tdc = nothing

End If
0 Likes
AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Thanks Sree,
I will try them out and let you know if it worked. I should essentially try both the codes that you sent right?, the last one and the one before last in order for it to fully function well.
0 Likes
SreeKrishnan Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
The last one is for having the user fullname on the existing defects thru user defined fields.

The script to populate the user full name on the users table for your reporting purpose (or that is what I understood).

Note: Once you have the user defined fields for Assign To and Detected_By with user full name, you can hide the system fields BG_RESPONSIBLE and BG_DETECTED_BY from the defect screen.

Also you should be able to attach a custom list(drop down lists) that has user full names to the user defined fields. The posting initiated by Rajesh Halader has the info
0 Likes
AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Thanks Sree, I will check it out and let you know.
0 Likes
AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Thank you Sree and everyone. That worked for me. Hopefully my issue is resolved for now.
0 Likes
Highlighted
Logen Watkins Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
My problem seems very related to this one...I want to be given a list of the email addresses of every user in my project -- whether it be in the form of a word file, spreadsheet, or even maybe in the comments field of a particular defect.
Normally to get information about a user I do something along the lines of

Set c_user = cust_users.User(UserID)
UserFullName = c_user.FullName

Which I was shown earlier. So in this case I'd be grabbing .Email instead of .FullName.

Is there any way to cycle through the entire list of users? I see that there is a .Users member which is supposed to give a list, but it is either not returning what I thought it would, or I am accessing it incorrectly because I cannot get user objects out of it.
0 Likes
SreeKrishnan Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Logen,

Script that can give you the user properties, full name, email, phone ...

Dim custUsers
Dim custUser
Set Td = TDConnection
set cust = td.Customization
cust.Load

set custUsers = cust.Users
set custUser = custUsers.User(TD.UserName)

MsgBox (custUser.Phone)

MsgBox (custUser.Email)
MsgBox (custUser.FullName)

Set TD = Nothing
0 Likes
AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Hi Sree,
Is there a way you can explain it for existing users to be updated with email address just like the full name above. thanks.
0 Likes
SreeKrishnan Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Are you talking about the Users Table,US_EMAIL_ADDRESS ?
0 Likes
AKR Absent Member.
Absent Member.

Re: Which Table can I Find the Project Users List with User ID and Full Name unde QC.

Jump to solution
Yes Sri,
Just similar to how you had given a script earlier to add Full Name to the USers Table, I would require some code to add the email address, phone number etc., under the users table. I can run the code for both existing users and new users to ensure all email IDs show up under the Users table for me to report from.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.