#LEFT(sqlDataArray[i][variables.ORDER_FIELD],50)#";
}
}
var retHTML = "";
var dataArray = [];
var qryData = QueryNew("tmp");
var s = 1;
var sValue = "";
//var appConfig = getGCAppConfig();
var grpObj = server.CommonSpot.api.getObject('Groups');
var groupData = grpObj.getList();
if ( StructKeyExists(groupData,'ResultQuery') AND groupData.ResultQuery.RecordCount GT 0 )
qryData = groupData.ResultQuery;
// Set the CS USER DSN from the Configuration Element
//var csUserDSN = 'commonspot-users';
//if ( structKeyExists(appConfig,"CS_USERS_DSN") AND LEN(TRIM(appConfig['CS_USERS_DSN'])) )
// csUserDSN = appConfig['CS_USERS_DSN'];
// clean the search text
if ( arguments.queryType eq "search" )
arguments.searchValues = cleanChooserSearchText(arguments.searchValues);
SELECT *
FROM qryData
WHERE GroupName != 'Anonymous Users'
AND
AND (
GroupName LIKE '%#sValue#%'
OR GroupDesc LIKE '%#sValue#%'
OR
)
AND
ORDER BY #variables.ORDER_FIELD#
AND (
Users.UserID LIKE '%#sValue#%'
OR Contacts.FirstName LIKE '%#sValue#%'
OR Contacts.LastName LIKE '%#sValue#%'
OR
)
WHERE
ORDER BY '#variables.ORDER_FIELD#'
--->