Skip to content

Instantly share code, notes, and snippets.

<cfscript>
q = queryNew("col","varchar")
writedump( q.getMetadata() )
writedump( getMetadata( q ) )
</cfscript>
<cfset local.type = "Investor Summary">
<cfif ListFindNoCase("Investor Summary,Preferred Agent Report Card,Agent License Information,Agent Data,Production Data,Production Data Exception",local.type) EQ 0>
<cfdump var="yes">
<cfelse>
<cfdump var="No">
</cfif>
<cfset local.type = "Task Data">
<cfif ListFindNoCase("Investor Summary,Preferred Agent Report Card,Agent License Information,Agent Data,Production Data,Production Data Exception",local.type) EQ 0>
<cfdump var="yes">
<cfelse>
<cfdump var="No">
</cfif>
<cfset local.type = "Task Data">
<cfif ListFindNoCase("Investor Summary,Preferred Agent Report Card,Agent License Information,Agent Data,Production Data,Production Data Exception",local.type) EQ 0>
<cfdump var="yes">
</cfif>
<cfset employee = [
{id=1, name="sara", dept="it"},
{id=1, name="sara", dept="it"},
{id=1, name="sara", dept="dc"},
{id=1, name="sara", dept="finance"}
]>
<cfset deptStruct = {}>
<!--- Group employees by department --->
<cfloop array="#employee#" index="emp">
<cfset employee = [
{id=1, name="sara", dept="it"},
{id=1, name="sara", dept="it"},
{id=1, name="sara", dept="dc"},
{id=1, name="sara", dept="finance"}
]>
<cfset deptStruct = {}>
<!--- Group employees by department --->
<cfloop array="#employee#" index="emp">
<cfset local.conditionalValidation = [] />
<cfset ArrayAppend(local.conditionalValidation, {"TASKACTION": {"ACTION": "pause", "DEPENDFIELD": "sel_continue_follow_up", "VALUE": "yes"}}) />
<cfdump var="#local.conditionalValidation#">
<cfset local.jsonconditionalValidation = serializeJSON(local.conditionalValidation) />
<cfdump var="#local.jsonconditionalValidation#">
<cfset variables.conditionalValidation = "#deserializeJSON(trim(local.jsonconditionalValidation))#" />
<cfset local.conditionalValidation = [] />
<cfset ArrayAppend(local.conditionalValidation, {"TASKACTION": {"ACTION": "pause", "DEPENDFIELD": "sel_continue_follow_up", "VALUE": "yes"}}) />
<cfdump var="#local.conditionalValidation#">
<cfset local.jsonconditionalValidation = serializeJSON(local.conditionalValidation) />
<cfdump var="#local.jsonconditionalValidation#">
<cfset variables.conditionalValidation = "#deserializeJSON(trim(local.jsonconditionalValidation))#" />
<cfset local.conditionalValidation = [] />
<cfset ArrayAppend(local.conditionalValidation, {"TASKACTION": {"ACTION": "pause", "DEPENDFIELD": "sel_continue_follow_up", "VALUE": "yes"}}) />
<cfdump var="#local.conditionalValidation#">
<cfset local.jsonconditionalValidation = serializeJSON(local.conditionalValidation) />
<cfdump var="#local.jsonconditionalValidation#">
<cfset variables.conditionalValidation = "#deserializeJSON(trim(local.jsonconditionalValidation))#" />
<cfset local.conditionalValidation = [] />
<cfset ArrayAppend(local.conditionalValidation, {"TASKACTION": {"ACTION": "pause", "DEPENDFIELD": "sel_continue_follow_up", "VALUE": "yes"}}) />
<cfdump var="#local.conditionalValidation#">
<cfset local.jsonconditionalValidation = serializeJSON(local.conditionalValidation) />
<cfdump var="#local.jsonconditionalValidation#">
<cfset variables.conditionalValidation = "#deserializeJSON(trim(local.jsonconditionalValidation))#" />