Ad-Hoc Group Storage

[npepin]

I've had a request to monitor and send active updates to users based on an ad-hoc group for their user that contains accounts they want to keep on top of.  Where does SLX store the information of who is a member of the ad-hoc group, or just groups in general?  I've tried looking through everything in SQL to no avail.

Any help is much appreciated.

Thanks,

Nathan

[RJLedger]

Ad-Hoc group(s) are nothing more that a fixed list of ID's - there's no "SQL" involved.

It's all in the ADHOCGROUP table:

    SELECT GROUPID, ENTITYID FROM ADHOCGROUP

    ORDER BY GROUPID

The ENTITYID is the Foreign key representing the Account,Contact, etc.....  

[npepin]

Thanks RJ, that is exactly what I was looking for. However how can I find the label of each group rather then the GroupID?

[RJLedger]

SELECT A2.NAME, A1.ENTITYID

FROM ADHOCGROUP A1, PLUGIN A2

WHERE A1.GROUPID = A2.PLUGINID