Select the row in WEBTABLE/WEBGRID using QTP/DOM

By -
Hi All,

I found that most of time while working with WEBTABLE we need to the select the row based on some criteria by clicking checkbox or radiobutton.For that first we have to find the row which we have to select based on value of that row like text/link inside the row.
Here I am giving an example how to select a row in Webtable by finding the text. Logic I am using here is first i will find the row number from webtable where my searching text is present using GetRowWithCellText method then I will provide the column name/index of webtable where checkbox is present.


In below mentioned example I will select the row where Confirmation Number is "15204"
Let's see



Select Date ConfirmationNumber User Name Organization Name


17-SEP-2008
13761

 SMITH'S LP SUPPLY CO. 


24-OCT-2008
13808

 Micro Motion test1 


30-OCT-2008
13874

 EMERSON PROCESS MANAGEMENT ASIA PACIFIC PTE LTD 


13-JUN-2009
15058

 Spartan Controls Ltd. 


08-AUG-2009
15204

 Emerson Process Management 

REM find the row number  where "15204" text is present using GetRowWithCellText method

GtRowN = Browser("XYZ").Page("OBC").WebTable("Request Summary").GetRowWithCellText("15204")

REM check text find in webtable or not
     If  GtRowN >0 Then
   
          REM  coulmn index  where  checkbox  is present
          Rem here select coulmn name index value is 1
          CoulmnIndex = 1 
         
    REM create the checkbox object  after getting the rownumber and select the row by clicking the checkbox

            set objCheckbox = Browser("XYZ").Page("OBC").WebTable("Request Summary").ChildItem(GtRowN,CoulmnIndex,"WebCheckBox",0)
       
           objCheckbox.set "ON"
       
    else
         msgbox "Did not find the value test fail"
     End If

Comments

  1. QPT30 August 2011 at 00:45

    Hi,

    First of all want to Thank You for your useful post.
    This Software Testing article is very useful for me. I would like to introduce another good site which is having Software testing and QTP content, Have a look.
    QTPbook

    ReplyDelete
  2. Anonymous29 September 2011 at 00:42

    Thank you it was very useful :)

    ReplyDelete
  3. Anonymous2 April 2012 at 20:34

    Thnks much... it worked for me... here is my code... but I think VSTS Automation is a much better tool where we can handle all such things very easily..

    intRowNum = browser("General Documents").Page("General Documents").WebTable("Docs").GetRowWithCellText("SRS")
    If intRowNum > 0 then
    Set lnkFile = browser("General Documents").Page("General Documents").WebTable("Docs").ChildItem(intRowNum,2,"Link",0)
    lnkFile.Click
    else
    msgbox "SRS not found"
    end if

    ReplyDelete
  4. Anonymous2 April 2012 at 21:43

    Here is the VSTS Automation code for it, using C#...

    foreach (HtmlRow row in this.mUIGeneralDocumentsWindWindow.UIGeneralDocumentsDocument.UIOnetidDoclibViewTbl0Table.Rows)
    if (row.InnerText.Contains("SRS") == true)
    Mouse.Click(row, row.GetClickablePoint());

    ReplyDelete
  5. Anonymous28 May 2012 at 23:21

    how to perform the same task using Web Grid?

    ReplyDelete
  6. Anonymous8 August 2012 at 08:08

    gr8 article, thanks a lot...

    ReplyDelete
  7. Anonymous5 January 2014 at 19:10

    Good Article...It worked for me but I didnt get where we have used DOM?Please explain brifly as I am new to the QTP and I dont know abt DOM.Thanks.

    ReplyDelete
  8. Anonymous12 February 2014 at 06:09

    Thanks for the info but it is not working as displaying "Object Required Error" .

    ReplyDelete

Post a Comment

Popular posts from this blog

EXTRACT CSS PROPERTY VLAUE OF PSEUDO ELEMENTS CONTAINING :after/:before CSS TAG USING JAVASCRIPT IN WEBDRIVER :

By -
Image
We cannot extract css properties of pseudo elements using web driver commands such as ‘.getPropertyValue’ . For this, we need to use JavaScript and execute a js script in selenium web driver. A CSS pseudo-element is used to style specified parts of an element.    For example, it can be used to:    Style the first letter, or line, of an element    Insert content before, or after, the content of an element ISSUE: In above scenario, we need to get the text “Internal Use Only” from UI which is associated with an Anchor (a) tag in DOM with :after CSS tag. The text is present in “content” Style Property as shown in right highlighted box. The :after CSS tag cannot be located directly using web driver and thus required text cannot be retrieved simply by using .getPropertyValue() function in selenium. To achieve this, a javascript needs to be executed in our selenium code : WebElement elementObj = driver . findElement ( By . xpath...
Read more

Jmeter bean shell script, create file, read jmeter variable value, store script variable value into jmeter variable

By -
Image
Hi All, Some times in JMeter scripting we need to store the output value in file or wanna show the run time  variable value in console window. OR we need to get the current JMeter script directory path. This can be achieved via scripting in Bean Shell Pre/Post Processor. Here I am using time and counter function of JMeter to create the file.In bean shell scripting we are reading the JMeter variables value and storing script variable value into JMeter variable or creating Jmeter variable Here is the  Bean Shell script : import org.apache.jmeter.services.FileServer; import org.apache.jmeter.services.FileServer; import java.util.Date; import java.text.SimpleDateFormat; SimpleDateFormat formatter = new SimpleDateFormat( "yyyyMMddHHmmss" ); String datetime = formatter.format( new java.util.Date() ); // Get current running counter value(C refrence name deifned in counter config element) String counter= vars.get("C"); // Get Jmeter variable value in bean she...
Read more

Difference between action.build().perform() and action.perform()

By -
In Webdriver, handling keyboard events and mouse events (including actions such as Drag and Drop or clicking multiple elements With Control key) are done using the advanced user interactions API . It contains Actions and Action classes which are needed when performing these events. In order to perform action events, we need to use org.openqa.selenium.interactions.Actions class. The build() method is used compile all the listed actions into a single step. we have to use build() when we are performing sequence of operations and no need to use only if we are performing single action. example where build() required Actions builder = new Actions(driver); builder.clickAndHold((WebElement)listItems.get(0)) .clickAndHold((WebElement)listItems.get(3)) .click() .build() .perform(); in the above code we are performing more than one operations so we have to use build() to compile all the actions into a single step example where build is not required WebElement draggable = driver.find...
Read more