Why is the data from this SQL Query not showing up in the form field?

I am tyring to pull back some data to a field in a form from a Sql database. I am using a trigger to run a business rule that will query the database. When I look at the Debug results (See Results), I can see that the correct data is being pulled from the database, but the field in the form is not displaying anything. The business rule reads:

/*member Date_of_Incident, resultSet*/
if (Search.clicked){
var y;
eval('y='+http.get('http://localhost:8082/database/IncidentReport/DataLookup?TrackingNo='+TrackingNumber.value));

y.resultSet.Date_of_Incident = DateofIncident.value ;
}

Debug results.PNG
Query in config file.PNG

Prajakta

February 04, 2016 14:23

Hi Bret,

Please replace:

y.resultSet.Date_of_Incident = DateofIncident.value ;

with:

DateofIncident.value = y.resultSet.Date_of_Incident ;

Thanks.

Bret McGaughy-LEFT COMPANY

February 04, 2016 16:16

I made the suggested change and know I am getting an error.....

[line 107] Cannot set 'value' as 'undefined' (SourceFile#107)

Capture.PNG

February 04, 2016 16:19

Please see this form post which discusses how to resolve that error.

February 09, 2016 15:19

That got it! Thanks!

Why is the data from this SQL Query not showing up in the form field?

Comments

Didn't find what you were looking for?