Skip to main content
A
aarasan-31-Visitor
1-Visitor
June 12, 2017
Question

How to get list of groups from Site level

  • June 12, 2017
  • 1 reply
  • 1607 views

Hi,

Is there an API through which I enumerate the list of all available groups in my Windchill. I'm able to do this through an Oracle Query from the Database but still would like to know if this can be achieved through any available API, rather than going through the process of having a read only account for Database and resolving the Database query from my code.

Thanks in advance!

Amarkarthi

1 reply

B
BineshKumar11-Visitor
1-Visitor
June 12, 2017

Similar to SQL, you can use query spec to get this information.

qs = new QuerySpec(WTGroup.class);  


   SearchCondition sc1 = new SearchCondition(WTGroup.class,  


   WTGroup.INTERNAL, SearchCondition.IS_FALSE);  


   qs.appendWhere(sc1);  


   QueryResult qr = PersistenceHelper.manager.find(qs); 


   while (qr.hasMoreElements()) {  


   


     WTGroup group = (WTGroup) qr.nextElement();  


   if (group.getName().equals("ORG ADMIN")){  


   continue;  


   }  


   if (!group.isDisabled()) {  


   getMembers(group.getDn(), group);    


   }  


   }  


   } catch (WTException ex) {  


   ex.printStackTrace();  


   }  


   generateReport();


   } 
Terms & ConditionsAccessibility statement