question

JeffJ avatar image
JeffJ asked JeffJ posted

How can I find the most recent entry in a table?

I have a customer that would like to find the most recent row of information in a table and then utilize the information in that row to proceed with the test case.

 

Is there a way to write a custom query for the table to find the most recent entry based on the time entry in one column?

iTest
10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
KumarS avatar image
KumarS answered KumarS posted
itest currently supports xpath 1.0 and I checked the xpath spec and could not find a function to convert a string to date object and then find the maximum. What I would suggest is to extract all the column values into a tcl variable and use tcl date functions to find the maximum date value.
10 |950

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.