QTP 9.5 - Select an element in a table

[SAKDOSS]

Hello,

I would like to select one precise element in a table (a JTable in fact but I think it's quite similar) and I don't know how to do it.

For example, if I have the table :

Code:

Column 1  | Column 2
-----------------------
z         |   Name1
k         |   Name2
b         |   Name3
d         |   Name4

How can I select the name in "Column 2" which correspond to the line which contains 'k' in "Column 1" ?

Of course this line is not always the second.

Thanks in advance !

[supputuri]

Hi SAKDOSS ,

Code:

If Browser(X).Page(X).WebTable("index:= Here mention UR table index").Exist Then
    ColNum = Browser(X).Page(X).WebTable("index:= Here mention UR table index").ColumnCount(1)
        DesiredColNum = 0
        For colint = 1 to ColNum
            If Browser("SAM").Page("SAM").WebTable("Database:").GetCellData(1,colint) = "Column2" Then
                DesiredColNum = colint
                Exit For
            End If
        Next
        If DesiredColNum <> 0 Then
            For rowint = 1 to Browser("SAM").Page("SAM").WebTable("Database:").RowCount
                    rowval = Browser("SAM").Page("SAM").WebTable("Database:").GetCellData(rowint,1)
                    If rowval = "k" Then
                        DesiredRow = rowint
                        Exit for
                    End If
            Next
        Else
            MsgBox "Column2 is not displayed in the specified table."
        End If
        
        MyValue = Browser("SAM").Page("SAM").WebTable("Database:").GetCellData(rowint,DesiredColNum)
        msgbox MyValue
        
Else
    msgbox "Specified WebTable with ''" & Here mention UR table index & "'' is not present."
    ExitRun
End If

Please let me know if you need any more info.

[venkatbatchu]

Please see the attached document and go through the query so that u would feel much comfortable
Scenario:

When I record the application it is taking same object multiple times like “+” is a grow button then in object repository it is taking multiple times as growbutton_1, growbutton_2, growbutton_3,…..
And the same way for the fields (area, assigned to, originator) which is taking as “Select field”, selectfield_1, selectfield_2,……

While running the application as in OR it is having multiple object and able to run successfully when I use the descriptive programming it is not running successfully

My observation:
While running the application here in the first field it is taking as Area and select the field values and next it has to perform the clicking “+” button and then it has to select the another field from the second field
Observed issue:
Here it is always selecting the first field value only instead of 2,3,4,…..


Could you please share your ideas please let me know if u have any better solution for this
Thanks,
Venkat.Batchu

[SAKDOSS]

Thank you very much QTPKing.

I'm using a JTable so I modify a little bit your script (I also changed the For loops into While loops).

Code:

'String which enable to identify the line
id = "090701224501893r"

'Column where we will search id
colIdLabel = "FIX.4.2"

'Column of the expected value
colExLabel = 8

If JavaWindow("Log Message").JavaTable("MessageTable").Exist Then
    nbCol = JavaWindow("Log Message").JavaTable("MessageTable").GetROProperty("cols")

    'We are trying to find 2 columns (one for the id and one for the expected value)
    nbFindCol = 0
    
    'Find the expected columns
    i = 0
    While nbFindCol<2 and  i<nbCol
        If  JavaWindow("Log Message").JavaTable("MessageTable").GetCellData(0, i) = colIdLabel Then
            colIdNum = i
            nbFindCol = nbFindCol +1
        End If
        If  JavaWindow("Log Message").JavaTable("MessageTable").GetCellData(0, i) = colExLabel Then
            colExNum = i
            nbFindCol = nbFindCol +1
        End If
        i = i+1
    Wend
    If nbFindCol <> 2 Then
        msgbox "Error : one of the column has not been found"
    Else
        nbRow = JavaWindow("Log Message").JavaTable("MessageTable").GetROProperty("rows")

        'Find the expected row
        i = 0
        found = false
        While found = false and i<nbRow
            If JavaWindow("Log Message").JavaTable("MessageTable").GetCellData(i,colIdNum) = id Then
                rowExNum = i
                found = true
            End If
            i = i + 1
        Wend

        msgbox JavaWindow("Log Message").JavaTable("MessageTable").GetCellData(rowExNum,colExNum)
    End If
Else
    msgbox "The Java Table doesn't exists"
End If

[supputuri]

that's great SAKDOSS