Re: Verify data between two SQL table data connections - Browser based form

Edwin Brito — Tue, 31 Jul 2012 03:07:36 GMT

Without an screenshot is a little difficult to visualize your scenario. As far as I understand, it seems that this can be solve using a rule that assigns a value to the filed you want to calculate. A filter might be requiered to filter the value based on the parameters you defined.

Create a filed called 'location'

Select the variable field ('employeeID') and create a rule called "Location"

Conditions: None

Rule Type: Action

Run these actions:

Set field value

Field: Location

Value: click on "fx" > In the Insert formula dialog box:

"Insert filed or Group..." > Navigate to the location you want to insert from the data connection (secondary)

Click on: "Filter the data..." > "Add..." > Create a condition where the Zip Code on the main connection is equal to the Zip Code on the secondary connection.

Verify data between two SQL table data connections - Browser based form

Big E — Mon, 30 Jul 2012 21:20:45 GMT

Alright, here is the skinny. I have two sql tables that I am pulling in for a read only data connection. I have setup a udc connection for both of these and they are working fine. What I am trying to do is write a value to a field from one dataconnection based on a condition from the second data connection.

I currently get the value of 'Zip Code' by creating a conditional filter on the datasources. Here is the xpath for that statement:
xdXDocument:GetDOM("DATABASE_TABLE1")/dfs:myFields/dfs:dataFields/d:DATABASE_TABLE_1/@ZIP_CODE[../@EMPLID = current()]
Simple enough. I receive the value of the first name based on the current employee ID that was selected in the dropdown that is performed by a rule.

Based on this, I would like to get a location name from a different datasource (DATABASE_TABLE_2) and have the data match up based on the zip code in DATABASE_TABLE_1. Since the zip code would be the primary key in both data sources, I figure this would be the way to go.

I am having issues trying to get this worked out. Does anyone know if this seems like it could work?

Thanks,
Eric

SQL Database Integration

Re: Verify data between two SQL table data connections - Browser based form

Verify data between two SQL table data connections - Browser based form