on Aug 14, 2018Hi,
I'm using the findBusinessUnits command within a request form (drop down select with web service) to display a custom attribute held against the Business Unit called 'Code' which is an abbreviation of the Business Unit name.
Is it possible to return the Code and Name columns in the drop down instead of just the code for example 'ACC - Accenture'? From initial testing it only appears possible to have either Code or Name and not both?
Additionally, the Code is key to back-end processes and is used for linking and verification. Currently if the value selected from the drop down within the form is anything other than the Code, the process will fail.
Is it possible to display different data in the form drop-down to what is then passed through in the form/request/workflow? For example, the user selects 'Accenture' from the drop-down but the value 'ACC' is passed through?
Many thanks,
Clive
You could call the WebService with two return columns. By default the drop down from select field, when more than one column is returned ... uses the first column as the value and the second column as the display name.
So in your case, say you want users to select a Business Unit name but want the variable to contain the Business Unit's code. Assuming Code is stored in CAS3, the URL you should use would be:
http://<Your URL>/aveksa/command.submit?cmd=findBusinessUnits&format=csv&returnColumns=CAS3,name&includeHeaderRow=false