#LEFT(sqlDataArray[i][variables.ORDER_FIELD],50)#";
}
}
SELECT ID, GroupName, Description, SourceDB, TransactionDate, GroupType
FROM idGroup
WHERE ID NOT IN ()
WHERE ID IN ()
ORDER BY '#variables.ORDER_FIELD#'
--->
// Get all the groups for the current user has permissions for
var groupsComponent = Server.CommonSpot.api.getObject('Groups');
var groups = groupsComponent.getList();
var qryData = "";
var dataArray = ArrayNew(1);
SELECT GROUPID AS ID, GroupName
FROM groups.ResultQuery
WHERE GROUPID NOT IN ()
WHERE GROUPID IN ()
ORDER BY #variables.ORDER_FIELD#