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

Follow

Bret McGaughy-LEFT COMPANY

February 04, 2016 03:19

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

0

• 

  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.

  0

  Comment actions Permalink
• 

  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

  0

  Comment actions Permalink
• 

  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

  0

  Comment actions Permalink
• 

  Prajakta February 04, 2016 16:19

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

  0

  Comment actions Permalink
• 

  Bret McGaughy-LEFT COMPANY February 09, 2016 15:19

  That got it! Thanks!

  0

  Comment actions Permalink

Please sign in to leave a comment.