11-19-2009 01:09 PM
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.
11-19-2009 03:12 PM
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.....
12-08-2009 03:29 PM