cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Strange groups in WTGroup Table.

psampath
1-Newbie

Strange groups in WTGroup Table.

Experts, I was working on a code for fetching WTGroups and I saw some strange values being returned by the code. On checking the DB I saw weird group names in the database as well. These groups are not present in the UI. Any idea what these are? I also wrote a query builder report to query all WTGroups. It also returns the same.ScreenShot035.jpgScreenShot036.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

These are deleted groups. When a group is deleted from Windchill, most of the DB entries related to the group are deleted. However, Windchill keeps the entry in the WTGroup table, but makes two modifications to it. First, the name of the group is updated to be '{wt.org.WTGroup:<idA2A2>}<Name>'. Then, the value of the 'disabled' column is set to 1. The same is also done when users and orgs are deleted.

Whenever Windchill does any query for users/groups/orgs, the query always includes the predicate 'disabled=0', so that only valid groups are returned. If you want your code to ignore these groups, then you should modify it to only query for groups with a value of 0 in the disabled column.

View solution in original post

5 REPLIES 5
syadala
5-Regular Member
(To:psampath)

These are the groups created either for at site or at Org or container level, which are not visible to users But required as part of the System. you can ignore them.

Hi Sudhakar,

                   Thanks for your prompt reply. I am developing a utility to replace one user with the another in All WTGroups when he leaves the Organization. If what you say is true then I Will have to replace the user in those groups as well. As, when I query all groups for that user these groups are returned as well and I assume I Will have to replace the user in those groups as well. Correct me if I am wrong.

Thanks.

Praveen

syadala
5-Regular Member
(To:psampath)

Hi Praveen,

         I don't think there will be users in those groups. I had developed a utility like that in past. we need to replace the user other than those groups. If you have Project link you need to replace in project template also.

Regards

Sudhakar

These are deleted groups. When a group is deleted from Windchill, most of the DB entries related to the group are deleted. However, Windchill keeps the entry in the WTGroup table, but makes two modifications to it. First, the name of the group is updated to be '{wt.org.WTGroup:<idA2A2>}<Name>'. Then, the value of the 'disabled' column is set to 1. The same is also done when users and orgs are deleted.

Whenever Windchill does any query for users/groups/orgs, the query always includes the predicate 'disabled=0', so that only valid groups are returned. If you want your code to ignore these groups, then you should modify it to only query for groups with a value of 0 in the disabled column.

BhushanNehe
14-Alexandrite
(To:ChrisSpartz)

To avoid disabled groups in your results , you can append following search condition to QuerySpec in your customization:

qs.appendWhere(new SearchCondition(WTGroup.class, WTGroup.DISABLED,SearchCondition.IS_FALSE )

Top Tags