I need to read out data from oracle database and present it in browser enabled form.
I made a web service which shows loginname and project-id columns from database. The loginname is an input parameter so I can browse the web service via it's url and filter data, based on the loginname field. For example: http://dev/service.asmx/getoracledata?loginname=Jonhx , so I will get the loginname and project-id data for Jonhx.
I would like to use this web service in an infopath 2007 browser enabled form. I have a text box, which is showing the current user's loginname via an integrated web service (UserProfileService.asmx). I would like to make a dropdown list which gets it's values from the oracle webservice, but shows only the relevant data about the current user. So the question is, how I can filter web service presented data for a dropdown, based on the loginname field. Has anyone an idea for this situation?