Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    24
  • Views views
    60
  • Users 0 members are here
Related
Options

How to Capture the Latest ID from a Web Table After Upload in UFT One?

Syahier aqif Sabri

Hi everyone,

I’m currently automating a web application using UFT One, and I need some assistance with capturing the latest ID from a web table.

Here’s the situation:

I upload a file to the web application.
The uploaded data gets added into a web table as per picture below


The new entry (including the ID) is always added to the top of the table.


What I need to do is capture the latest ID from the most recently added row, because i need to click on the Download button using Insight Recording.

Currently, error will appear if I run the script due to multiple download icons in one table.
This issue can only be solved if I search the ID, which require me to catch the latest ID in order to search for it.

Here are my questions:

1.How can I reliably get the data from the first row in the web table after each upload?
2. Is there any specific method in UFT One I should use to interact with the first row of the table?
3. Are there any best practices for handling web tables with dynamic content in UFT One?


Any advice or sample code would be greatly appreciated. Thanks!

  • Suggested Answer

    0

    Hi, I found the solution to the problem already.

    Dropping the solution here as some might face the same issue and need help.

     ' Execute the database checkpoint and retrieve the output value for Batch_ID
    DbTable("DbTable_2").Output CheckPoint("DbTable_2")
    Reporter.ReportEvent micPass, "DbTable_2", "Batch ID was retrieved successfully."

    By using Database checkpoint

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.