Selecting row from Table - Java Selenium

Question

I have a quick Java table-question. I have a table, containing 4 columns, and X rows. The column's are as follows: Quote Number, Name, Date, and an Add button. I'm trying to, after looking for a specific name in the table, click on the add-button on the row the name was found.

Example:

Quote#  Name       Date        Add-Button

100001  John Doe1  01/01/1980  [Add]
100002  John Doe2  01/01/1981  [Add]
100003  John Doe3  01/01/1982  [Add]
100004  John Doe4  01/01/1983  [Add]

I've written the following code, to identify if a certain name is in the table:

public List<String> getInternetQuoteNames()
    {
        List<WebElement> webName = sh.getElements(newInternetQuotesNames);
        List<String> stringName = new ArrayList<>();
        for(WebElement name : webName)
            stringName.add(name.getText());
        return stringName;
    }

And am now trying to write another method that clicks on the correct [Add]-button, but I'm not sure how to access the correct row as I'm not good with tables. What I wrote so far is:

public void addInternetQuoteByName(String name)
    {
        List<String> listOfNames = getInternetQuoteNames();
        if(listOfNames.contains(name))
        {
            // Find row of provided name
           // Click on [Add]-button on that row
        }
    }

The HTML code for the Table is as follows:

<tbody>
    <tr>
        <td>100040365822</td>
        <td>Test06232016 Test033929</td>
        <td>06/23/2016</td>
        <td>
            <a id="assignQuoteLink_100040365822" class="add_from_pqs" href="#">Add Quote</a>
        </td>
    </tr>
    <tr class="alt">
        <td>100040365772</td>
        <td>Test06232016 Test033723</td>
        <td>06/23/2016</td>
        <td>
            <a id="assignQuoteLink_100040365772" class="add_from_pqs" href="#">Add Quote</a>
        </td>
    </tr>
    <tr>
        <tr class="alt">
            <tr>
                <tr class="alt">
</tbody>

Any tips on how to complete the method and click on the right row's [Add]-button is greatly appreciated!

From identifying what row the name looked for is found on, @mo-h — swedishcheef
– swedishcheef, Commented Jun 27, 2016 at 18:06
I call the addInternetQuoteByName("John Doe"); method, and I want to find out which row the name was found one — swedishcheef
– swedishcheef, Commented Jun 27, 2016 at 18:07
Why don't just findElement( By.xpath( '//tr/td[contains(.,'John Doe2')]/../a' ).click(); — krokodilko
– krokodilko, Commented Jun 27, 2016 at 18:07

marc_s · Accepted Answer · 2016-08-31 16:28:49Z

5

Give a try to this approach:

Get the size of the table driver.findElements(By.xpath("table xpath")).size()
Iterate over each name record in table and find if the match is found as passed in the input.
Click the add button.

Code

public static void addInternetQuoteByName(String Name) 
{
    WebDriver driver = new FirefoxDriver();
    int rowCount = driver.findElements(By.xpath("xpath of table")).size();

    for (int i = 1; i <= rowCount; i++) 
    {
        String sCellValue = driver.findElement(By.xpath("XPATH Of Name row")).getText();

        if (sCellValue.equalsIgnoreCase(Name)) 
        {
             driver.findElement(By.xpath("xpath of add")).click();
        }
    }

    driver.close();
}

xpath for name and add button have to passed as making the tr[i]dynamic for eg: .//*[@id='content']/table/tbody/tr["+i+"]/td[2]

As I was not sure of exact xpath for name and add button column I have provided an example.

Let me know if you have issues.

edited Aug 31, 2016 at 16:28

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 27, 2016 at 19:54

Amit

1464 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amit Over a year ago

pls ignore the line "driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS);"

JeffC Over a year ago

Edit your answer and remove that line yourself. You should also spend a few minutes properly formatting your code to make it readable.

JeffC · Accepted Answer · 2016-06-28 04:06:22Z

3

Here's a function to does what you requested. It grabs all the TRs, looks in the 2nd cell (TD) for the name and if found, clicks the "Add Quote" link for that row.

public void addByName(String name)
{
    List<WebElement> rows = driver.findElements(By.tagName("tr"));
    for (WebElement row : rows)
    {
        List<WebElement> cells = row.findElements(By.tagName("td"));
        if (cells.get(1).getText().equals(name))
        {
            cells.get(3).findElement(By.linkText("Add Quote")).click();
            return;
        }
    }
}

answered Jun 28, 2016 at 4:06

JeffC

26.4k5 gold badges35 silver badges57 bronze badges

2 Comments

prithvi394 Over a year ago

Above code will not work if we have multiple tables in the page! Using tagname is not the best approach.

JeffC Over a year ago

@prithvi394 True but there wasn't enough info given to specify a table and there was no information given that there was more than one table so ... this works. It can also be easily adapted in rows to only grab the TRs of a specific table. There's a much better/faster way to do this using XPath but there's not much point in posting it now.

vins · Accepted Answer · 2017-06-26 20:35:17Z

0

This requirement sounds a lot like this article. http://www.testautomationguru.com/selenium-webdriver-finding-webelements-using-map/

Basically, you need insert some javascript to create structure as shown here.

{
    "John Doe1": {
        "Add" : []
    },
    "John Doe2": {
        "Add" : []
    }   

}

then get the results returned and type caste to a Map.

Map < String, WebElement >> nameMap = ((JavascriptExecutor) driver).executeScript(queryString);

then your usage would be like

nameMap.get("John Doe3").get("Add").click();

answered Jun 26, 2017 at 20:35

vins

15.5k3 gold badges42 silver badges47 bronze badges

Collectives™ on Stack Overflow

Selecting row from Table - Java Selenium

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related