fiogf49gjkf0d Here is some sql that will return the group plugins that the user has access to (just replace ADMIN with the appropriate userid):
SELECT
P.PluginID , P.Type , P.Family , P.Name, P.UserID, P.Dev, P.Released, P.Basedon
FROM
Plugin P
INNER JOIN SECRIGHTS S_AA ON (S_AA.ACCESSID = 'ADMIN' AND P.USERID = S_AA.SECCODEID )
WHERE
P.Type = 8
AND (
(P.UserID = 'ADMIN' AND P.Dev = 'T')
OR
(P.UserID <> 'ADMIN')
)
ORDER BY
P.Dev Desc, P.Type , P.Family , P.Name
You will also want to add a filter on the Plugin.Family if you only want Contact groups. Once the user selects the group you can use the pluginid to get the sql via the Application.BasicFunctions.GetGroupSQL(GroupID) function.
Hope that helps!
Timmus |