Getting Groups and Group results programmatically

[vbhupatiraju]

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'

ORDER BY sysdba.PLUGIN.NAME

it is for LAN client.

Regards

Varma

[RJLedger · Accepted solution]

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..