Using a "Field Name" field type in a UI Action GlideRecord query

[kevinray]

Uggg...I'm so tried of staring at this code and not figuring it out. I'm sure it's simple. please help!!!

I have a form. On the form I have a "Table Name" type field, a "Field Name" type field, and a "Conditions" type field.

What i'm trying to do is create a set of records (on a different table) based on the information entered in those three fields and the"Field Name" has to be a field that represeted the 'user'. So for example,

the table could be "cmdb_ci_computer", (field name is u_table)
the conditions could be "manufacturer=aa0a6df8c611227601cd2ed45989e0ac^os=Windows XP Professional^EQ" (field name is "u_conditions")
the "Field Name" could be "assigned_to" (field name is u_associated_user_field)

So for every person that has a record on the computer table that matches those conditions, create a record in table X.

This query totally works when i hard code the field name and "not Null Query" line to "assigned to" because the cmdb_ci_computer table has the "assigned_to" field. The issue is that the user reference of a table isn't always called "assigned to" so I have to let the select the appropriate column on the table that represents a person.

This works:

//Set record to indicate Campaign has started
var gdt1 = new GlideDateTime();
current.campaign_initiated = true;
current.u_start_date_time = gdt1;
current.update();



var qLookup = new GlideRecord(current.u_table.toString());
qLookup.addEncodedQuery(current.u_conditions);
qLookup.addNotNullQuery(current.assigned_to);
qLookup.query();

while (qLookup.next()){
	var cInsert = new GlideRecord('x_26677_campaign_m_campaign_instance');
	cInsert.initialize();
	cInsert.u_agent_instructions = current.u_agent_instructions;
	cInsert.u_campaign_details = current.u_campaign_details;
	cInsert.u_campaign = current.sys_id;
	cInsert.u_customer_name = qLookup.assigned_to;
	
	cInsert.insert();
}

I'm able to get the table name in the query using current.u_table.toString() and this works fine. Figured it would work the same way for the Field Name field (on the qLookup AND the cInsert lines), but it doesn't.

This doesn't work

//Set record to indicate Campaign has started
var gdt1 = new GlideDateTime();
current.campaign_initiated = true;
current.u_start_date_time = gdt1;
current.update();



var qLookup = new GlideRecord(current.u_table.toString());
qLookup.addEncodedQuery(current.u_conditions);
qLookup.addNotNullQuery(current.u_associated_user_field.toString());
qLookup.query();

while (qLookup.next()){
	var cInsert = new GlideRecord('x_26677_campaign_m_campaign_instance');
	cInsert.initialize();
	cInsert.u_agent_instructions = current.u_agent_instructions;
	cInsert.u_campaign_details = current.u_campaign_details;
	cInsert.u_campaign = current.sys_id;
	cInsert.u_customer_name = qLookup.u_associated_user_field.toString();
	
	cInsert.insert();
}

then i tried to do it as a function.

Still dont work.....

//Set record to indicate Campaign has started
var gdt1 = new GlideDateTime();
current.campaign_initiated = true;
current.u_start_date_time = gdt1;
current.update();

createInstance(current.u_associated_user_field.toString());

function createInstance(uName){
var qLookup = new GlideRecord(current.u_table.toString());
qLookup.addEncodedQuery(current.u_conditions);
qLookup.addNotNullQuery(uName);
qLookup.query();

while (qLookup.next()){
	var cInsert = new GlideRecord('x_26677_campaign_m_campaign_instance');
	cInsert.initialize();
	cInsert.u_agent_instructions = current.u_agent_instructions;
	cInsert.u_campaign_details = current.u_campaign_details;
	cInsert.u_campaign = current.sys_id;
	cInsert.u_customer_name = qLookup.uName;
	
	cInsert.insert();
}
}

[kevinray]

First of all....YES!!! Thank you Nate. That worked. I WAS super close. Looks like my only issue was i need to use getValue instead of toString().

Second of all, thanks for the attribute mention. that's a great idea!

Cheers