#thisList#
#newList#
function ListDeleteDuplicates(list) {
var i = 1;
var delimiter = ',';
var returnValue = '';
if(ArrayLen(arguments) GTE 2)
delimiter = arguments[2];
list = ListToArray(list, delimiter);
for(i = 1; i LTE ArrayLen(list); i = i + 1)
if(NOT ListFind(returnValue, list[i], delimiter))
returnValue = ListAppend(returnValue, list[i], delimiter);
return returnValue;
}
var qList = queryNew("");
var qColumn = listToArray(arguments.list);
var qReturn = "";
queryAddColumn(qList, "list", qColumn);
SELECT DISTINCT(list) AS listItem
FROM qList
newList = createObject("java","java.util.HashSet").init(listToArray(thisList)).toString();