I use a global method to show search suggestions in a text field. The problem I have now is, that I need to store the displayValue in the database, but I need the realValue to fill other fields with informations from the table, where I get from the search suggestions.
I tried to use a form variable as dataprovider for the field, for which I show the search suggestions. The form variable is type Media. If I fill the result that is returned for the field, that shows the suggestions, is it possible to return all needed values in this line: “result = databaseManager.convertToDataSet(fs,[‘column_one’,‘column_two’]);”? For example: “result = databaseManager.convertToDataSet(fs,[‘column_one’,‘column_two’,‘column_three’,‘column_four’]);”?
How can I get the above result in my form variable / dataprovider? I need all the columns that added to the dataset.