Extract specific value from dropdown

[mlt]

Hi guys,

Im having some problems to extract an specific value returned by SQL Statement from a Dropdown.

Here is my situation.

Im login in into a WebPage , that's ok. Once im logged in , i must select an specific value from a dropdown, wich is not always in the same position (index) , in order to view and download some information.

I ve tried using Manage Web Control, and did not work.

Is there a way to find value by name (so i use $DataSet Column()$) and not setting index position in dropdown ?

Thanks for your help.

[forumsupport]

Hello,

Using 'Manage Web Control' command, you can select item by text. Just capture the control and use variable in place of actual value you captured using F2 key and save the command.

Otherwise, try using 'Manage Windows Control' (MWC) command to capture the control. With this command, you can select item by text in similar way. You can MWC command under 'Programs/Files/Windows' command category.

If you can send URL of website then we can create sample task as per the requirement.

Hope that helps.

[mlt]

Hi experts, thanks a lot for your help.
Now it works perfect.

But im having another problem. Im Looping for each row in Query Dataset as i said before , and everything works fine only in the 1st loop. In second, AA throws me an error while trying to insert username into the webpage wich it was already loaded. It said that it cannot find user textbox.

I ve attached an example. For security reasons i cant give you username and password.

Thanks for your quick response.

cheers.

[forumsupport]

Hello,

What we suggest is, make use of 'Navigate URL' command inside the loop instead of opening and closing the browser in each iteration.

We have amended the task for your convenience.

Also, we would recommend using latest version of Automation Anywhere i.e. version 5.5.1 as it includes bug fixes and many new enhancements.

You can download free trial version of Automation Anywhere 5.5.1 from our website: Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.

Note: The task is modified in version 5.5.1.

Hope that helps.