List Compare in ColdFusion

In some project requirement I just wanted to compare two lists.

Example:
List 1 =  'A,a,b,c,d,e,f,g,t,h'
List 2 = 'a,c,f'

I wanted to know all elements of list 2 should be present in list 1 with a case insensitive comparison. We can do it by looping over each and every elements of list 2 and test whether it is present in list 1 or not. But, in this way if our list size will be very big then we will end up with that loop.

So, I thought do it in some good way like below.

	<cfscript>
	public boolean function ListCompare(required string list,required string sublist,string delim=",") {
	var local = {}; //Local scope declaration
	local.qryFilterResult = queryNew(""); //Declaring query object to hold filtered list
	try {
	/* Creating a query object from the list passes in the argumnet */
	local.qryOriginalList = queryNew("");
	queryAddColumn(local.qryOriginalList, "listElement", "CF_SQL_VARCHAR", listToArray(arguments.list, arguments.delim));
	/* Filtering sublist from the list query object with distinct and case insensitive search */
	local.qoq = new Query();
	local.qoq.setAttributes(QoQsrcTable = local.qryOriginalList);
	local.qoq.addParam(name="listElement",value=uCase(arguments.sublist),CFSQLTYPE="CF_SQL_VARCHAR",list="true");
	local.qrySubListFilter = local.qoq.execute(
	sql="SELECT DISTINCT UPPER(listElement) FROM QoQsrcTable WHERE UPPER(listElement) IN (:listElement)",
	dbtype="query");
	local.qryFilterResult = local.qrySubListFilter.getResult();
	/* If resulted filtered query has record count equal to list length of the sublist then all sublist elements are present in the list. Otherwise all sublist elemnts are not present in the original list */
	if(local.qryFilterResult.recordCount EQ listLen(arguments.sublist, arguments.delim))
	return true;
	else
	return false;
	} catch(Any e) {
	/* If any error will occur during the entire process then it will return false */
	return false;
	}
	}
	writeDump(ListCompare("A,a,b,c,d,e,f", "a,b,c"));
	</cfscript>

view raw ListCompare.cfm hosted with ❤ by GitHub

Here in the above process,
- First we are creating a query object from the list in which we want to find our sub list.
- Doing a case insensitive filter on the query object.
- If sub list length is equal to the record count of the filtered query object then all elements of our sub list present in the list and return true. Otherwise return false.