Get a single variable from SQL results
Hello,
I have two databases that hold Organisation ID differently.
In my workflow I have an SQL that gets the list of available Org_ID1 s from the first DB. The user selects that from a form combobox and I am able to get that converted to a string.
I then want to perform a second SQL that will use the Org_ID selected above as a parameter so to return the corresponding Org_ID2 from the second database. This SQL will only return a single row, but I am struggling as to how I would be able to access this Org_ID2 and assign it as a string variable.
I know this is a fairly fundamental concept, I just dont understand how to do this in Geocortex workflows with the available activities. DataTableToDataItemList seems to be the direction I am heading, my question is how do I best get this single value from the resulting DataItem List?
Any pointers would be greatly appreciated.
0
-
Hi Justin,
Not sure that I understand fully your question but If your second SQL is performed by SQLQuery activity you can access the value with an assign where the Value can be something like (reportRowsDataTable.Rows(0)(0)).ToString where you can get the value of the first row column of the dataTable. You can also replace column index with the column name in case more columns are returned.0 -
Of course now I understand. Thankyou Francesca. 0
Please sign in to leave a comment.
Comments
2 comments