var qryData = QueryNew("temp");
var userStruct = StructNew();
var userArray = ArrayNew(1);
SELECT Users.ID, Users.UserID, Contacts.LastName, Contacts.FirstName, Contacts.Middle,
Contacts.LastNameLetter, Contacts.EmailAddress
FROM Contacts
RIGHT OUTER JOIN Users
ON Contacts.ContactID = Users.ID
WHERE Users.ID =
if ( qryData.RecordCount GT 0 )
userArray = Application.ptPortlet.data.queryToArrayOfStructures(qryData);
if ( ArrayLen(userArray) )
userStruct = userArray[1];
var userName = getCSUserInfoByID(arguments.ID).UserID;
if ( Len(Trim(userName)) EQ 0 AND arguments.showNullMsg IS true )
userName = '[user name error]';
var userEmailAddress = getCSUserInfoByID(arguments.ID).EmailAddress;
if ( Len(Trim(userEmailAddress)) EQ 0 AND arguments.showNullMsg IS true )
userEmailAddress = '[no email address listed]';
var qryData = QueryNew("temp");
var userNameList = '';
SELECT ID, UserID
FROM Users
WHERE ID IN ()
if ( qryData.RecordCount GT 0 )
userNameList = ValueList(qryData.UserID);
var qryData = QueryNew("temp");
var userEmailList = '';
SELECT Users.ID, Users.UserID, Contacts.EmailAddress
FROM Contacts
RIGHT OUTER JOIN Users
ON Contacts.ContactID = Users.ID
WHERE Users.ID IN ()
if ( qryData.RecordCount GT 0 )
userEmailList = ValueList(qryData.EmailAddress);
// Get the CE Data
var dataArray = ArrayNew(1);
var qryData = QueryNew("temp");
SELECT Users.ID, Users.UserID, Contacts.LastName, Contacts.FirstName, Contacts.Middle,
Contacts.LastNameLetter, Contacts.EmailAddress
FROM Contacts
RIGHT OUTER JOIN Users
ON Contacts.ContactID = Users.ID
WHERE #TRIM(arguments.dataField)# NOT IN ()
WHERE #TRIM(arguments.dataField)# IN ()
ORDER BY '#TRIM(arguments.orderField)#'