Data link running but blank
I imported the server workflow example for a SQL database from this doc page. After updating the parameters, it seems like it's working, but in my VSW app there's not info actually populating in the related records. I'm trying to connect to an on-prem database server (Workflow is also installed on-prem). Wondering if I'm missing something?
Full disclosure this is my first time trying to set up a workflow and a data link. I'm confident I've entered the data table name and fields correctly, but I don't really know how to troubleshoot, or if this is something I can even do with a server-side workflow.
Connection string
Server=<server-name>;Database=<db-name>;User Id=<user-name>;Password=<password>;
Command text
SELECT COUNTY_PIN, ACRES_POLY FROM <table> WHERE COUNTY_PIN = @pin
Parameters
={pin: $inputFeature.result.attributes["COUNTY_PIN"].toString()}
Result
-
Any luck with this? I'm having the same issues.
0 -
Not yet, so if anyone is able to help out Bill and I it'd be much appreciated!
0 -
Same issue here. Added the field names from the sql query to the Field Extensions section. Then selected the icon below the tab in the initial Result Details pane and it opened another Result Details pane with the expected values.
0 -
Got it working!
0 -
Bill Everingham Hi Bill, can you share your query? It seems that is where I am struggling.
0 -
Yes anyone have input on this - I think I am stuck on the sqlquery > parameters section.
Update: I figured it out myself (as one does once they ask for help haha)
0 -
What a difference a year makes. Here's what I'm using now for anyone reading this in the future.
Connection Config Name - name of your connection that you set up per these instructions
Command Text - your SQL query, same structure as in Geocortex, including the @Parameter placeholder
Parameters - ={"Parameter name" : $forEachGraphic.item.attributes.FieldName}
0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
7 kommentarer