How to Populate a Combobox with Concatenated Results of a SQL Query
I have built a workflow that uses a SQL Query Activity access a pre-concatenated column from an Oracle table. The results populate the dropdown of a combobox in a form. What I actually want to do though is concatenate these 3 fields in the ComboBox in "runtime" with possibly changing the sql query to bring back 3 fields: SELECT APPLICANT_NAME, APPLICANT_ADDRESS, APPLICANT_CONTACT_NAME FROM APPLICANT_TABLEONLY. From there I would like to concatenate these fields for the selected records and have it show up in the ComboBox dropdown. Is this possible?
Anyone have experience with this?
Stephanie Patterson
0
-
How do you populate the ComboBox now? 0 -
Right now I am only querying one pre-concatenated field in Oracle using SqlQuery. This gets converted to a DataItem List and gets put into the Input Data for ComboBox. It works, but we are looking to so this at runtime, concatenating the dropdown with the three feilds in the workflow. I have tried creating three separate queries, one for each field, then attempting to concatenate the dataItemLists. It didnt work. I am fairly new to workflows so I am not sure if my logic is flawed or I am asking the workflow to do something it just cant do.
Stephanie0 -
I think you should concatenate the information in the datatable which is the result of the SQL Query, before converting it to a dataitemlist. See the approach here http://stackoverflow.com/a/9115715
You should use at least an Assign and Invoke Method activity to do this.0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
3 kommentarer