Forum Discussion

Arunachalam's avatar
Arunachalam
Occasional Contributor
5 years ago
Solved

Script code for Checkpoint validation

Hi,   The output log of "aqobject.checkproperty" either success or failure log can be stored in any external excel file by using script code. If any Script is available to share it.
  • Wamboo's avatar
    Wamboo
    5 years ago
    function storeLogInExternalFile(Object, Property, Condition, Value)) {
	
	var obj = {
		testItemName: Project.TestItems.Current.Name;
		testItemProperty: Property
		testItemValue: Value
		theValueIsCorrect : false;
	}
	
	(aqObject.CheckProperty(Object, Property, Condition, Value)) ? obj.theValueIsCorrect = true  : obj.theValueIsCorrect = false;
	
	let dataToExcel = JSON.stringify(obj);
	
	// put this data into file
}

    or store data into long string and put it into one cell in excel and into another one the name of the test item.

    Check in documentation that connection between TestComplete can accept JSON object as parameter. If yes you have good example.

Wamboo's avatar
Wamboo
Community Hero
5 years ago

Hey,

 

What exactly do you want to do with the data in the file? must be excel? in which language do you write?

  • Arunachalam's avatar
    Arunachalam
    Occasional Contributor
    5 years ago

    Wamboo 

     

    1. Our framework script in Javascript.

    2. I need to store the log (which means success or failure ) into some excel sheet using the DDT driver method or any other method.

     

    • Wamboo's avatar
      Wamboo
      Community Hero
      5 years ago
      function storeLogInExternalFile(Object, Property, Condition, Value)) {
	
	var obj = {
		testItemName: Project.TestItems.Current.Name;
		testItemProperty: Property
		testItemValue: Value
		theValueIsCorrect : false;
	}
	
	(aqObject.CheckProperty(Object, Property, Condition, Value)) ? obj.theValueIsCorrect = true  : obj.theValueIsCorrect = false;
	
	let dataToExcel = JSON.stringify(obj);
	
	// put this data into file
}

      or store data into long string and put it into one cell in excel and into another one the name of the test item.

      Check in documentation that connection between TestComplete can accept JSON object as parameter. If yes you have good example.