Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Tuned Listener
Posts: 7
Registered: ‎08-17-2009

Ad-Hoc Group Storage

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

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Ad-Hoc Group Storage

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

  

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Tuned Listener
Posts: 7
Registered: ‎08-17-2009

Re: Ad-Hoc Group Storage

Thanks RJ, that is exactly what I was looking for. However how can I find the label of each group rather then the GroupID?
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Ad-Hoc Group Storage

SELECT A2.NAME, A1.ENTITYID

FROM ADHOCGROUP A1, PLUGIN A2

WHERE A1.GROUPID = A2.PLUGINID 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101
alt
".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html