Hello, I created a new custom package to build a new custom section and business processes in. What package must mine depend on for emailing from a process to work? Right now my package depends on:

• Base
• CloudEmailService
• DesignerTools
• Managers
• MarketingCampaign
• NUI
• ProductCore

Right now I've been able to write and save processes, however the process parameters are showing up blank in the email. It works if I write the process in the normal "custom" package, but why might it not work in my new package?

I am trying to select a specific org role from a user using a Custom Query however most examples don't have Joins in them. Can someone assist?

var sql = "select sau.Id as [RoleId] from SysUserInRole suir join SysAdminUnit sau on suir.SysRoleId = sau.id and sau.SysAdminUnitTypeValue = 6 join SysAdminUnit sau2 on suir.SysUserId = sau2.id where sau2.Id = '594c5b24-147d-421f-8083-2431f71e920d'";
 
var query = new CustomQuery(UserConnection, sql);
using (var db = UserConnection.EnsureDBConnection())
{
    using (var reader = query.ExecuteReader(db))
    {
        while (reader.Read())
        {
            var Id = reader.GetString(0);
            Set("DebugRoleID", RoleId);
        }
    }
}
 
return true;