Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 4
Registered: ‎08-15-2009
Accepted Solution

Getting Groups and Group results programmatically

Hi
 
I need to get list of account groups and for selected group, I need list of accounts Ids.
 
How do I get this info?
 
I can get list of group names, but I don't know how to get ACCOUNTIDs group produces.
 
SELECT sysdba.PLUGIN.NAME AS GroupName
LEFT OUTER JOIN sysdba.SECCODE ON sysdba.PLUGIN.USERID = sysdba.SECCODE.SECCODEID 
LEFT OUTER JOIN sysdba.USERINFO ON sysdba.PLUGIN.USERID = sysdba.USERINFO.USERID
WHERE (sysdba.PLUGIN.TYPE = 8)
AND FAMILY='Account'
 
it is for LAN client.
 
Regards
Varma
 
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Getting Groups and Group results programmatically

There are built-in functions that you can use.. it's in the dev ref help files - 

 

ex:

  Dim strGroupNames

  Const cAccounts = 1

  strGroupNames = Application.BasicFunctions.GetGroupList(cAccounts, 0, ",")

 

returns a comma sep string of all the groups in the Account Family....

.. there is also a GetGroupIDs, and GetGroupSQL, etc....

 

It's all been around for years..

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html