Variables in DB Table (query) variable
Would be nice if I could add a variable in the DB query variable, so it would be more flexible. Because now I need to build the entire script if I only want to add variable in the query or I need to add many DB Table variables if I only need to change one parameter in the query. Example in the screenshot.
Script Test - Show Usage/references
When we create reusable script routines to serve some common purposes, and use the same in different script files, and functions, TestComplete should have the ability to find and show all the usage / references of the reusable function, like the other standard IDEs.
TestComplete - DB Table local variable not refreshing
Hi, I have a test case where I manage the status of a request, and everything works fine when I run it individually. The issue appears when I execute it as part of a test set: I need to use that case multiple times, but the local variable (which is a DB Table type) does not refresh. It keeps the same value from the first execution instead of updating with the new query result. At the end of the first case, the request status changes. In my query, I filter requests so that it only returns those with a specific status (for example, status = 1). Therefore, once the status changes, the same request should no longer be returned. Has anyone faced this situation? How can I force a local DB Table variable to refresh its data every time the test case runs inside a test set?
Checking API Status in TestComplete
Introduction I first saw the need to verify the state of an API several years ago with an application that used an address validation API in several of it's operations. If this API was down or did not respond in a timely manor, many of the automated test cases would run and fail. In this case, and in others, I have found that doing a simple call to the API to check the returned status code allowed me to skip, fail or log a warning with a logical message instead of allowing the application to fail with another less direct error message due to the API issue. The aqHttp Object The TestComplete aqHttp object and it's methods are very useful for performing simple checks like this and are also useful for other more complex tasks like leveraging an API to return a test data set or even verifying a certain data is returned prior to running tests against the UI that depend on the data. Sending and Receiving HTTP Requests From Script Tests More Complete API Testing Most proper API testing should be done using a tools like ReadyAPI or SoapUI. Both of these tools will integrate with TestComplete or can be used alone and will provide much more capabilities and automation options. Integration With ReadyAPI and SoapUI Code Example Here I have provided a working example of how to code a Get request using 'aqHttp.CreateRequest' to confirm an API returns a status code of 200 and it will log the returned records. function sendGetRequest() { let resourcePath ="https://restcountries.com/v3.1/all" let resourceQuery = "?fields=name,capital"; let url = resourcePath + resourceQuery; try { // Send GET request let response = aqHttp.CreateRequest("GET", url, false).Send(); // Check for successful response if (response.StatusCode === 200) { // Parse JSON response let allData = JSON.parse(response.Text); Log.Message("Total records received: " + allData.length); // Process each record allData.forEach((record, index) => { Log.Message("Record " + (index + 1) + ": " + JSON.stringify(record)); }); return true; // Send a bool back to the calling function. } else { throw new Error("Failed to fetch data. Status code: " + response.StatusCode); } } catch (error) { Log.Error("Error during request or data processing: " + error.message); } } Enhancements You could accept parameters for the resourcePath and resourceQuery. Parameterize the logging loop run or remove it. Return the JSON to the calling function for use. Perform other tasks based on the return code. Conclusion With the growing use of API calls in desktop applications and the fact that APIs are almost the foundation of any web site checking an API before a test case run is almost a requirement for consistent test runs and good error logging. This small script can bring big rewards to your test runs and reports. Cheers! I hope you find it as useful as I have! If you find my posts helpful drop me a like! 👍 Leave a comment if you want to contribute or have a better solution or an improvement. 😎 Have a great day
Problem with generated data table and keyword test
Dear Community, I have a problem with a created table type project variable. Here is my script, I checked data inside the generated table and everything is OK for the table. function CreateTestExecutionDataTable(){ // Create a table variable if it doesn't exist if(!Project.Variables.VariableExists("TestExecDataTable")) Project.Variables.AddVariable("TestExecDataTable", "Table"); // Get a reference to the variable var t = Project.Variables.VariableByName("TestExecDataTable"); // Add columns to the table t.AddColumn("Test Execution"); t.AddColumn("Environment"); t.AddColumn("Build Type"); t.AddColumn("Team"); // Create rows TestExecutionData.testExecutionList.length-2 t.RowCount = testExecutionList.length-2; Log.Message("Length of the execution table "+t.RowCount) for(let i = 0; i < t.RowCount; i++){ t.$set("Item","Test Execution", i, testExecutionList[i+2]); t.$set("Item","Environment", i, environmentList[i+2] ); t.$set("Item","Build Type",i, buildTypeList[i+2] ); t.$set("Item","Team", i, teamList[i+2]); } } Then I want to integrate a Data driven loop that will perform actions for each item in the table var. The problem occurs when I want to choose some values and perform actions, because I don't see anything. I don't have any idea about how to use this generated table in my keyword test. Does anyone have an idea? Thank you for your help.
Github Copilot Integration
GitHub Copilot suggests code completions as developers type and turns natural language prompts into coding suggestions based on the project's context and style conventions. One new idea would be having a copilot plugin for testcomplete would increase productivity and coding efficiency URL for reference - https://github.com/features/copilot
Test steps get disabled automatically when a TestExecute test run fails in Azure pipeline
We have test scripts running in an Azure release pipeline, using the TestComplete adaptor (TestExecute as "preferred test runner"), and Visual Studio Test. We do NOT have the "Rerun failed tests" option in the Visiual Studio Test task enabled. If I have a test script, with all steps enabled in the execution plan, and any of these steps fail - when I log onto the agent virtual machine that has run the tests, I can see that the Execution Plan has all the passed test steps disabled and the failed test steps enabled. I've searched everywhere to find what controls this behavior, but cannot find anything. If a test fails I do not want any changes to the Execution Plan to be made automatically. Please could anyone help advise about this issue? Thank you.Property check point does not work with multiline data in a csv
col1,col2,col3 test1,"test2.1 test2.2 test2.3",test3 A similar to this csv is what I am using in the data loop, and in the "Quoted Text" section I am using ", when I look at the file in that section it displays like this col1,col2,col3 test1,test2.1 test2.2 test2.3",test3 and the property check point is failing Actual Value: "test2.1↴test2.2↴test2.3" Expected Value: "test2.1" Please show me the right path, the guidance, the light.
