Get a single variable from SQL results

Permanently deleted user

20. April 2017 15:31

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

• 

  Permanently deleted user

  21. April 2017 07:34

  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
• 

  Permanently deleted user

  27. April 2017 04:08

  Of course now I understand. Thankyou Francesca.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.