Populating a Parent Object lookup field with multiple child

selectNumber API will fetch you only one ID. I think you need array of IDs, so use selectQuery API (see Chapter 6 for examples)

After reading about selectQuery, I changed my Update Field Value formula to this:



var x = rbv_api.selectQuery("SELECT id FROM scholarship1 WHERE status='Open'",100);



return x;



This does not seem to work either and, according to the trigger debugger, the above formula returns null.



Thanks!

UPDATE: I removed the WHERE clause all together for testing purposes, and used the trigger debugger after changing the formula to this:



I was hoping to put the contents of the array into a string, separated by commas, then return.



When I run the trigger debugger, the trigger updates the lookup field value to "-1,-1,-1"



This tells me that the trigger knows that there are 3 records in scholarship1 (the child object), but returns -1 for the id value for each record.



Just to reiterate, this is an "Update Field Value" trigger running on the parent object "after create". I want to update the lookup field value of the parent object to all ids of the child object (scholarship1).



Am I referencing id incorrectly?

The formula won't display correctly because the "less than" sign in the for loop is being mistaken for an HTML tag, below is the formula with the less than sign replaced with the words "less than":





var x = rbv_api.selectQuery("SELECT id FROM scholarship1",100);



var y = "";



for (i=0;i less than x.length;i++){

y += x[i] + ","

}



return y;

Do you guys have any suggestions for this one? Is my use of selectQuery correct above?

Please try again after release this Saturday: I can see some issue here.

Just an update as I was able to get it to work and discovered something.



Using the debugging tools I discovered that rbv_api.selectQuery() ALWAYS returns a 2 dimensional array, even if only one field is selected in the query. In the formula above, the rbv_api.selectQuery() call returned:



{ { 618181, }, { 618186, }, { 618187, }, }



which explains why the return value was incorrect.



I changed "x[i]" in the for loop written above to "x[i][0]" and was able to get the results I needed.

Yes, selectQuery always returns 2d array: Chapter 6, page 29.

I'll make changes in the next release allowing arrays of IDs to be used in triggers.



Consider this example:



var arr = rbv_api.selectQuery("SELECT id FROM contact WHERE status=?", 'Ready');

var ids = new Array();

for (var k=0; k

ids[k] = arr[k][0];

}

return ids;